Table of Contents


  1. Preface
  2. Part 1: Version 10.2
  3. Part 2: Version 10.1.1
  4. Part 3: Version 10.1
  5. Part 4: Version 10.0
  6. Part 5: Version 9.6.1
  7. Part 6: Version 9.6.0

PowerCenter Connectivity

PowerCenter Connectivity

This section describes new connectivity features in version 10.0.

Native Connectivity to Microsoft SQL Server

Effective in version 10.0, you can use the DataDirect ODBC driver for Microsoft SQL Server 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 configuring native connectivity, see the "Connecting to Databases from UNIX" appendix in the
Informatica 10.0 Installation and Configuration Guide