Skip to Content

Extract data from SAP HANA to S3 on a regular basis

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

Add a comment
10|10000 characters needed characters exceeded

  • 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.

  • 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

  • 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

Assigned Tags

Related questions

0 Answers

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.