Setting Up a New ODI Project

Now you assume the role of a project leader who is starting an integration project.You create a project named HandsOnLoads with a folder named HandsOn. You import knowledge modules for working with three sources (Hypersonic SQL, XML, and File) and one target (Oracle.)
Note: Completing this practice is critical for all the following practice sessions.


Your Tasks:
1. Create a project, HandsOnLoads, with a folder called HandsOn.
a. In Designer Navigator select Projects tab, click the New Project  icon, and then select New Project.


b. Enter the name of the project: HandsOnLoads. The code is automatically generated.

c. Click the Save button to create the project. The project appears in the tree view. Expand the HandsOnLoads project node.

d.ODI creates a folder called FirstFolder. Double-click this folder. In the editing window that appears, edit the folder in the Name field, HandsOn. Click the Save button.




2. Import the knowledge modules required for working with the following technologies:

•  Sources:
• Hypersonic SQL
•  XML
•  File
•  Targets
•  Oracle

a. Select the HandsOnLoads project node. Right-click, and then select Import > Import Knowledge Modules.

b. The Import Knowledge Modules window appears. Click the button


c. Navigate to C:\Oracle\Middleware\Oracle_ODI1\oracledi\xml-reference,and then click Open. A list of knowledge modules appears.




d. Select the following knowledge modules that are used in this project. Use the Ctrl key
for multiple selections. Click OK. In the screen that follows, click Close.

• CKM HSQL
• CKM Oracle
•  IKM Oracle Incremental Update
•  IKM SQL Control Append
• LKM File to SQL
•  LKM SQL to Oracle

e. Review Import Report, and then close it.


f. Check the imported knowledge modules by expanding corresponding nodes under
HandsOnLoads > Knowledge Modules, as shown here:



Close the HandsOnLoads and HandsOn tabs.