Installation and Upgrade Guide

10.5.8
- 10.5.6
- 10.5.5
- 10.5.4
- 10.5.3
- 10.5.2
- 10.5.1
- 10.5
- 10.4.1
- 10.4.0 HotFix 1
- 10.4.0

Back Next

Step 4. Install the PowerExchange ODBC Drivers (Optional)

If you plan to use ODBC to access PowerExchange from PowerCenter or another Informatica product that integrates with PowerExchange, install the PowerExchange Open Database Connectivity (ODBC) drivers.

To run the command prompt with administrator privileges, perform these actions:

Select

Start

All Programs

Accessories

Right-click

Command Prompt

and select

Run as administrator

Navigate to one of the following directories:

To install 64-bit ODBC drivers, navigate to the base PowerExchange installation directory.

To install 32-bit ODBC drivers, navigate to the bin32 subdirectory of the PowerExchange installation directory.

For more information about the 32-bit and 64-bit ODBC drivers, see ODBC Considerations.

At a command prompt, enter the following command:

dtlodbci add

This command installs both ODBC drivers and issues the following messages:

PWX‑00607 DTLODBCI VRM x.x.x Build Vxxx started.
PWX‑02322 ODBC driver “Informatica PowerExchange” added.
PWX‑02322 ODBC driver “Informatica PowerExchange Unicode” added.

Use the

Windows ODBC Data Source Administrator

to define PowerExchange ODBC data sources.For more information, see the PowerExchange Reference Manual
.

If you run the dtlodbci program without administrator privileges, the program might appear to add or remove entries successfully without actually adding or removing them.

As an alternative to running the command prompt with administrator privileges, you can configure Windows to always run the dtlodbci program with administrator privileges. Follow these steps:

Navigate to the directory that contains the appropriate dtlodbci.exe file.

Right-click

dtlodbci.exe

and select

Properties

On the Compatibility tab, select

Run this program as an administrator

Installing PowerExchange

Download Guide

Watch

Comments

Communities