Table of Contents

Search

  1. Preface
  2. Workflow Manager
  3. Workflows and Worklets
  4. Sessions
  5. Session Configuration Object
  6. Tasks
  7. Sources
  8. Targets
  9. Connection Objects
  10. Validation
  11. Scheduling and Running Workflows
  12. Sending Email
  13. Workflow Monitor
  14. Workflow Monitor Details
  15. Session and Workflow Logs
  16. Session Properties Reference
  17. Workflow Properties Reference

Relational Database Connection Replacement

Relational Database Connection Replacement

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:
  • Source connection
  • Target 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.