Export Data from HANA Cloud to AWS S3

Create HANA DB Table and Inset data:

select current_schema from dummy;

-- Creating a table
CREATE COLUMN TABLE STUDENTS
(ID VARCHAR(10),
 S_NAME VARCHAR(30),
 S_DEPT VARCHAR(20)
 );
 
-- inserting data
 INSERT INTO STUDENTS VALUES('S001', 'Partha', 'SAP Functional') ;
 INSERT INTO STUDENTS VALUES('S002', 'John', 'SAP BTP Admin') ;
 INSERT INTO STUDENTS VALUES('S003', 'Mili', 'SAP App Dev') ;

Create AWS S3 Bucket

Add SSL Certificate (AWS) into HANA Cloud:

Now open the HANA DB Explorer SQL Console and use the below commands:

-- 1. Create certificate store SSL
CREATE PSE SSL;

-- 2. Register S3 Baltimore Root certificate
CREATE CERTIFICATE FROM
'-----BEGIN CERTIFICATE-----
-----END CERTIFICATE-----'
COMMENT 'S3';


-- 3. get the certificate id from registered certificates
Select * from certificates where comment = 'S3';

-- 4. add S3 certificate to SSL certificate store
ALTER PSE SSL ADD CERTIFICATE 195132;  
-- the certificate number entered is to be taken above select statement result.

-- 5. Sets a purpose for a PSE store
SET PSE SSL PURPOSE REMOTE SOURCE;

Export Data:

Verify the File and Data in AWS S3:

Alternative: SQL based Export:

-- Alternatively SQL statement for Exporting data
EXPORT INTO ‘s3-<AWSRegion>://<Key>:<Secret>@<S3BucketName>/hana-files/students2.csv' FROM DBADMIN.STUDENTS ;