Table of Contents

Search

  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

ODBC Connectivity for Microsoft SQL Server Resources

ODBC Connectivity for Microsoft SQL Server Resources

Effective in version 10.0, when you load a Microsoft SQL Server resource, the PowerCenter Integration Service uses ODBC to connect to the database. The PowerCenter Integration Service retrieves the server name and the database name from the connect string and creates a data source using the installed ODBC driver.
Therefore, you no longer need to perform the following tasks when you configure a Microsoft SQL Server resource:
  • On Windows, you do not need to install the Microsoft SQL Server Native Client.
  • On UNIX, you do not need to create a data source for the Microsoft SQL Server database in the odbc.ini file.
    If you previously created a data source in the odbc.ini file, you can still use it by entering the data source name as the connect string.
  • You do not need to set the
    ODBC Connection Mode
    property for the Metadata Manager Service in the Administrator tool. This property is removed because the connection mode for Microsoft SQL Server is always ODBC.
Previously, the PowerCenter Integration Service used native connectivity on Windows and ODBC connectivity on UNIX.
For more information about configuring Microsoft SQL Server resources, see the "Database Management Resources" chapter in the
Informatica 10.0 Metadata Manager Administrator Guide
.


Updated September 25, 2020