Table of Contents

OWB - Oracle eBusiness Suite (EBS)

About

If you are interested in doing ETL with Oracle eBusiness Suite (EBS) using Oracle Warehouse Builder (OWB), please read on.

Setting up metadata extraction user

OWB employs a design-deploy-execute model as an ETL solution. As such, you need to import metadata from Oracle eBusiness Suite first before you can create mappings to perform ETL.

In EBS, the APPS schema holds key metadata of its tables, views and sequences.

However, in a production environment, it is assumed that you seldom get access to the APPS schema. Therefore, you need to set up a metadata extraction user so that OWB can extract metatdata out instead of from the APPS schema directly.

Here is how you do it:

Setting up data extraction user

The user you created in the last section only gets you the metadata. In the end, you want to extract data out by creating mappings in OWB to perform the necessary ETL. As a result, you need a user on the EBS database where you could extract data.

You could use the same user that you created for metadata extraction purpose, or you could use a different user.

You will need to provide your DBA with a list of objects that you need access in the EBS database. You DBA will then need to grant this data extraction user at least SELECT access to each object on your list.

Using OWB to do ETL with Oracle eBusiness Suite

Documentation / Reference