Send HANA data to external DB

[kgaurav2k14]

Hi Friends,

I have actuals data in my HANA Box which needs to be send out to an external location from which a third party planning tool can do planning on top of that. How do we send data from HANA to external location like FTP or external DB for that matter.

Thanks,

Gaurav

HDB 2.0 SP3

[michael_eaton3]

You could use HANA Smart Data Integration to do this. It is built into HANA, but it is a licensed component.

Michael

[kgaurav2k14]

Hi Michael,

If I am not wrong, SDI can only be used if my target is HANA. If you look at my req, I want to send data from HANA to external 3rd party locations/db/systems.

Thanks,

Gaurav

[michael_eaton3]

Hello

SDI can also be used to load external sources, see the PAM for the full list of adapters and whether they support being used as a source and/or target.

Here's a snippet.

[Abhinav_Sharma]

Hi Deepak,

You can use SAP Data Services or SAP SLT for doing replication if you want to automate the data transfer from HANA to external DB.

To know about SAP Data Services - https://help.sap.com/viewer/eb3777d5495d46c5b2fa773206bbfb46/2.0.02/en-US/d4cab7b0bb5710148e8ecb8c74...

For SLT, refer https://blogs.sap.com/2018/04/11/slt-data-replication-from-sap-to-non-hana/

Other option is you can always create custom program which read the data from HANA and dump the same to external DB.

Regards

Abhi

[kgaurav2k14]

Hi Abhi,

We do not want to buy any other data provisioning component. Is there anything within Enterprise HANA which can be used to send data from HANA to external location/system/DB.

Thanks,

Gaurav

[deepak-kalra]

Hi kgaurav2k14

Regards
Deepak

[kgaurav2k14]

Hi Deepak,

It has to be an automatic job. Everyday the contents of my calculation view should be sent to some external location or external db. Not the manual file upload.

Thanks,

Gaurav

[Vitaliy-R]

SAP Data Hub (aka SAP Data Intelligence) can be used for orchestration and pipelining of data movements too.

https://developers.sap.com/topics/data-hub.html

[kgaurav2k14]

Hi Witalji,

We do not want to buy any other data provisioning component. Is there anything within Enterprise HANA which can be used to send data from HANA to external location/system/DB.

Thanks,

Gaurav