How to set username& password prompts for Database Connections in FME workflow ?
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
+15- Contributor
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
+21- Safer
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.
+21- Safer
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.