Install and Configure Oracle Data Integrator

To install and configure the Oracle Data Integrator components (Oracle Data Integrator Studio and Oracle Data Integrator Agent):

Note:

To view the Oracle® Fusion Middleware Installing and Configuring Oracle Data Integrator Guide, refer to the following:

• For Oracle Data Integrator Release 12.1.3 https://docs.oracle.com/middleware/1213/core/ODING/toc.htm
• For Oracle Data Integrator Release 12.2.1 https://docs.oracle.com/middleware/1221/core/ODING/toc.htm

1. Understand the Oracle Data Integrator Topology—To understand the Oracle Data Integrator agent topologies for the best suitable installation, refer to the Oracle® Fusion Middleware Installing and Configuring Oracle Data Integrator Guide > Section: Planning the Oracle Data Integrator Installation.
2. Install the Oracle Data Integrator—Refer to the Oracle® Fusion Middleware Installing and Configuring Oracle Data Integrator Guide > Section: Installing Oracle Data Integrator.
3. Create the Master and Work Repository Schema—Refer to the Oracle® Fusion Middleware Installing and Configuring Oracle Data Integrator Guide > Section Creating the Master and Work Repository Schema.
4. Create Repository Login—Create a login name for the Master or Work Repository.
   1. On the Oracle Data Integrator Login screen, click the + icon.

      The Repository Connection Information screen appears.

   2. On the Repository Connection Information screen:
      1. In the Login Name field, enter a login name for the repository.
      2. In the User field, enter the name of the SUPERVISOR user.
      3. In the Password field, enter the password for the SUPERVISOR user.

         Enter the same password as provided for the SUPERVISOR while installing the ODI.

      4. In the Database Connection section, enter the Master Repository User Name and Password.

         Enter the same User Name and Password as provided while installing the Oracle Data Integrator.

      5. Enter the database details in the Driver List (Oracle JDBC Driver), Driver Name (oracle.jdbc.OracleDriver) and URL (jdbc:oracle:thin:@<host>:<port>:<sid>) fields.

         You may also click the Search icon next to the Driver List and URL fields to search for the required Driver List and URL.

      6. In Work Repository section:
         • Select Master Repository Only option, if the login is being created for the Master Repository.
         • Select the Work Repository option, and enter the name of the Work Repository in the adjacent text box (for example, WORKREP1).

           You may also click the Search icon next to the Work Repository name text box.

      7. Click OK.

         The login name is created.

5. 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-1 Import Link

      
   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. Click Next.

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

   10. 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.

   11. Click Save.

       The Save Report dialog box appears.

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

       The Save dialog box appears.

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

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

   15. Click OK.

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

   16. 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>.

6. 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, enter 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.

7. 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).
   • To configure the domain for the Standalone Agent, refer to the Configure Standalone Installation Topology for Standalone Agent.
   • To configure the domain for the Java EE Agent, refer to the Configure Standard Installation Topology for Java EE Agent.