Skip to Content
Technical Articles
Author's profile photo Sreekanth Surampally

Exporting data from HANA cloud to Amazon S3 Storage

SAP HANA cloud offers data import and Export options to public Cloud storage services like Amazon S3, Azure Storage and Alibaba cloud OSS. In this blog, I will explain about data export to Amazon S3 storage from HANA cloud objects. However, the process is going to same for other cloud services as well. To perform this workshop, I am using HANA cloud trial and AWS free tier S3 storage.

At first, I am going to access Database Explorer — > invoke SQL console and create a DB table and insert some data records for data export.

In the next Step, I am going to Set up Amazon S3 storage service and create a bucket to store the data files. I have chosen Canada data center and updated with setting public access.

now, I am going to get the Trust Certificate from Amazon S3 service. I have shown the steps to get the certificate in video below. Also I have provided the certificate in this Github file along with other SQL statements to be run for creating SSL trust. so that, you can easily access the code.

It is all set up now. Let us Export the data from the table, Select the table and choose Export data from Context menu.  Then choose the Cloud store option as Amazon S3, provide the region and path for s3 bucket as shown below. how to get the Access key and secret key is also explained in the video tutorial.

Export is finished and file is now placed in S3 bucket. It can be downloaded and moved to another secure location for external usage.

Alternatively we can run the SQL command to do this export, EXPORT into SQL statement is used for that. Code snippet can be found in this github file.

That is it, now we have successfully exported data HANA Cloud table to Amazon s3 cloud storage, with this feature, you can also export catalog objects, data from Calculation views data as well.

Video recording on this session is below. https://youtu.be/z1fnNJZuXek

 

Thanks

Sreekanth

 

 

 

 

 

 

Assigned tags

      3 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Vivek Kumareng verma
      Vivek Kumareng verma

      Nice blog

      Author's profile photo Anton Efremov
      Anton Efremov

      Thank you Sreekanth for your blog!

      Another helpful statement at the end as step 5 for me was:

      SET PSE SSL PURPOSE REMOTE SOURCE;

      Some additional information can be found here.

      Author's profile photo Michael Kaufmann
      Michael Kaufmann

      Hi Anton, the link does not work (seems to be internal). Regards, Michael