The Oracle Data Integrator 11g Blog

Sunday, 5 February 2012

CREATING INTEGRATION PROJECT

 Hi Gurus,

Let me show you have to create an integration project.
But before that please refer the following links for more details about ODI PROJECT

Project Life Cycle

Oracle Data Integrator Project Components

To create a new integration project in ODI follow the following steps

 Run the ODI Studio

Connect to repository

Click on Designer

Click on New project as shown below

 Now the new project creation wizard opens
Enter some name for project 
Click on save

Now you have to import the required knowledge modules for your integration project.
For example you you want to map source and target belongs to the same oracle data server and if your loading strategy is either "control append" or "truncate/insert" then import the knowledge module
"IKM SQL Control Append"

Expand the PROJECT
Right click on Knowledge modules
And click on import knowledge modules
Click on search button
Browse to the 'xml-reference folder' under 'oracledi directory'
Click open
Then select the knowledge module
"IKM SQL Control Append"
and click ok

 You need not to save the report of import knowledge module.
Click ok
Now your project is ready to develop mappings

 


Thanks & Regards
WWW.ODIGURUS.COM

No comments:

Post a Comment