Set up the Data Server Based on the ERP Source System

You need to set up the appropriate data servers based on the ERP source system used to source metadata and/or data.

When importing from ERP sources (EBS/PeopleSoft/Fusion/JDE/SAP), set up the applicable data servers listed below:

  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 click Edit.

    For example, select EBS_DATA_SERVER or PSFT_FMS_DATA_SERVER.

  5. In Edit Data Servers, and then 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.