Getting the most out of OWB and the Oracle Database

Oracle Warehouse Builder for SAP ETL: OWB SAP Application Connector

One of the less well-understood capabilities of Oracle Warehouse Builder is our SAP Application Connector. Many companies implement SAP ERP systems, and need to extract data from them into Oracle data warehouses. Warehouse Builder enables easy access to the data in these SAP systems through the connector, which is a separately priced option.

The connector has been around for several releases now and is a mature product being used successfully by many OWB customers. However, the public documentation on the connector has been rather sparse and in need of a refresh... We recently updated the material to provide a lot more detail on how the connector works and how to use it. You can get the full details here, in the OWB Connector for SAP documentation. Note that while this documentation refers to OWB 11.1, most of the information in it applies to older versions of the connector as well, such as OWB 10.2.

OWB ETL mappings to extract from SAP are designed within the familiar paradigm used by the rest of OWB. Oracle Warehouse Builder generates code in SAP's ABAP language to perform data extraction in a manner completely in line with SAP's supported mechanisms. Furthermore, the SAP connector allows you to comply with the administrative and security processes of the SAP environment, which should make your SAP administrators happy.

If you have more questions after reading the new documentation, let us know...

E.,
The Fusion Middleware 11g licensing documentation explains the details:
http://download.oracle.com/docs/cd/E15523_01/doc.1111/e14860/products.htm#CIAICCFC
* You must license the "Application Adapter for Warehouse Builder" for SAP. (The "Application Adapter for Warehouse Builder" is a new name for Warehouse Builder application connectors, to be more like other Fusion Middleware adapters and ODI application adapters.)
* To license Application Adapters for Warehouse Builder, you must have the "Oracle Data Integrator Enterprise Edition" (ODI-EE) license, which grants use of the OWB Enterprise ETL feature set and the right to add application adapters to OWB.
* The ODI-EE license is only available with Oracle Database Enterprise Edition. So you cannot license the SAP Application Adapter for use with Database Standard Edition One.
The price list is here:
http://www.oracle.com/us/corporate/pricing/price-lists/index.html
You need the Oracle Technology Commercial Price List.