Extract data from SAP HANA to S3 on a regular basis

[former_member536289]

Hi everyone,

I'm searching for a reasonable approach to extract data from several SAP HANA views to S3. The sticking point is that my customer wants a HANA-independent solution where extraction can be flagged\initiated "by AWS" on a regular basis. Based on this, an option of a scheduled BODS job moving data to S3 bucket does not seem applicable.

I've looked through AWS Storage Gateway and AWS Glue possibilities briefly. Still not sure if I'm moving in the right direction and not inventing the wheel.

Any ideas or experience sharing would be highly appreciated.

Elena

[michael_eaton3]

Hello

There are numerous ways to achieve this, as various tools can execute SQL and write the resulting dataset to S3. If you intend to 'pull from AWS' you'll need a solution to the possible security issue of opening ports from HANA to AWS.

You could always have AWS trigger the execution of a Data Services job, which is possible via the Data Services' Administrator web service.

Where is the HANA instance, AWS or elsewhere?

Michael

[markmumy]

To reiterate the other post, don't forget about security... Once the data is out of HANA you have lost all security, encryption, data masking, etc.

What is the source? Is it just a native HANA system? Suite on HANA? S/4HANA? BW on HANA? BW/4HANA?

Mark

[former_member536289]

Thank you for your answers.

It's an on-premises native HANA system.
Triggering a DS job via web service sounds as a good alternative. Frankly, I haven't thought of this option at all.

You are right, security aspect should be considered thoroughly. The project is very much in its infancy so we haven't discuss yet what data the customer actually wants to extract, how sensitive it could be etc.. Besides, I'm not sure if they have an AWS security admin on their side. Most likely, I'll be responsible for this part also.