Set up the Data Server Based on the Enterprise Resource Planning (ERP) Source System

You must set up the appropriate data servers based on the Enterprise Resource Planning (ERP) source system used to source metadata and/or data.

When importing from Enterprise Resource Planning (ERP) sources (Oracle E-Business Suite, PeopleSoft, SAP), set up the applicable data servers listed below:

• EBS_DATA_SERVER—For E-Business Suite General Ledger

• PSFT_FMS_DATA_SERVER—For PeopleSoft General Ledger and Commitment Control

• JDE_DATA_SERVER—JD Edwards Enterprise (JDE) General Ledger

• SAP_SERVER—SAP FICO

To update server connections information:

1. Access the Oracle Data Integrator Console.
2. Select the Browse tab.
3. Expand Topology.
4. Select the operating data server to update, and then click Edit.

   For example, select EBS_DATA_SERVER or PSFT_FMS_DATA_SERVER.

5. In Edit Data Servers, under JDBC Details, enter the JDBC driver in JDBC Driver.

   For example, enter oracle.jdbc.OracleDriver

6. In JDBC URL, enter the JDBC URL address.

   For example, enter: jdbc:oracle:thin:@<host>:<port>:<sid>

7. In User, enter the user name.
8. In JDBC Password, enter the password.
9. Click Save.