Is There a way to import data from Hana database?

[Former Member]

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

[Henry_Banks · Accepted solution]

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/11b4e5ff76eb4747bc255d7037be...

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

[Henry_Banks · Accepted solution]

I forgot to add - one option that may be available to you might be to Import from an Odata connection.

First you'd have to expose the HANA view as web service, and then consume it in SAC via Odata.

regards, H

[former_member234401 · Accepted solution]

HI Henry the link you provided is no longer active

[Henry_Banks · Accepted solution]

Hi,

Please navigate the Help page for SAP Analytics Cloud > Connections > Import Data Connection

You'll see that HANA DB is not listed there.

however we do support 'data import' from a number of "on Hana" solution, and i believe some customers do publish HANA views as an Odata consumer service which we can Import .

regards, H

[former_member234401 · Accepted solution]

Hi

Thanks for the comment on the link

As for the Odata connection - it would be better if we had a connection to import data as there are some limitations regarding the live connections - some we would really like to use

link to limitations on HANA live connection

An Odata connections is not just something a business analyst creates on the fly.

I a data discovery tool you would like to have as many connections as possible with out having to involve the IT department

Br René

[JohnL · Accepted solution]

Those limitations will keep getting smaller and smaller over time.

[former_member234401 · Accepted solution]

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é

[amosang · Accepted solution]

I feel that it's about accessibility. A good platform or product should be able to freely and easily connect to any other product, especially when this is what competitor products are touting.

Moreover, SAC's predictive and ML features require the full data set to work on, which implies importing the full data set into SAC, which implies Import Connection. Isn't it strange that it's actually easier to connect to non-SAP products (eg: MySQL), and to have SAP HANA connections be crippled and limited to only Live Connections?

[Henry_Banks]

Hi amosang21 this is an old thread.

I'm happy to say that we closed this gap since while and can now "import from Hana" using a native connector rather than an odata endpoint https://help.sap.com/viewer/00f68c2e08b941f081002fd3691d86a7/release/en-US/61f2f4c1bc6f4479851913167...

regards

H

[amosang]

Hi Henry,

Thanks for the comment and link, I've managed to get it working (Import conn from SAP HDB). I previously had not installed SAP JCo.

Also noted that in SAP CC config, need to use protocol TCP instead of HTTP/HTTPS. I guess this is because the SAP HDB does not speak HTTP(S)...

Cheers,
Amos

[barnaby]

For customers with a SCP-based HANA system (cloud) and SAC who need to import data for SAP Cloud for Planning use, what's the solve? It seems that this import is possible only for on-prem HANA systems.

[erdempekcan]

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

[Former Member]

Hi Erdem

Thanks for the response

The function that I need is the following:

In Hana I have two views View 1 with Dimension "A" and Measure "1" View 2 with Dimension "A" and Measure "2"

I need to compare Measure 1 and 2

My analytic model in SAC has Dimension A and Member Acoount 1 and 2

To fill my model with the correct information I thought about doing two import the first with the view 1 and the second with the view 2 that way I can apply my comparative and conditional formating For that reason I need to do the Import

Example: Measure 1 and 2

I know that the best opcions is 1 view with everything integrated but for different reasons I can not count on it

thanks for your time

Regards

[erdempekcan]

Hi,

You can link live HANA models in SAC. Use Dimension A in your sample.
Alternatively you can create a top level view in HANA to merge those two views.

Regards,
Erdem

[julian_jimenez]

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