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 (E-Business Suite/PeopleSoft/Fusion/JDE/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
PSFT_HCM_DATA_SERVER—For PeopleSoft Human Capital Management (HCM)
FUSION_DATA_SERVER—For Fusion General Ledger
JDE_DATA_SERVER—JD Edwards Enterprise (JDE) General Ledger
SAP_SERVER—SAP FICO

To update server connections information:

Access the Oracle Data Integrator Console.
Select the Browse tab.
Expand Topology.
Select the operating data server to update, and then click Edit.
For example, select EBS_DATA_SERVER or PSFT_FMS_DATA_SERVER.
In Edit Data Servers, under JDBC Details, enter the JDBC driver in JDBC Driver.
For example, enter oracle.jdbc.OracleDriver
In JDBC URL, enter the JDBC URL address.
For example, enter jdbc:oracle:thin:@<host>:<port>:<sid>
In User, enter the user name.
In JDBC Password, enter the password.
Click Save.