Does SAP BW 'Close the loop'?
Closing the Loop with SAP BW
SAP BW provides a few options for extracting data for use in interface programs that feed data streams into operational or analytic applications:
* DataMart interface — From a technical point of view, the DataMart interface is nothing more than the BI Service API. The DataMart interface allows building complex information logistics models, as shown in the topology examples in Chapter 5 (assuming both local and global data warehouses are on SAP BW). All InfoProviders available are at the DataMart interface’s disposal. However, use of the DataMart interface is restricted to SAP BW systems.
* Retractors — These are dedicated ABAP programs reextracting data from SAP BW into an SAP ERP system. Retractors are a relatively new concept and are currently only available for a few applications, including SAP SEM-BPS and SAP CRM.
* SAP BW Java Connectors — This is an official API for executing queries and retrieving query results. Custom programs can access OLAP cubes to retrieve query results for any purposes. By using the either the ODBO or XMLA interface through the Java SDK, any front-end applications in almost any programming language can access SAP BW query results. However, using OLAP results is not recommended for use with large result data sets, as it is optimized for interactive applications, not extractions.
* Open Hub Services — These allow you to define controlled and monitored data-export processes, exporting data target contents into a flat file, a flat database table, or an application for further processing. Open Hub Services may end up as the Dodo bird did.... time will tell.
Are these the options good enough? Share your comments with us and look for our perspectives and commentary in future posts.
