Using Pre-Packaged Installations

For pre-packaged integrations, the integration is provided by Oracle, and Oracle's partner, Bristlecone. Oracle delivers the Oracle Data Integrator (ODI) Project and an Adapter Definition XML file. For the SAP integration, Bristlecone delivers the ODI Project and Adapter XML. Please refer to the readme for details on downloading from Bristlecone.

  To use the pre-packaged integration:

  1. Copy the ODI files to a location accessible by ODI Studio.

  2. Copy the Adapter Definition XML to a location under the direction setup as Application Root Directory in System Settings.

  3. Use the ODI Studio to import the Project & Model definitions into the Work Repository setup for ERP Integrator.

  4. Use the Source Adapter screen to import the Adapter XML file.

    To import a file:

    1. In the Tasks pane, under Setup, select Source Adapter.

      The Source Adapter screen is displayed.

    2. From the Source Adapter Summary task bar, select Import.

      The Select file to import screen is displayed.

    3. Navigate to the file to import and click OK.

      The file name will depends on the adapter they want to use. For example, you might select:

      • Open_Interface_Adapter.xml

      • SAP_GLNew_Adapter.xml

      • SAP_GLClassic_Adapter.xml

      • SAP_PC_Adapter.xml

      • SAP_CC_Adapter.xml

    4. Optional: To browse for a file, select Upload.

      The Select a file to upload screen is displayed.

    5. If necessary, click Browse to navigate to the file to import and then click OK.

  5. Create an import format of new type Source Adapter that defines the mapping between the source columns (identified in the source adapter) and the target application dimensions.

    After defining the import format, Regenerate the ODI Scenario to generate an ODI Scenario based on the new mapping.

  6. Define the Locations and Data Rule.

    When you execute the data rule, the new ODI Scenario associated with the import format is used to extract the data from the source and stage it in the ERP Integrator staging table (TDATASEG).