on 04-25-2017 9:43 AM
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.
Hi,
This approach also applies to BW systems with Runtime licensing?
Best Regards,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
74 | |
26 | |
10 | |
10 | |
7 | |
6 | |
4 | |
4 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.