Skip to Content

How to make connection from BW4HANA system to BODS system?

I have a table in SQL server. Now, I want to extract data from SQL server to BW4HANA using SAP BODS . We have TCP/IP connection already exist in BODS system, but in SAP BW 7.5 there is no Data services showing in source systems. How will I use BODS connection in BW4HANA system? Please suggest.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Apr 25, 2017 at 02:03 PM

    Hi Ameya G,

    I feel you have to dump the data into BW HANA Studio level with the help of BODS. Please follow below steps.

    The major steps involved in loading data from SQL to HANA through DS:

    • Create Data Store between SQL and BODS
    • Import the metadata (Structures) to BODS.
    • Create Data Store between BODS and HANA Studio
    • Import the metadata to HANA system.
    • Create Project.
    • Create Job (Batch/Real time)
    • Create Work Flow
    • Create Data Flow
    • Execute the job
    • Check the Data Preview in HANA Studio
    Add comment
    10|10000 characters needed characters exceeded

    • Hi Ameya,

      Thank you for the response. I feel in BW7.5 I can' t see Data services as source system.

      To meet your requirent you need to push the data to HANA Studio level from SAP BODS as mentioned above,then create information views and consume then in transient provider or conenct it to BO - Webi.

      BR/

      Anand Kotha

  • Apr 27, 2017 at 06:16 AM

    Hi Ameya,

    Using BODS you have to push data to HANA tables. Then you can create HANA views (Attribute, Analytic or Calc views) and this you can consume in BW/4 HANA composite provider

    Regards

    Githen

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Ameya,

      You cannot create a connection from BW instead you have to create a datastore between BODS and HANA studio in BODS. This enables BODS to push data to HANA tables.

      Regards

      GIthen

  • avatar image
    Former Member
    Jul 10, 2017 at 11:03 AM

    Hi

    Is there any documented entry by SAP which says connection using BODS is not possible and to use SDI in place of BODS ? There are many customers who are using BW and BODS. Would this not impact them ? Ive gone thorugh BW4HANA documentation but am not able to find anything in this area

    Regards

    Vinieth

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 04, 2017 at 10:03 AM

    Hi Ameya,

    You cannot push data directly to B4HANA like in older versions of BW. Instead you need to push data to the HANA Database below and use those tables in BW4HANA.

    Thanks

    Raghavan

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 16 at 09:58 PM

    Hi,

    This approach also applies to BW systems with Runtime licensing?

    Best Regards,

    Add comment
    10|10000 characters needed characters exceeded