Skip to Content
0

How to make connection from BW4HANA system to BODS system?

Apr 25, 2017 at 08:43 AM

642

avatar image

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.

10 |10000 characters needed characters left characters exceeded

I am unable to see Data services in the source systems. TCP/IP connection working fine in data services.

0
* Please Login or Register to Answer, Follow or Comment.

5 Answers

avatar image
Former Member Apr 25, 2017 at 02:03 PM
0

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
Show 2 Share
10 |10000 characters needed characters left characters exceeded

Hi Anand,

Thanks for the reply, but the issue is from SAP BW 7.5 end as I am unable to see Data Services in the source selection drop down list.

0
Former Member

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

0
avatar image
Former Member Apr 27, 2017 at 06:16 AM
0

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

Show 2 Share
10 |10000 characters needed characters left characters exceeded

Hi Githen,

Thanks for the reply, I want to connect BODS as source to SAP BW4HANA as I am unable to see Data Services in the source selection drop down list in BW.

0
Former Member

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

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

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

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Dec 04, 2017 at 10:03 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Jan 16 at 09:58 PM
0

Hi,

This approach also applies to BW systems with Runtime licensing?

Best Regards,

Share
10 |10000 characters needed characters left characters exceeded