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. POWERCENTERHELP
  17. Datatype Reference
  18. Configure the Web Browser

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 target 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 target definition.


Updated June 25, 2018