Invoking jar in Oracle Data Integrator

Invoking jar in Oracle Data Integrator

 

Scenario

We are having one file called employee.txt, which is having as a header for date and company name and in details it has Age, First Name, Last Name & Date Hired. we have to separate header in HEADER.txt file and details in DETAILS.txt file. After getting data on both file we need to upload in HEADER & EMPLOYEE_DETAILS table. To separation of the data we need to use jar file through ODI. And for uploading data in DBMS we are using ODI

Download Required Files click here

Software and Hardware Requirements (Optional)

The following is a list of software requirements:

·         The system should include the following installed products:

o    Oracle Database 11g

o    Oracle Data Integrator 11gR1

·         If not done before, start the services and components for Oracle Database 11g

Prerequisites

Before you start the tasks, make sure that your system environment meets the following requirements:

1 .	Have installed Oracle Database 11g. If not done before, start the services and components for Oracle Database 11g
2 .	Have installed Oracle Data Integrator 11gR1
3 .	Before attempting this OBE, you should have successfully completed the following OBE: ODI11g: Creating and Connecting to ODI Master and Work Repositories.

Creating a New Project with Oracle Data Integrator

To create a new project within Oracle Data Integrator, perform the following steps:

1.

Start ODI Designer: Start > Programs > Oracle > Oracle Data Integrator > ODI Studio . Select WORKREP1 from the Login Name drop-down list if not already selected. Enter SUPERVISOR in the User field and SUNOPSIS in the Password field. Click OK to login. 2. In the designer tab, click the Projects tab, click New Project icon , and then click New Project.    3. On the screen that appears, set the Name of the project to ODIexp_SPLITFILE_USING_JAR in the Name field. The Code field is filled automatically. Click Save icon . The newly created ODIexp_SPLITFILE_USING_JAR project now appears in the Projects tree view. You have now successfully added a new ODI project. Write one program in any IDE in java which splits the files & then generate a .jar file of that program.   Write one program in any IDE in java which splits the files & then generate a .jar file of that program. 4.Create one procedure called SPLIT_FILES in jython which call's this .jar file  Note :-Before creating procedure put your jar in Bellow location oracle\product\11.1.1\Oracle_ODI_2\oracledi\agent\drivers\ Save a procedure   Execute a procedure Check the updated files