You can use the open hub service to extract data to non-SAP systems. Various APIs allow you to connect a third-party tool (such as Ascential) to the BW system and to distribute data to other non-SAP systems.
API: |
Use |
RSB_API_OHS_DEST_SETPARAMS |
You use this API to transfer the parameters of the third-party tool that are required to extract data to the BW system. These parameters are saved in a parameter table in the BW system in the metadata for the open hub destination. |
RSB_API_OHS_3RDPARTY_NOTIFY |
This API sends a message to the third-party tool after extraction. It transfers the open hub destination, the request ID, the name of the database table, the number of extracted data records and the time stamp. You can also add another parameter table containing parameters that are only relevant for the third-party tool. |
RSB_API_OHS_REQUEST_SETSTATUS |
This API sets the status of the extraction to the third-party tool in the open hub monitor. Red means that the existing table is not overwritten. If the status is green, the request is processed further. |
RSB_API_OHS_DEST_GETLIST |
This API delivers a list of all open hub destinations. |
RSB_API_OHS_DEST_GETDETAIL |
This API finds the details of an open hub destination. |
RSB_API_OHS_DEST_READ_DATA |
This API reads data from the database table in the BW system. |
Interface Properties:
BW read interface
Programming language is ABAP
Mass data is supported
Execution in background
Programming knowledge is required
Data has to be in an InfoProvider
More information: SAP Data Services and Third-Party Tools as Destinations.