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...

Comments:

How is licencing SAP connector? Am using Oracle Stadard Edition One, so can i just buy additionally connector, or I must has EE? What is the price of connector for SAP?

Posted by E. on November 07, 2010 at 04:50 PM PST #

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.

Posted by antonio romero on November 08, 2010 at 08:08 AM PST #

Hi .

I want to insert values from non SAP oracle into SAP oracle DB ,how OWB is usefull.

Regards

Posted by guest on December 08, 2012 at 03:41 AM PST #

Post a Comment:
  • HTML Syntax: NOT allowed
About

ETL, CDC, Real-Time DI and Data Quality for the Oracle Database from the inside.

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today