Business Intelligence – Oracle

Oracle Warehouse Builder 11g/10g – Ebusiness Suite Connector

Posted by Venkatakrishnan J on August 31, 2007

I was speaking to one of the users of OWB yesterday and the conversation drifted towards the Ebusiness Suite connector that OWB 11g/10g provides to the end users. The user wanted to know how is the ebusiness connector different from a normal connection to an oracle database? It made a lot of sense to me considering the fact that OWB connector does not provide out of the box ETL mappings (based on business modules in ebusiness suite like BI Applications) to a target warehouse. The only way to find that out was to use the connector and see what it does differently. I did exactly that and thought that this deserves a blog entry in itself. Ebusiness suite connector does a lot of things other than connecting to the ebusiness database. It logically groups all the tables according to the business functions.

The first step i did was to create a connection to an ebusiness suite database using the Application module. The connection details would be exactly same as what you would give for an oracle database.




Once the connection details are specified, the connector gives a window that would look like this


As you see above, the connector provides 2 options. First one is an option where in one can choose a business domain and the 2nd one is an option similar to an ordinary table import wizard from a schema. The 1st one is the one that is unique to the connector i.e identifying and segregating the tables based on the business modules. The business modules would look like this


In our illustration i would choose the Order Entry (OE) module and import all the tables under that.



As you see above, the connector helps a developer in working on the tables that are specific to his module. It reduces a lot of effort, considering the fact that ebusiness suite has a huge number of tables. Apart from making the life of a developer easy by segregating the tables and views, the connector can also write back to an ebusiness suite instance. It can deploy objects to the concurrent manager. One can use the ebusiness suite objects both in the mappings and also in the process flows. One can access the documentation about the connectors here

9 Responses to “Oracle Warehouse Builder 11g/10g – Ebusiness Suite Connector”

  1. Umesh said

    Good Post as usual. E-Bis already has strict naming convention and typically a table for OE will start with OE_. Though there are overlaps like certain tables are used across the modules. HZ_% tables being one of the example of this. It would be interesting to see whether this are brought over while migrating AR module and even OE module (both of this use HZ_% modules extensively).

    I have worked with OWB for some time but never got an opportunity to use the E-Bis connector. It would be interesting to see whether the connector leverages the flex-field setups and other metadata and present it to the ETL developer in more user user friendly manner. The connector is paid option and I bet that it should have some interesting features to extract the transaction and master information from EBS more easily without bothering about where to go for lookups, or which tables to link for particular transaction etc. Also it would be good to explore the parallels/contrasts between the EBS adapter for OWB and the one that comes with SOA suite. Some thought food 🙂

  2. Lian said

    Hi Venkat,

    Can we use Oracle Warehouse Builder to load data into Oracle EBusiness Suite table(s)?
    For example: we may have a workflow system to create Chart of Accounts, once a new
    account is created there, we would like to load the new account into Oracle Ebusiness Suite.


  3. Lian,

    I’m one of the PMs for Warehouse Builder.

    The short answer to your question is “yes”. All of the OWB Connectors (except the one for SAP) allow you to write to the application as a target.

    Come to for more details.

  4. eylem said

    Hi all,

    We want to get data and load data with oracle – SAP systems.has Ware house the capability of transferring data from
    SAP to oracle and Oracle to sAP ?AS I understand we can not do from SAP to oracle by OWB ,can we ?if we can not.
    How can we do in a different way ?

  5. Michelle said

    Hi Eylem,
    Yes, OWB does have an adapter for extracting from SAP R/3 into Oracle database. Here are some links related to OWB 11.1. And the adapter is also available for OWB 10.2.

    Click to access warehouse-builder-11g-connectors-datasheet.pdf

    Click to access warehouse-builder-11g-erp-data-integration-connectors-whitepaper.pdf

  6. Oscar said


    do you have all installed on windows?, i need to connect Warehouse Builder installed on unix with SQL Server, how can i do that?


  7. greg said

    Hi all,

    Oscar thats a different choice i guess i am not sure many might have tried installling it the way you wish, i would love to know how as well.


    • Oscar said

      hi, in fact i have connected this two managers
      oracle (on unix) and SQL Server
      without problems using unixodbc and the correct driver for sql server (freetds)
      after configuring oracle net we can use dblinks
      between databases tranparently.

      I think this is very important because Im developing ETLs
      and we often find oracle over unix and SQL Server like source database


  8. Nice post, nice blog, I was searching for this nowadays, thank you. I found this site on erp :

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: