locked
SAP BI Connector for SSIS run Queries directly RRS feed

  • Question

  • Hi,

         Can I run queries directly on SAP BI tables to pull data to my SQL Server tables without creating a process chain, using the SAP BI Connector in SSIS. If not, what are the other alternatives in SSIS to pull data with directly running queries on SAP BI tables.

    Thanx

    Tuesday, October 9, 2012 4:11 AM

Answers

  • I doubt here..

    Please check this white paper for the same.. 

    To configure SAP BI to extract data into a non-SAP destination such as SQL Server, you need to follow these steps: (Copy from above link)

    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.


    Let us TRY this |


    My Blog :: http://quest4gen.blogspot.com/

    • Marked as answer by Eileen Zhao Tuesday, October 16, 2012 7:14 AM
    Tuesday, October 9, 2012 5:03 AM