Skip to Content
0

Can we load data from SAP HANA to Excel using SAP BODS?

Nov 03, 2016 at 08:44 AM

101

avatar image

Can we load data from SAP HANA database to excel 2013 (.xlsx) using SAP BODS?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Devilal Rajappan Nov 11, 2016 at 10:00 PM
2

Refer this alternate method.

Share
10 |10000 characters needed characters left characters exceeded
Arun Sasi Nov 14, 2016 at 10:45 AM
2

Data services doesnt have Excel as a target option to load data, but we can load in to excel using a different approach

So the Flow will be

1) Create a HANA database datastore

2) Pull the data and load in to an XML file(Target)

3) XML as input to load excel file using the approach mentioned in below URL

https://blogs.sap.com/2014/09/16/an-approach-to-build-target-file-in-excel-format-in-sap-bods-using-xsl/

@Dirk Can you please correct if any of the steps are missing.

Regards

Arun Sasi

Share
10 |10000 characters needed characters left characters exceeded
Aasavari Bhave
Nov 04, 2016 at 02:13 PM
0

DS supports only reading from excel, not loading. An alternative is to load a CSV that can be opened in excel.

Share
10 |10000 characters needed characters left characters exceeded