PowerExchange Interfaces for PowerCenter

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

Back Next

Creating a PowerExchange ODBC Data Source on Linux or UNIX

If the PowerCenter Integration Service runs on a Linux or UNIX machine, create a PowerExchange ODBC data source on that machine. To create the data source, update the appropriate odbc.ini file.

The data source entries in the odbc.ini file have the following format:

[data_source_name]
DRIVER=PowerExchange_full_install_path/libdtlodbc.sl 
DESCRIPTION='descriptive_text'
LOCATION=data_source_node_from_dbmover.cfg 
DBTYPE=access_method_for_file_or_database
…   (other ODBC parameters as appropriate)

The data source name defined in the odbc.ini file is specified in the

Connect String

attribute of the ODBC connection in PowerCenter. This connect string is used to load the PowerExchange ODBC driver and connect to the specified location to extract or load data.

For more information, see the

PowerExchange Reference Manual

Creating ODBC Data Sources

Creating an ODBC Data Source on Windows

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal