Upgrade the existing Oracle Data Integrator

To upgrade the existing Oracle Data Integrator components (Oracle Data Integrator Studio and Oracle Data Integrator Agent), perform the following steps:

  1. Connect to your work repository.
  2. Import Oracle Argus Mart Schema Objects
    1. Open the ODI, and connect to the repository using the Work Repository credentials that you have just created, as mentioned in the previous section.
    2. From the Designer tab, click the down arrow.

      A drop-down menu appears.

      Figure 4-2 Import Link

      Drop-down menu to import Argus Mart schema objects
    3. Click Import.

      The Import Selection dialog box appears.

    4. Select Smart Import, and click OK.

      The Smart Import dialog box appears.

    5. Click the Search icon next to the File Selection field.

      The Select an import file dialog box appears.

    6. Navigate to the AM.zip file, saved at the following location:

      ...\ArgusMart\ODI\AM.zip

    7. Select the AM.zip file, and click Open.

      The complete path of the zip file appears in the File Selection field. Keep the Response file field as blank.

    8. Click Next.

      The Please wait dialog box appears with a Matching Import Objects message.

      Subsequently, the Smart Import dialog box appears listing the components that will be imported from the zip file using the Import Actions screen.

    9. On the Import Actions screen, under the Object match Details section; expand the Designer node to make the Designer > Projects > ARGUSMARTrelease node visible.

      For example, ARGUSMART8231

      1. Select the Overwrite under Action option next to the ARGUSMARTrelease project.
        • Go to Load Plans And Scenarios > LP_ARGUSMARTrelease, and select Overwrite under Action.
        • Go to Load Plans And Scenarios > SCN_ARGUSMARTrelease, and select Overwrite under Action.
      2. Expand the topology: Physical Architecture > Technologies > Oracle > DS_AM_ARGUSMART, and select Reuse as Action.
      3. Expand the topology: Physical Architecture > Agents > PA_AM, and select Reuse as Action.
    10. Click Next.

      The Summary screen appears with the No issues message if there are no errors in the import process.

    11. Click Finish.

      The Please wait dialog box appears with a Import in progress message.

      Subsequently, the Smart Import Report screen appears listing the objects imported using the zip file.

    12. Click Save.

      The Save Report dialog box appears.

    13. Click the Search icon next to the Name of the target file field.

      The Save dialog box appears.

    14. Navigate to the path where you want to save the report, and in the File Name field, enter the name for the report.
    15. Click Save.

      The name of the report file appears along with the complete path in the Name of the target file field.

    16. Click OK.

      The Information dialog box appears with the path where the report file has been saved.

    17. Click OK.

      This completes the steps to import the AM zip file.

      You may verify this from ODI > Designer tab. The Oracle Argus Mart specific folders now appears in the Designer tab under Projects section, such as ARGUSMART<version number>.

  3. Setup the Physical Agent:
    1. Open the Oracle Data Integrator Studio, and login to the Work Repository Connection created in the Step 4.
    2. Go to the Topology tab, from the left side pane, navigate to the Physical Architecture > Agents.
    3. Double -click PA_AM.
    4. From the Definition Vertical tab, in the Host field, verify the IP address of the ODI Server.

      If you configure a Standalone Agent, then leave the Agent Name as PA_AM, and configure the Standalone Agent in the next step with same name. If you configure a Java EE Agent, then change the Agent Name to OracleDIAgent (as by default), and the Agent Name for Java EE Agent will be created as OracleDIAgent. For more information, refer to Oracle® Fusion Middleware Installing and Configuring Oracle Data Integrator > 5 Configuring the Domain for the Java EE Agent > 5.3 Creating a Java EE Agent in the Master Repository Using ODI Studio.

      Make sure to use the same port number in Oracle Data Integrator Studio as well as Agent configured.

  4. Configure the Domain for the Oracle Data Integrator Agent:

    Note:

    For Oracle Argus Mart, configure either one of the Oracle Data Integrator Agents (Standalone, or Java EE).