Oracle Warehouse Builder for SAP ETL: OWB SAP Application Connector
By antonio romero on Dec 07, 2008
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...