vish
Former Employee
Joined 9 years ago
User Profile
User Widgets
Contributions
Re: Storing each document into database table.. [xmlformatter --> generic jdbc insert]
Hello Kiran, Could you share the output of the XML formatter as well as a screenshot of the mapper? Most likely, you’d need to use the JSON Splitter snap after to ‘flatten’ the data to fit into a relational database. Thanks!2.4KViews0likes1CommentOracle to Snowflake Schema Replication
Created by @vish This pipeline pattern replicates Oracle table schema and loads data into Snowflake. Configuration Sources : Oracle table Targets : Snowflake table Snaps used : Oracle - Select, Snowflake - Bulk Load Downloads Oracle to SnowFlake.slp (4.2 KB)3KViews0likes0CommentsTableau Injest from Workday
Created by @vish This pipeline gets information from a Workday Journal and sends it to Tableau Configuration Sources: Workday Journal Targets: Tableau Snaps used: Mapper, Workday Read, Head, Conditional, Tableau REST Downloads Workday to Tableau.slp (12.4 KB)2.5KViews0likes0CommentsRe: Creating users in Active Directory
Hi @Rod, It has been a long time since I looked at this 🙂 I don’t remember exactly but I think I’ve always used useraccountcontrol 544 to force a password change on 1st login. I’d suggest starting here: New-ADUser | Microsoft Docs and make sure you are setting the right attributes like useraccountpassword and also ensure you have the right user account control value (list of values here: All Codes (by Rajnish Bhatia): Active Directory userAccountControl Values)3.6KViews0likes0CommentsSync data from Workday to Anaplan
Created by @vish This pipeline pattern syncs journals from Workday financials to Anaplan. Configuration Sources: Workday Financial_Management/Get_Journals Targets: Anaplan any model Snaps used: Mapper, Workday Read, Head, Conditional, CSV Formatter, Anaplan Upload, Anaplan Import Downloads Workday to Anaplan.slp (14.8 KB)3.9KViews0likes0CommentsCreating users in Active Directory
Here are a couple of screenshots that show how you can connect with an Active Directory instance and create a new user. You will require an Active Directory account that is configured as follows: The second snap that would be required is the Create AD Entry snap that allows you to create an entry in a particular DN and select the attributes that need to be set up at a bare minimum. Additional attribute keys can be selected to be populated by clicking on the selection bubble and entering static values or from an input view connected to an upstream snap.6.7KViews0likes6Comments