How to pass User ID and password using Interface tools to the Dynamic Input tool

Question

Hello,

I have a workflow in which I have Dynamic Input tools which queries data from multiple Teradata tables. How can I update the User ID and password using Interface tools from the Input Data Source Template in the Dynamic Input Tool. I can update the User ID and password manually, however I want to convert the workflow to an app so that the User gets a pop up to enter User ID and password

Raj_007 · Answer

Hi, I am looking for the same scenario - but in my case - i pull the ID and pwd from the database then I need to pass the password to the connection string in dynamic input

when I try to use the replace string __EncPwd1__ with the password field coming from the database table it says cannot find file some weird error

can you please suggest

Robin_McIntosh · Answer

Try this.  You'll need to update the DSN within the Dynamic Input Tool template as well as a valid SQL.

The Interface tools ask for ID and Password (which has the masking checkbox valued) and updates the connection string.  You can also do this with just a Data Input tool as well.

Dynamic_Input_DB_Creds.yxwz