Bookshelf Home | Contents | Index | Search | PDF |
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
- 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.
- When the ODBC Data Source Administrator dialog appears, under the System DSN tab, select the driver and click Add.
- When the Create New Data Source dialog appears, select SQL Server as the driver for the data source and click Finish.
- 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.
- 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).
- When the dialog refreshes, select the appropriate database on the external system.
- Accept the defaults and click Next.
- When the dialog refreshes again, click Finish.
- 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.
- If the test is successful, a message appears. Click OK.
- Return to the main ODBC Data Source Administrator window, your new data source is included in the list.
Bookshelf Home | Contents | Index | Search | PDF |
Siebel Connector for PeopleSoft Published: 18 April 2003 |