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