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.
To open the connection manager, click the Actions icon on the Process node in the Databases tree, then click ODBC
settings.
![ODBC settings option slected from the Processes group](images/paw_odbc_settings.jpg)
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.
![Connection manager](images/paw_odbc_connection_manager_selections.jpg)
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.