Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Nov 11, 2016 at 10:00 PM

    Refer this alternate method.

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 14, 2016 at 10:45 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 04, 2016 at 02:13 PM

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

    Add comment
    10|10000 characters needed characters exceeded