E Oracle Data Integrator Companion CD

This appendix describes the components that are provided on the Oracle Data Integrator Companion disk and instructions for manual installation.

E.1 Oracle Data Integrator Companion Disk Components

Table E-1 provides the location and description of the components that are provided on the Oracle Data Integrator companion disk. These components must be manually installed.

Table E-1 Directory Structure of the Oracle Data Integrator Companion Installation Disk

Directory Description

/agent_standalone

This folder contains the manual installation files for the ODI Standalone Agent in oracledi-agent-standalone.zip.

/demo

This folder contains demonstration files and samples in oracledi-demo.zip.

NOTE: Demonstration files and samples are NOT installed with the Oracle Data Integrator GUI installer. To use the demonstration files, you must install them manually.

/misc/cdc-iseries

This folder contains the manual installation files for the ODI CDC for AS/400.

/misc/biee-lineage

This folder that contains the Oracle Business Intelligence Enterprise Edition (OBIEE) and Oracle Data Integrator (ODI) metadata to build report-to-source data lineage wizard.

For more information on this component's installation, see "Oracle Business Intelligence Enterprise Edition Data Lineage" in the Oracle Fusion Middleware Connectivity and Knowledge Modules Guide for Oracle Data Integrator.

/misc/jde_world

This folder contains the following JD Edwards (JDE) World program files:

  • JDEWorldJDBC.jar

    This JDE World JDBC driver file must be in the userlib or driver folder.

  • WorldBase.jar

    This jar file must be in the userlib or driver folder.

  • config.xml

    This configuration file must be in the ODI_HOME/odi/bin folder.

  • jdeworld_example.properties

    This properties file is a template that you can make use of if you are using the JDE_SECURITY_FILE option in the IKM JDE World Control Append.

/sdk

This folder contains the manual installation files for ODI SDK Component in oracledi-sdk.zip.

/studio

This folder contains the manual installation files for ODI Studio in oracledi-studio.zip.

/xml-reference

This folder contains oracledi-xml-reference.zip which provides the technologies, actions and knowledge modules that can be imported into ODI.

E.2 Manual Installation and Configuration Steps

This section provides information on manually installing and configuring the components provided on the Oracle Data Integrator Companion disk.

Before performing the manual installation of the ODI components, create a directory on your disk that will be the ODI_HOME. For example, create a folder named c:\oracle\odi11g\ on Windows operating systems.

Note:

Oracle Data Integrator Components requires a Java Virtual Machine (JVM) to run. Make sure that a supported Java environment is set up on your machine prior to installing Oracle Data Integrator.

For a list of supported platforms, see the Oracle Fusion Middleware certification documents at http://www.oracle.com/technology/software/products/ias/files/fusion_certification.html.

E.2.1 Standalone Agent

To manually install the ODI Standalone Agent, do the following:

  1. Unzip the oracledi-agent-standalone.zip file located in the target ODI_HOME directory.

  2. Manually configure odiparams.bat (for Windows operating systems) or the odiparams.sh (for UNIX operating systems) as described in Table 3-1, "Repository Connection Information".

  3. Set the JAVA_HOME or ODI_JAVA_HOME environment to the path of the JVM directory where the /bin directory resides.

    For example:

    setenv JAVA_HOME/usr/local/java

    NOTE: The JVM that you point to must be a supported version. For a list of certified JVM versions, see http://www.oracle.com/technology/software/products/ias/files/fusion_certification.html.

    Tip:

    If you installed Oracle WebLogic Server, a JRE was installed on your system. You can use this location (the location of the JRE directory) to start the installer. The default location for the JRE is MW_HOME/jdk16x (on UNIX operating systems) or MW_HOME\jdk16x (on Windows operating systems), where MW_HOME is the Middleware Home directory.

    On 64-bit platforms, the JRE location is the JAVA_HOME you used to install Oracle WebLogic Server.

    For more information, refer to Oracle Fusion Middleware Installation Guide for Oracle WebLogic Server.

  4. Configure the Standalone Agent in the topology as described in Section 3.2.5.

  5. Start the Standalone Agent as described in Section 3.2.6.

E.2.2 ODI Studio and XML Reference

To manually install the ODI Studio and XML Reference, do the following:

  1. Unzip oracledi-studio.zip in the ODI_HOME directory.

  2. Unzip oracledi-xml-reference.zip in the ODI_HOME directory.

  3. Start ODI Studio.

    • On UNIX operating systems:

      ODI_HOME/oracledi/client/odi.sh

    • On Windows operating systems:

      ODI_HOME\oracledi\client\odi.exe

  4. When ODI Studio starts for the first time, it prompts you for location of the Java Virtual Machine. Provide the location of the JVM. Once you have provided the JVM location, Oracle Data Integrator Studio starts.

E.2.3 Demonstration Environment

The demonstration (demo) environment should be installed with an existing installation that includes the ODI Studio component.

To manually install the Demonstration environment, do the following:

  1. Unzip oracledi-demo.zip in the ODI_HOME folder.

  2. Set the JAVA_HOME or ODI_JAVA_HOME property to the path of the JVM directory where the /bin directory resides. For a list of certified JVM versions, see http://www.oracle.com/technology/software/products/ias/files/fusion_certification.html.

    For example:

    setenv JAVA_HOME /usr/local/java/bin

    Tip:

    If you installed Oracle WebLogic Server, a JRE was installed on your system. You can use this location (the location of the JRE directory) to start the installer. The default location for the JRE is MW_HOME/jdk16x (on UNIX operating systems) or MW_HOME\jdk16x (on Windows operating systems), where MW_HOME is the Middleware Home directory.

    On 64-bit platforms, the JRE location is the JAVA_HOME you used to install Oracle WebLogic Server.

    For more information, refer to Oracle Fusion Middleware Installation Guide for Oracle WebLogic Server.

  3. To start ODI Demonstration Environment:

    • On UNIX operating systems launch the following script:

      ODI_HOME/oracledi/demo/bin/startdemo.sh

    • On Windows operating systems launch the following script:

      ODI_HOME\oracledi\demo\bin\startdemo.bat

  4. To stop ODI Demonstration Environment:

    • On UNIX operating systems launch the following script:

      ODI_HOME/oracledi/demo/bin/stopdemo.sh

    • On Windows operating systems launch the following script:

      ODI_HOME\oracledi\demo\bin\stopdemo.bat

The demonstration environment is used in the Oracle Data Integrator tutorials available on Oracle Technology Network.

E.3 Installing the Java Standalone Agent on iSeries

The Standalone Agent can be deployed on iSeries systems. This deployment enables you to start run-time agents and manage sessions using the iSeries server machine.

To manually install the ODI Standalone Agent on iSeries, do the following:

  1. Create a temporary TEMP_ODI_HOME directory on a client machine.

  2. Unzip the oracledi-agent-standalone.zip file in this TEMP_ODI_HOME directory. Optionally, add additional drivers and open tools as described in Section 3.2.1.

  3. Manually configure odiparams.sh as described in Table 3-1, "Repository Connection Information".

  4. Configure the agent in the topology as described in Section 3.2.5.

  5. Using QShell (QSH), create a folder for the Standalone Agent in your iSeries system. This folder will be your ODI_HOME.

  6. Transfer the content of the TEMP_ODI_HOME folder to this ODI_HOME folder using FTP.

  7. Use the UNIX operating system scripts located in the ODI_HOME/oracledi/agent/bin directory for starting your agents or managing your sessions. See Table 1-2, "Oracle Data Integrator Scripts and Tools" for a description of these scripts.