Connectivity

Effective in version 10.0, you can use the Microsoft SQL Server 2012 Native Client to configure native connectivity to Microsoft SQL Server databases from UNIX machines.

You can select the connection provider that you want to use to connect to the Microsoft SQL Server database. You can select either the ODBC or OLE DB connection type. You can also enable the Integration Service to use the Data Source Name (DSN) for the connection. Additionally, you can use NTLM authentication to authenticate the user who connects to Microsoft SQL Server.

For more information about connecting to Microsoft SQL Server 2012, see the "Connecting to Databases from UNIX" appendix in the Informatica 10.0 Installation and Configuration Guide.

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:

The following image shows the dialog box that you use to switch a connection:

For more information, see the "Connections" chapter in the Informatica 10.0 Developer Tool Guide.