Bookshelf Home | Contents | Index | Search | PDF |
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
- Select Data Sources (ODBC) menu item from the Windows Start button (Start > Settings > Control Panel > Administrative Tools > Data Sources [ODBC]) Windows 2000.
- On Windows NT, launch the ODBC Administrator from the Control Panel by selecting ODBC Data Source.
- Click Add in the ODBC Data Source Administrator.
- When the Create New Data Source screen appears, select IBM DB2 ODBC DRIVER as the driver for the data source and click Finish.
- 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.
NOTE: When you use the ODBC data source wizard, you will supply the name of the server that hosts this DB2 database.
- Click OK.
- When the ODBC Data Source Administration screen appears, click Configure.
- 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:
- 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.
Bookshelf Home | Contents | Index | Search | PDF |
Siebel Connector for PeopleSoft Published: 18 April 2003 |