ODI (Oracle Data Integrator) -Oracle BAM Integration

                                          ODI AND ORACLEBAM INTEGRATION

ODI-BAM INTEGRATION STEPS:


Supported Version: Oracle BAM 11G and Oracle Data Intergrator 10.3.5

Objectives:
This document provides step-by-step instructions to manipulate data in Oracle BAM
using Oracle Data Integrator. This tutorial showcases the use of customized Oracle BAM
knowledge modules to extract data and insert it back into the application.

Prerequisite:
Basic knowledge of Oracle BAM and Oracle Data Integrator
Installed Oracle BAM software
Oracle Data Integrator 10.1.3.5 installed with Master and Work repositories
Configured Oracle BAM- Oracle Data Integrator integration

Set Up the Environment:

ODI:

1. Open Oracle BAM Architect and select the External Data Sources page.
2. Click Create, and configure the two external data sources (ODI_Master and ODI_
Work) with the values shown in below
ODI_Master external data source values
Property Value
External Data Source Name :ODI_Master
Driver                                    :oracle.jdbc.driver.OracleDriver
Login                                     :Oracle Data Integrator Master repository account user name
Password                               :Oracle Data Integrator Master repository account password
Connection String                 :jdbc:oracle:thin:ip_address:port_number:db_service_name
ODI_Work external data source values
Property Value
External Data Source Name  :ODI_Work
Driver                                    :oracle.jdbc.driver.OracleDriver
Login                                     :Oracle Data Integrator Work repository account user name
Password                               :Oracle Data Integrator Work repository account password
Connection String                 :jdbc:oracle:thin:ip_address:port_number:db_service_name

Set Oracle Data Integrator Configuration Parameters
Modify the ODI_ADDITIONAL_JAVA_OPTIONS and ODI_ADDITIONAL_CLASSPATH
values in the odiparams.sh(bat) file located in ODI_HOME/bin as shown below

ODI_ADDITIONAL_JAVA_OPTIONS Modification
ODI_ADDITIONAL_JAVA_OPTIONS="-Djava.util.logging.config.file=../lib/bam_
odi.logging.properties"
ODI_ADDITIONAL_CLASSPATH Modification
ODI_ADDITIONAL_CLASSPATH=../lib/weblogic/wlfullclient.jar

1. Copy the following files from weblogic server installation path
ORACLE_HOME/bam/modules/oracle.bam_11.1.1 to
ODI_HOME/lib:
■ oracle-bam-common.jar
■ oracle-bam-etl.jar
■ oracle-bam-adc-ejb.jar

2. Copy the following files from weblogic server installation path
ORACLE_HOME/bam/modules/oracle.bam.thirdparty_11.1.1 to
ODI_HOME/lib:
■ commons-codec-1.3.jar
■ xstream-1.1.3.jar

3. Copy the following file from weblogic server installation path
ORACLE_HOME/modules/oracle.odl_11.1.1 to
ODI_HOME/lib:
■ ojdl.jar

4. Copy the following file from weblogic server installation path
ORACLE_HOME/modules/oracle.jps_11.1.1 to
ODI_HOME/lib:
■ jps-api.jar

5. Copy the following file from weblogic server installation path
ORACLE_HOME/modules/oracle.dms_11.1.1 to
ODI_HOME/lib:
■ dms.jar

6. Copy the following file from weblogic server installation path
ORACLE_HOME/modules to
ODI_HOME/lib:
■ org.jaxen_1.1.1.jar

7. Copy the following file from weblogic server installation path
ORACLE_HOME/bam/config to
ODI_HOME/lib:
■ bam.odi.logging.properties

8. Copy the following file from weblogic server installation path
ORACLE_HOME/bam/ODI/config to
ODI_HOME/lib/config:
■ BAMCommonConfig.xml

9. Copy all of the XML files from weblogic server installation path
ORACLE_HOME/bam/odi/knowledge_modules to
ODI_HOME/impexp.
Note: Some of the .jar files will not be in the same path or some files will not be found as they are mentioned above in the weblogic server. Please search for those files in the server and then add it to ODI.
Generate the Oracle WebLogic Server Client JAR
1. Generate a wlfullclient.jar file using the Oracle WebLogic Server
JarBuilder tool. See "Using the WebLogic JARBuilder tool" in Oracle Fusion
Middleware Programming Stand-alone Clients for Oracle WebLogic Server for
instructions.
Note: If you couldnt generate it, just download it from the www.
2. Create a subdirectory called ODI_HOME/oracledi/lib/weblogic.
3. Copy wlfullclient.jar into ODI_HOME/oracledi/lib/weblogic.
4.
Edit the BAMCommonConfig.xml File
1. Edit the ODI_HOME/oracledi/lib/config/BAMCommonConfig.xml file, and
update the entries for ADCServerName and ADCServerPort to the hostname
and port number values where Oracle BAM Server is running.
2. Shut down and restart the Oracle Data Integrator Topology Manager and Designer
applications to load the changes you made to the BAMCommonConfig.xml file.

STEPS FOR THE INTEGRATION:

Steps in Oracle BAM :

1. Login to OracleBAM console
                   http://ipaddress:port/OracleBAM
  

    

2.After login you can see the following page

3.Click Architect to create DataObjects

4. Now create a new data object.

5. Add the columns you needed for the data object (Eg: data object named EMPLOYEE_DETAILS_SAMPLE)

6. Close the BAM Architect and open BAM ActiveStudio for creating reports

7. Create new report

8. Choose the view and the data object for the view

9. Save the report after providing all the details for the report

Settings in Oracle Data Integrator:

 TOPOLOGY MANAGER:

1. Create the  physical schema,logical schema and contexts for the source
2. Create the physical schema for the technology OracleBAM

3. Insert a new data server with the following details
In Definition tab
a. Name : (Give any name)
b. Connection:
     User: <User name used in OracleBAM login>
     Password:<Password used in OracleBAM login>

 In JDBC tab
                   a.JDBC Driver: <any name>
                   b.JDBC URL: instance1:<ipaddress of the BAM instance>:<port number of the BAM instance>

                      c.Insert new Physical schema for the data server created with local object mask as “%OBJECT”
                   
Definition tab:

Context tab:

4. Create logical schema

DESIGNER:

1. Create new model for source and reverse it

2.  Create model for target (OracleBAM)

             a. In Definition tab, choose technology as OracleBAM and Logical schema that you have created in topology manager.

  b. In Reverse tab, click CUSTOMIZED option
                  Context:Global
                  Select your KM:RKM Oracle BAM.<project name>

c. Click Reverse

                   

d. Check in the operator whether the execution is working

                    e. If the reverse is successful , then check  for the datastores (data objects that you have created in Oracle BAM Architect)

                    f. Immediately after this create a primary key for the datastore (reversed through OracleBAM technology as it wont come with a primary key)

                             

3. Create an interface (mapping)

           a. In Definition tab, provide any name in Name section and check the STAGING AREA DIFFERENT FROM TARGET and select the staging area (as OracleBAM server we created is not a database and it is a running instance)
              

          b. Drag and drop source and target datastores in the Diagram tab

c. KM Selection
ci. No LKM's needed if the source database is the staging table else need to select

cii. IKM : IKM BAM UPSERT

                      d.Click Apply and OK
                      e. Now execute the interface

BAM ACTIVE VIEWER:

1. Select the report in active viewer and for each execution of the ODI interface for incoming data, there will be a change in the reports

References:
http://download.oracle.com/docs/cd/E14571_01/integration.1111/e10224/bam_odi.htm
http://www.oracle.com/technetwork/middleware/bam/technote-bam-odi-installation-132338.pdf