We are well aware of creating a open hub destination for flat file/database table but we are still remained with ambiguities on third party tool .
Here is the method defined briefly which may clear some of our ambiguities.
Firstly the Open hub services are used to extract data from SAP BI/BW System to non-SAP System’s.
Before sending a request a to Third party tool the data should be extracted to a table.The Third Party tool receives a message through RFC from after completion of extraction.
Creation of Open hub Destination-Third Party Tool as destination.
Select Third-Part Tool as destination.
Select generated RFC for third party tool.
After defining Open Hub destination for third party tool’s an RFC call will send a message about the completion of extraction of data from BI to Table and then the API’s can be used to read data.
Below are few steps which can be followed from http://help.sap.com/saphelp_nw70/helpdata/en/43/7a69d9f3897103e10000000a1553f7/content.htm
Usefull notes http://msdn.microsoft.com/en-us/library/dd299430.aspx
Hope some of your ambiguities were cleared…