Third-Party Tools As Destinations 
Use
You can use the open hub destination to extract data to non-SAP systems. Various APIs allow you to connect a third-party tool to the BI system and to use this third-party tool to distribute data to other non-SAP systems.
Features
First you extract the data from BI InfoProviders or DataSources into a database table in the BI system. The third-party tool receives a message when the extraction process is complete. You can define parameters for the third-party tool. You can also use the monitor to oversee the process.
You can use a process chain to start the extraction process not only in the BI system itself, but also using the third-party tool.
The Following APIs Are Available:
RSB_API_OHS_DEST_SETPARAMS: You use this API to transfer the parameters of the third-party tool that are required for the extraction to the BI system. These parameters are saved in a parameter table within the BI 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. In addition, you can add another parameter table that contains the parameters that are only relevant for the third-party tool.
RSB_API_OHS_REQUEST_SETSTATUS: This API sets the status of extraction to the third-party tool in the monitor. Red means that the existing table is not being 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 determines the details of an open hub destination.
RSB_API_OHS_DEST_READ_DATA: This API reads data from the database table in the BI system.
For information on the parameters of the APIs, see:
API:
RSB_API_OHS_DEST_SETPARAMS
API:
RSB_API_OHS_3RDPARTY_NOTIFY
API:
RSB_API_OHS_REQUEST_SETSTATUS
API:
RSB_API_OHS_DEST_GETDETAIL
API:
RSB_API_OHS_DEST_READ_DATA
Process Flow:
Extraction to the third-party tool can be executed as follows:
...
1. You define an open hub destination with Third-Party Tool as the destination type.
2. You create an RFC destination for your third-party tool and enter it in the definition of the open hub destination.
3. You use API RSB_API_OHS_DEST_SETPARAMS to define the parameters for the third-party tool that are required for the extraction.
4. You either start extraction immediately or include it in a process chain. You can also start this process chain from the third-party tool using process chain API RSPC_API_CHAIN_START. The extraction process then writes the data to a database table in the BI system.
5. When the extraction process is finished, the system sends a notification to the third-party tool via API RSB_API_OHS_3RDPARTY_NOTIFY.
6. The extracted data is read by API RSB_API_OHS_DEST_READ_DATA.
7. The status of the extraction is transferred to the monitor by API RSB_API_OHS_REQUEST_SETSTATUS.