rakesh_2004
New Contributor
Joined 7 years ago
User Profile
User Widgets
Contributions
Passing Parameters to Digest MD5 function
Hi, I am trying to read data for multiple tables from SQL server using a parent-child pipeline combination. As part of the process I will also need to determine the CDC. Now i have to sort the data before I send to Diff snap or write my own Logic. As I will be processing multiple tables from the same child pipeline i will not be able to select the fields in the Sort snap for Sort Path because each table will have different primary key columns and some times composite primary keys. So what i was thinking instead to concat the primary key values and then pass them to Digest.MD5 function so that it becomes one single column which i can then use for sorting data and determining CDC. The issue i am facing is if i create a pipeline parameter and pass the fields that needs to be concatenated then it is not working. But if i select the fields in expression builder manually then it is working. How do i pass the values of the strings that needs to be concatenated as parameter? Working: “”.concat($Emp_ID, $Group_ID) when selected from Source data coming Not working: Primary_Key = $Emp_ID, $Group_ID…parameter declared in pipeline properties “”.concat(_Primary_Key)…It is creating output of ($Emp_ID, $Group_ID)2.8KViews0likes2CommentsRe: Dynamic DB Account Use Cases
Thanks for the details. Did you pass the parameters from pipeline parameters? I have cretaed a parent pipeline where i have read the parameters from a file and then passing them to child pipeline where i have the MySQL execute snap. In the account tab of My SQL execute i want to create a connection dynamically by using the parameters coming from parent pipeline which are coming from the file.2.4KViews0likes3CommentsRe: Dynamic DB Account Use Cases
I have few questions: In the snapLogic create snap when i am choosing Account it does not ask any of the properties that is mentioned in the conversation. So if i want to create an Account which will be connect to different SQL database based on parameter how to create that? If you are creating the dynamic account from Manager then what is the syntax to refer to a pipeline parameters? My use case is, i want to create account dynamically taking inputs from a file and then use the account created in the first pipeline to fetch data from another pipeline.2.4KViews0likes0Comments