Siebel Connector for PeopleSoft > Installing the Siebel Connector for PeopleSoft > Creating ODBC Data Source for a DB2 Database >

Creating an ODBC Data Source

This section explains how to create the ODBC data source.

To create an ODBC data source

  1. Select Data Sources (ODBC) menu item from the Windows Start button (Start > Settings > Control Panel > Administrative Tools > Data Sources [ODBC]) Windows 2000.
  2. On Windows NT, launch the ODBC Administrator from the Control Panel by selecting ODBC Data Source.
  3. Click Add in the ODBC Data Source Administrator.

    4. Click for full size image

  4. When the Create New Data Source screen appears, select IBM DB2 ODBC DRIVER as the driver for the data source and click Finish.
  5. When the ODBC IBM DB2 Driver - Add screen appears, enter a name for the ODBC data source (in this example, ODBCWiz). This data source name will be used in both tools.cfg and Siebel Web Client configuration file (such as siebel.cfg and uagent.cfg) to connect to the external database.

    6. NOTE:  When you use the ODBC data source wizard, you will supply the name of the server that hosts this DB2 database.

    Click for full size image

  6. Click OK.
  7. When the ODBC Data Source Administration screen appears, click Configure.
  8. When the Connect to DB2 Database screen appears, enter the User ID and Password, then click OK. The CLI/ODBC Settings dialog box appears. For example:

    9. Click for full size image

  9. If you accept the defaults, click OK. However, if you decide to click Advanced, a new screen will allow you to make site-specific changes.

 Siebel Connector for PeopleSoft 
 Published: 18 April 2003