Manage ODBC connections for multiple processes on the modeling workbench

Each process with an ODBC data source includes the declaration of the ODBC connection, username and password as part of the data source connection configuration. When your database contains multiple processes that use the same data source connection configuration, it can be laborious to update each process individually when the connection configuration changes.Use the new connection manager to modify the ODBC connections for multiple processes simultaneously.

Note: The connection manager is available only on the modeling workbench. You can't use the connection manager in a modeling book.

To open the connection manager, click the Actions icon Action button on the Process node in the Databases tree, then click ODBC settings.

ODBC settings option slected from the Processes group

In the connection manager, you can select which processes you want to modify, then click Edit to modify the database connection type, user, or password.

After you save the connection changes, the modified connection configuration is applied and saved to each of the processes you selected.

For more details, see Modify connection configuration for multiple processes that use ODBC data sources.