Skip to Content
avatar image
Former Member

Is There a way to import data from Hana database?

Jan 18, 2018 at 02:44 AM | 253 Views

I need to integrate data from different views of Hana to complete my design of analytics in SAC.

My question is:
Is there a way to extract data from Hana database?

I mean:

I need to IMPORT data in SAP Analytics Cloud from a Hana database
Like to import data from a remote system
but the remote system is a Hana database. no to Live data.

We already have live data connection and it works very well but I need to use functions of the MODELER

Best regards

Jesus Palacios

SAP Analytics Cloud
SAP Analytics Cloud connectors
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Henry Banks
    Jan 18, 2018 at 08:30 AM

    Hi,

    As pointed out already, there is no support for "import from hana" - see the help pages here https://help.sap.com/doc/00f68c2e08b941f081002fd3691d86a7/2017.18/en-US/11b4e5ff76eb4747bc255d7037be1f01.html

    the reason for this is you potentially have 'big data' accelerated via in-memory storage... thus the argument would be 'why would you want to replicate that data again into another system'? it will become costly.

    regards, H

    Add comment
    10|10000 characters needed characters exceeded

    • RenĂ© Malmberg
      Oct 12, 2018 at 06:17 AM

      Hi John

      I know - but when. We are looking for this functionality now. And a live connection gives you further challenges with access - you need to be on your locale network to use a live connection as for an imported model, you do not

      Why not give the user of the SAC the ability to chose which solution (import vs live) is the best one

      You have BW import and live

      UNX live and import

      why not HANA?

      Br

      René

  • avatar image
    Erdem Pekcan
    Jan 18, 2018 at 05:42 AM

    Hi,

    Currently HANA connections support only live connection type. As an alternative, if you have BO enterprise as well, you can create a UNX on top of your views and import data based the UNX connection.

    Which functionalities you need in SAC modeller? Isn't it also possible in HANA modeller?

    Regards,
    Erdem

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Julian Jimenez
    Jan 30, 2018 at 02:41 PM

    Hi Jesus,

    If you have a small data set, you can import data from HANA using OData connections.

    https://apps.support.sap.com/sap/support/knowledge/public/en/2412507

    Regards,

    Julian

    Add comment
    10|10000 characters needed characters exceeded