Import data from AWS S3 to HANA Cloud

[Cocquerel]

Hello,
I would like to import data from AWS S3 to HANA Cloud as described here : https://help.sap.com/docs/hana-cloud-database/sap-hana-cloud-sap-hana-database-administration-guide/...
For AWS S3, I'm using a BTP Object Store instance https://discovery-center.cloud.sap/serviceCatalog/object-store?service_plan=standard&region=all&comm...
It appears that it is  required to upload AWS Certificate into HANA Cloud PSE.
How can I get this certificate ?

[HakanHaslaman · Accepted solution]

Please check, if this is working via Google Chrome:

1. Open web browser and navigate to your S3 bucket URL. It should be something like `https://s3.amazonaws.com/your-bucket-name`.
2. Click on the lock icon in the address bar, then click on "Certificate".
3. In the Certificate window, go to the "Details" tab and click on "Copy to File...".
4. Follow the Certificate Export Wizard to save the certificate as a .CER file.

Once you have the certificate, you can upload it to HANA Cloud PSE as described in the SAP HANA Cloud documentation.

[Cocquerel · Accepted solution]

Thanks, it is working fine

[HakanHaslaman]

The certificate you need is the SSL certificate for the AWS S3 endpoint you are connecting to. This is not something you generate, but something provided by AWS. 

[Cocquerel]

ok but how to get it ?