English
PowerCenter All Products

Table of Contents

Search

  1. Preface
  2. Using the Designer
  3. Working with Sources
  4. Working with Flat Files
  5. Working with Targets
  6. Mappings
  7. Mapplets
  8. Mapping Parameters and Variables
  9. Working with User-Defined Functions
  10. Using the Debugger
  11. Viewing Data Lineage
  12. Comparing Objects
  13. Managing Business Components
  14. Creating Cubes and Dimensions
  15. Using the Mapping Wizards
  16. Datatype Reference
  17. Configure the Web Browser

Designer Guide

Designer Guide

Back Next

Configuring a Third-Party ODBC Data Source

Configuring a Third-Party ODBC Data Source

PowerCenter uses the powrmart.ini file to recognize the third-party ODBC driver, import the ODBC database object with third-party ODBC drivers, and to preview data in Designer. To import a source definition with an ODBC driver that is not included in the powrmart.ini file, configure the file on the PowerCenter Client machine.
  1. Open powrmart.ini in the following directory:
    <Informatica installation directory>\clients\PowerCenterClient\client\bin
  2. Add an entry to the file under the ODBCDLL section that includes the name of the ODBC data source.
    Ensure that the entry directly points to
    pmodbc.dll
     or
    extodbc.dll
    .
  3. Save and close powrmart.ini.
  4. Restart the PowerCenter Client and import the source definition.

Updated July 02, 2020

Download Guide
Send Feedback
Explore Informatica Network
Communities
Knowledge Base
Success Portal