How to Define Source Module and Import Source Metadata in OWB?

How to Define Source Module and Import Source Metadata in OWB?

Before I start writing this post some concepts (or your questions)  should have to be clear like…

What is the Module??

A module is an object in the Design Center that acts as a storage location for the various definitions and helps us logically group them.

Why it is required??

Before we can define or import a source data definition, the module must be created to hold it.

 

1. Defining Source Module

Step 1: Right-click the desired node and select the New option.

flat file module

 

Step 2: Enter the Project Name and click OK.

flat file module

 

Step 3: Expand the Projects Navigator until you find the node for the appropriate metadata type.

For example, if the source data is stored in Oracle Database, then expand the Databases node to view the Oracle node. If the source data is in an SAP R/3 system then expand the Applications node.

Expand the Database Navigator and Right-click on the Oracle and select the New.

flat file module

 

Step 4: You will see a welcome screen displaying the Create Module Wizard in that click on Next.

flat file module

 

Step 5: Enter the Name and Description of the Source Data Module and Click Next.

flat file module

 

Step 6: Click on the Edit Button to Enter the Database Information.

flat file module

 

Step 7: Enter the correct database information and Test the Connection and click OK then it will show you the information.

flat file module

 

2. Importing Source MetaData from Database.

Step 1: Right-Click on the ABC_Source module name under the Database node in the Project Explorer. Then select the Import from Pop-Up.

flat file module

 

Step 2: After that, you will see the Import Metadata Wizard and you have to click on the Next button on the next button on the Welcome screen.

flat file module

 

Step 3: Now you will see the screen presented with the labels with the different Object Type in that you have to Select Only Table Object Type and Click on Next Button.

flat file module

 

Step 4: After clicking on the Next button select the object to Import into the module. Then select the Table from availablle table and Import them accordingly.

flat file module

 

Step 5: After Importing Table you have to click on the Next button to proceed to the Summary and Import wizard. Then it will summarize the selections that you have made and tell us the action it is going to take for each selection whether to create or re-import the object.

After that click on the Finish button.

flat file module

 

Step 6: After Click on Finish button, which will begin the Import process. During the import, you will see a status dialog box display showing the progress of the importing object.

flat file module

 

Step 7: After Importing all Tables you will get the Import Result.

flat file module

If this tutorial helped you AT ALL, please leave a comment and I’ll be happy to answer any of your questions in the comment section below!

This Post Has 2 Comments

  1. Youre so cool! I dont suppose Ive learn something like this before. So nice to search out someone with some unique ideas on this subject. realy thank you for starting this up. this web site is something that is wanted on the internet, someone with just a little originality. useful job for bringing something new to the web!

Leave a Reply