pass connection string to either input data tool or dynamic input tool

Question

Hi, could someone please guide me through this

What are you trying to do? I have an OCI connection string and we hard code the password in it. I want to store the password in a SQL server database so i can pull the password instead of hard code

Since the input data does not allow - I have tried to use the dynamic input but not sure how i can tell this to use the connection string that is coming from another tool

any suggestions

N730207_Testing_WIP_V1.yxmd

Raj_007 · Answer

I did created an odbc locally in my desktop - Just for testing i used the input data tool - and specified the odbc

odbc:DSN=TESTDC01; UID=TEST01_USER102;    PWD=__EncPwd1__

when I try to run this in server it  failed  because we do not have the DSN=TESTDC01 server

data source name not found..

Raj_007 · Answer

Hi Kavya, we only use the oci connection format; our server do not allow the dsn format because they do not help creating the dsn on server

nagakavyasri · Answer

@Raj_007 try using this:

Edit the Input Data Source Template to connect to ODBC and then in Modify SQL Query, select Replace a specific String.