Siebel Connector for PeopleSoft > Installing the Siebel Connector for PeopleSoft > Creating the ODBC Data Source for SQL Server Database >

Creating an ODBC Data Source

Next, you must create an ODBC data source.

To create the ODBC data source

  1. Select Data Sources (ODBC) menu item from the Windows Start button (Start > Settings > Control Panel > Administrative Tools > Data Sources (ODBC)) on Windows 2000 operating system. On Windows NT, launch the ODBC Administrator from the Control Panel by selecting ODBC Data Source.
  2. When the ODBC Data Source Administrator dialog appears, under the System DSN tab, select the driver and click Add.

Click for full size image
  1. When the Create New Data Source dialog appears, select SQL Server as the driver for the data source and click Finish.

    2. Click for full size image

  2. When the Create a New Data Source to SQL Server dialog appears, supply the data source Name, Description, and the Server that hosts the MS SQL Server database. Then, click Next.

    3. Click for full size image

  3. When the dialog refreshes, fill in the Login ID and Password to connect to the external database. These values will be used later on in the tools.cfg and Siebel Web Client configuration (siebel.cfg and uagent.cfg).
  4. When the dialog refreshes, select the appropriate database on the external system.

    5. Click for full size image

  5. Accept the defaults and click Next.
  6. When the dialog refreshes again, click Finish.

    7. Click for full size image

  7. When the ODBC Microsoft SQL Sever Setup dialog appears, verify the parameters and click Test Data Source to test the connectivity to the data source.

    8. Click for full size image

  8. If the test is successful, a message appears. Click OK.

    9. Click for full size image

  9. Return to the main ODBC Data Source Administrator window, your new data source is included in the list.

    10. Click for full size image


 Siebel Connector for PeopleSoft 
 Published: 18 April 2003