Best practice to export data from SAP BW to third party systems.

[Former Member]

I am deciding if I should use Open Hub Services, ABAP transfer method or Analysis Process Designer  in order to export data from SAP BW 7.0 to SQL Server 2008. The data should be exported daily in Delta mode and  we need to integrate the extraction process in a process chain. Thanks

[Former Member · Accepted solution]

Hi,

To configure SAP BI to extract data into a non-SAP destination such as SQL Server, you need to follow these steps:

1. Set up the RFC Destination.
2. Configure and create the Open Hub Destination.
3. Create the Data Transfer Process (DTP) and transformation.
4. Define parallel processing.
5. Define the size of the data package.
6. Configure the process chain.

Regards,

Aravind.

[Former Member · Accepted solution]

Hi,

Thank you for your quick response.