AnsweredAssumed Answered

Import Records (ODBC Data Source) Credentials

Question asked by deninger on Jan 21, 2016
Latest reply on Jan 21, 2016 by tcfitzgerald

I use the script step Import Records (from and OBDB source) in several places throughout the solution.

 

The ODBC data source is defined under File -> Manage -> Manage External Data Sources...

 

The settings for this data source is completely defined here, including the username and password for the source.

[Authentication set to "Specify user name and password (applies to all users)" with the username and password entered.

 

Despite this setting, every Import Records Script step requires manual entry of these credentials. Entering them is not a problem most of the time, but I do have several places where the ODBC Data Source Username and Password are different. Instead of just changing the setting under Manage (which would be trivial on install), I have to manually modify each Import Records script step in several scripts to update the credentials.

 

Is there any way to avoid this? Am I missing something trivial that would ease my pain? is there a way to use a global variable in place of actual credentials?

Outcomes