You can replace a relational database connection with another relational database connection. For example, you might have several sessions that you want to write to another target database. Instead of editing the properties for each session, you can replace the relational database connection for all sessions in the repository that use the connection.
When you replace database connections, the Workflow Manager replaces the relational database connections in the following locations for all sessions using the connection:
Connection Information property in Lookup and Stored Procedure transformations
$Source Connection Value session property
$Target Connection Value session property
When the repository contains both relational and application connections with the same name, the Workflow Manager replaces the relational connections only if you specified the connection type as relational in all locations.
The Integration Service uses the updated connection information the next time the session runs.
You must close all folders before replacing a relational database connection.