Communities
A collaborative platform to connect and grow with like-minded Informaticans across the globe
Product Communities
Connect and collaborate with Informatica experts and champions
Discussions
Have a question? Start a Discussion and get immediate answers you are looking for
User Groups
Customer-organized groups that meet online and in-person. Join today to network, share ideas, and get tips on how to get the most out of Informatica
Get Started
Community Guidelines
Knowledge Center
Troubleshooting documents, product guides, how to videos, best practices, and more
Knowledge Base
One-stop self-service portal for solutions, FAQs, Whitepapers, How Tos, Videos, and more
Support TV
Video channel for step-by-step instructions to use our products, best practices, troubleshooting tips, and much more
Documentation
Information library of the latest product documents
Velocity (Best Practices)
Best practices and use cases from the Implementation team
Learn
Rich resources to help you leverage full capabilities of our products
Trainings
Role-based training programs for the best ROI
Certifications
Get certified on Informatica products. Free, Foundation, or Professional
Product Learning Paths
Free and unlimited modules based on your expertise level and journey
Resources
Library of content to help you leverage the best of Informatica products
Tech Tuesdays Webinars
Most popular webinars on product architecture, best practices, and more
Product Availability Matrix
Product Availability Matrix statements of Informatica products
SupportFlash
Monthly support newsletter
Support Documents
Informatica Support Guide and Statements, Quick Start Guides, and Cloud Product Description Schedule
Product Lifecycle
End of Life statements of Informatica products
Ideas
Events
Change Request Tracking
Marketplace
English
  • PowerExchange Adapters for PowerCenter 10.4.0
  • All Products

Table of Contents

Search

  1. Preface
  2. Introduction to PowerExchange for Db2 Warehouse
  3. PowerExchange for Db2 Warehouse Configuration
  4. Db2 Warehouse Sources and Targets
  5. Db2 Warehouse Sessions and Workflows
  6. Data Type Reference

PowerExchange for Db2 Warehouse User Guide for PowerCenter

PowerExchange for Db2 Warehouse User Guide for PowerCenter

Back Next

Configuring ODBC Connectivity

Configuring ODBC Connectivity

You can configure ODBC connectivity to a Db2 Warehouse database.
To establish an ODBC connection to connect to Db2 Warehouse on Windows, install the 32-bit IBM Data Server Driver Package on the machine where you install the PowerCenter Client.
After you install the driver, configure the Data Source Name (DSN) in the ODBC Data Source Administrator. Create an 32-bit ODBC data source for each Db2 Warehouse database that you want to access.
The following steps provide a guideline for configuring ODBC connectivity. For specific instructions, see IBM Data Server Driver documentation.
  1. Click
    Start
    Control Panel
    .
  2. Click
    Administrative Tools
    .
  3. Click
    Data Sources (ODBC)
    .
    The
    ODBC Data Source Administrator
     dialog box appears.
  4. Click the
    System DSN
     tab.
    The
    System DSN
     tab appears. The following image shows the System DSN tab on the ODBC Data Source Administrator (32-bit) dialog box:
    The image shows the System DSN tab on the ODBC Data Source Administrator (64-bit) dialog box.
  5. Click
    Add
    .
    The
    Create New Data Source
     dialog box appears. The following image shows the Create New Data Source dialog box where you can select the IBM Data Server Driver:
    The following image shows the IBM Data Server Driver IBM DB2 ODBC DRIVER available for your operating system
  6. Select
    IBM DB2 ODBC DRIVER - IBMDBCL1
     to set up the data source.
    IBMDBCL1
     is the default IBM data server driver copy name. You can configure the IBM data server driver copy name when you install the IBM Data Server Driver Package.
  7. Click
    Finish
    .
    The
    ODBC IBM DB2 Driver - Add
     dialog box appears.
    The following image shows the connection properties in the
    ODBC IBM DB2 Driver - Add
     dialog box: The following image shows the ODBC IBM Data Server Driver - Add dialog box where you can create a data source.
  8. Enter a name for the new ODBC data source.
  9. Select a database alias for Db2 Warehouse or click
    Add
     to add a new database alias.
    The
    CLI/ODBC Settings
     dialog box appears.
    The following image shows the connection properties in the
    CLI/ODBC Settings
     dialog box: The following image shows the CLI/ODBC Settings dialog box.
  10. On the
    Data Source
     tab, specify the
    User ID
     and
    Password
     of the Db2 Warehouse database that you want to connect to.
  11. On the
    Advanced Settings
     tab, click
    Add
    .
    The
    Add CLI Parameter
     dialog box appears.
  12. Add the following CLI parameters and the values for each parameter:
    CLI Parameter Name
    Value
    Database
    Database on the Db2 Warehouse that you want to connect to.
    Hostname
    Host name or IP address of the Db2 Warehouse system that you want to connect to.
    Port
    Port number of the Db2 Warehouse system that you want to connect to.
  13. Click
    OK
    .
  14. Verify that you can connect to the Db2 Warehouse database.
    You can use the Microsoft ODBC Data Source Administrator to test the connection to the database. To test the connection, select the Db2 Warehouse data source and click Configure. On the Testing tab, click Test Connection and enter the connection information for the Db2 Warehouse schema.
0 COMMENTS
We’d like to hear from you!