Learning Informatica PowerCenter 10.x - Second Edition

Adding new Open Database Connectivity (ODBC) data source

To add a new Database data source connection to import tables, follow the following procedure:

1. In the Designer, go to Tools | Source Analyzer to open the Source Analyzer as indicated in the previous screenshot.
2. Go to Sources | Import from Database as indicated.
3. To add a new Database connection, click on the tab as shown in the following screenshot:

4. A popup to add a new connection will appear on the screen.
5. We need to add a new User DSN as shown in the following screenshot:

6. The next ...