Preface
Using the Designer
Working with Sources
Working with Flat Files
Working with Targets
Mappings
Mapplets
Mapping Parameters and Variables
Working with User-Defined Functions
Using the Debugger
Comparing Objects
Managing Business Components
- Managing Business Components Overview
  - Business Component Locking
  - Creating Links to Business Component Documentation
- Managing Business Components and Directories
Creating Cubes and Dimensions
Using the Mapping Wizards
Appendix A: Datatype Reference

Designer Guide

Back Next

Configuring a Third-Party ODBC Data Source

CDI-PC

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

CDI-PC Client

machine.

Open powrmart.ini in the following directory:

<Informatica installation directory>\CDIPC_Client\clients\PowerCenterClient

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

extodbc.dll

Save and close powrmart.ini.

Restart the

CDI-PC Client

and import the target definition.