Configuring a Db2 Warehouse Data Source on Windows
Configuring a Db2 Warehouse Data Source on Windows
Install and configure the ODBC driver for the following components:
PowerCenter Integration Service
: Install and configure the 64-bit IBM Data Server driver package on the machine where the PowerCenter Integration Service runs.
PowerCenter Client
: Install and configure the 32-bit IBM Data Server driver package on each PowerCenter client machine that accesses the database. Use the Microsoft ODBC Data Source Administrator to configure ODBC connectivity. Use the Workflow manager to create a database connection object for the Db2 Warehouse database.