Is it not possible to change the values from this connection in the navigator to user parameters? Edit:

I did see few related articles mentioning this approach. Unfortunately, I don't see these Parameters options both in my reader as well as the Database Connection.

2.jpg

Hi @dilipsebastian, you should be able to create a private parameter for your Oracle connection string. In that parameter, you can reference 2 public parameters that prompt the user for a username and password. Ex- $(username)/$(password)@//<host>:<port>/<SID>

You can read more about concatenating published parameters here.

Thanks for your valuable inputs TiaAtSafe and JeroenR .

Meanwhile I figured out what went wrong. Previously while creating Database Connection using "Add Reader as Resource", I kept choosing "Add Database Connection" from the Dataset dropdown. This was the reason why I wasn't able to see username and password as parameters. This time I chose "Embed Connection parameters" as the dataset choice, and I can now see username and pwd listed as parameters. I went ahead and created published user parameters for both and used them in the readers and transformers in my workflow.

Thanks Again.