Creating data source names (DSN)

For ODBC connections, you must have a data source name (DSN) on the same computer that contains InfoSphere® Information Server so that you can associate IBM® InfoSphere FastTrack with the data sources.

Before you begin

You must know the type of ODBC connector that you have installed and provide an ID and password to connect to the data source.

Procedure

  1. From the Windows Start menu, click Control Panel > Administrative Tools > Data Sources (ODBC).
  2. Click the System DSN tab and click Add.
  3. Select the type of Db2® ODBC driver that is installed, for example, IBMDb2 ODBC DRIVER. Click Finish.
  4. In the Data source name field, type a data source name.
  5. Select the same data source name, that you just typed, from the list to register for ODBC. Click OK.
  6. Select the row containing the data source name that you just created. Click Configure.
  7. Type the database user name and password for your computer.
  8. Click Connect. The following message is displayed: Connection tested successfully.
  9. Click OK on all of the current Control Panel windows.
Parent topic: Connecting to data sources
Related information:
Configuring your system resources