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_FT_RT in the Name field. The Code field is filled automatically. Click Save icon . The newly created ODIexp_FT_RT project now appears in the Projects tree view. You have now successfully added a new ODI project.
4 .	You export a flat file directly to a relational table target. The knowledge modules required for this are LKM File to SQL and IKM SQL Incremental Update. To import the KMs, expand the Project tab in the left panel, right-click the Knowledge Modules folder and select Import Knowledge Modules. Note: In this example, the generic SQL KM is used. However, specific KMs for the RDBMS technology can be used as well.
5 .	On the screen that follows,in the File Name, navigate to xml-reference directory as shown in the following screenshot. Click Open.The files to import should appear in the Import Knowledge Modules window. Select IKM SQL to File Append. Click OK.
6.	On Import Report window, click Close.