How to create Dynamic connection to Input/Output Tool

Question

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?

cvalteryx · Answer

@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?

Felipe_Ribeir0 · Answer

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.