How to create Dynamic connection to Input/Output Tool

[cvalteryx]

Hi,

Is anyone aware on how to pass dynamic connection string(any source/destination) to Input/Output tool so that connection would update dynamically to a pre-defined Macro? Using Control Parameter or any variable?

Example: If we take up SQL Server connection

Can we pass ConnectionName, HostName, UserName, Pwd, DatabaseName,TableName dynamically so that connection string would update?

Is connection would we stored somewhere in file system as an xml file?

 

[Felipe_Ribeir0]

Yes, i am using something similar to that because here i have rotative passwords, so i need to pick the current password from a source and pass it macros. It works fine.

[cvalteryx]

@Felipe_Ribeir0  - I need HostName,  DatabaseName, UserName, TableName along with Password to be updated. So that connection will update based on my Input values. How I can accomplish that? How can I edit the connection dynamically?