Registering E-Business Suite and PeopleSoft Source Systems

The source system page displays all registered source systems in a table in the Summary pane. By default, the following columns are displayed:

  To add a source system:

  1. In the Tasks pane, select Source System.

    The Source System page is displayed.

  2. Click Add.

  3. Enter the source system details:

    1. Enter the source system name.

    2. Enter an optional description.

    3. Select the source system type.

    4. Optional: If using Performance Management Architect applications, enter the Performance Management Architect (EPMA) Data Source Name. (The data source name that you specified in the Oracle's Hyperion Enterprise Performance Management System Configurator when you created a Performance Management Architect interface data source.)

    5. Enter the Drill URL. The URL used to launch E-Business Suite or PeopleSoft. For example, http://machinename.us.oracle.com:6362.

      The Drill URL identifies the URL to use for drilling through. Users can drill through to Oracle General Ledger or PeopleSoft Enterprise Financial Management from an Enterprise Performance Management (EPM) system application that displays data loaded from the source system. When you click a hyperlink, you can navigate to the Oracle General Ledger Balances page or PeopleSoft Enterprise Financial Management Inquiry page.

  4. Enter the ODI details:

    1. Context Code

    2. Repository Code

    3. Agent Host—the machine where you installed Oracle Data Integrator.

    4. Agent Port

    5. User—Oracle Data Integrator user name (used to access the Oracle Data Integrator master repository). For example, SUPERVISOR.

    6. Password—database schema password (used to access the Oracle Data Integrator master repository). For example, SUNOPSIS.

    7. JDBC Driver. For example, for Oracle,oracle.jdbc.OracleDriver and for SQL Server, weblogic.jdbc.sqlserver.SQLServerDriver.

    8. JDBC URL. For example, for Oracle, jdbc:oracle:thin:@<host>:<port>:<SID> and for SQL Server, jdbc:weblogic:sqlserver://<host>:<port>;databaseName=<name>.

    9. Repository User—Oracle Data Integrator master repository user name

    10. Repository Password—Oracle Data Integrator master repository password

    11. Log Level—Oracle Data Integrator supports log levels 0 through 5, where 5 is the most detailed.

    12. Metadata Navigator URL—The URL for Oracle Data Integrator Metadata Navigator tool. You can use Metadata Navigator to view process details and detailed information about Oracle Data Integrator jobs.

  5. Click Save.

    After you add a source system, you can select the source system in the table and the details display in the lower pane.

    After you register a source system, you must initialize the source system. Initializing the source system fetches all metadata needed in ERP Integrator, such as ledgers, chart of accounts, and so on. It is also necessary to initialize the source system when there are new additions, such as chart of accounts, segments / chartfields, ledgers, or responsibilities.

  6. To initialize a source system, click Initialize.

    Note:

    Depending on the size of the source system, it may take several minutes to initialize.