Table of Contents


  1. Version 10.0
  2. Version 9.6.1
  3. Version 9.6.0

Connection Switching

Effective in version 10.0, in the Developer tool, you can switch the connection of a relational data object or customized data object to use a different relational database connection. After you switch the connection, the Developer tool updates the connection details for the data object in all Read, Write, and Lookup transformations that are based on the data object. You might want to switch the connection when you migrate from one database to another and want to simultaneously update the existing mappings to use the new connection.
You can switch a connection to one of the following connection types:
  • IBM DB2
  • Microsoft SQL Server
  • ODBC
  • Oracle
The following image shows the dialog box that you use to switch a connection:
 The Switch Connection dialog box shows the data object for which you want to switch the connection and the new connection that you want to use.
For more information, see the "Connections" chapter in the
Informatica 10.0 Developer Tool Guide