How to create a file with db connections in Input Data tool

SrilekhaVeluri

I am trying to create a workflow with multiple inputs.

 Depending upon the requirement these workflows need to be run on different databases.

I am trying to create a file with connection list that I can select via the analytic app. I know that this can be done in the IN-DB connections but trying to make it work in the input tool.

can some-one help? 

JoeS

---

@SrilekhaVeluri wrote:

Thank you for the response. I am already connected to the db using the connect a File or Database option.  I have connected with an oracle OCI . Just wondering if we can use an update tool or something to pass the database connection as a variable

---

Yeah, you should be able to use the action tool to update the file or database option part of the input tool.

You'd could create a batch macro, you can then pass through the data connection as a control parameter.

Or use a normal macro and have a dropdown interface question that allows the user to select which one they'd like.