Bookshelf Home | Contents | Index | Search | PDF |
Siebel eFinance Guide > Integration > AMS Connector >
Configuring an Oracle Connection and ODBC Data Source
In order to retrieve AMS reference data and insert into Siebel eFinance, you must make sure it includes the proper AMS specific values. To accomplish this objective, you must establish a connection to an Oracle database.
The first step in creating this connection is installing the Oracle Client software on the Siebel Server.
Once you have installed the Oracle Client software on the Siebel Server, you must configure connectivity to the target Oracle application or the appropriate Oracle Applications instance. Table 11 describes the Service Naming parameters you need to specify. For more information on the specific values needed for your environment, contact your AMS system administrator.
For more information, see the Oracle Client software installation guide.
Creating an Oracle Data Source
Next, you create an ODBC data source on the Siebel Server that references the Oracle service you just created.
- In the Microsoft Windows ODBC Data Source Administrator window, select the System DSN tab and then click Add.
- Select the Oracle ODBC driver to be added and click Finish.
- When the ODBC Driver Setup window appears, fill in the values described in the following table.
Enter same value you entered for the Net Service Name parameter in Table 11. For example, RefServer.AMS.COM.
Bookshelf Home | Contents | Index | Search | PDF |
Siebel eFinance Guide Published: 20 October 2003 |