Database migration from SAP HANA to Redshift

1

Hello All,

As of now, SCT doesn't support SAP HANA as one of the source databases. Any other way to migrate the SAP HANA database (schemas, views, procedures, function....) to Redshift?

I understand that for data migration, there are many available options (SAP Data Services, Snow family, Glue etc....).

Thank You! Rajendran

1 Answer
3

hi Rajendran, there are many ways how you can export data from HANA to Redshift, one of using ODP layer with OData to export HANA views/data to S3 first and then transform the data and load them into Redshift (see here https://github.com/patrick-leung/sap-aws-redshift-experimental/blob/master/patleung-sap-data-load-into-redshift-demo.ipynb). You can also use SAP Data Services to export data from SAP directly to Redshift (see here https://catalog.us-east-1.prod.workshops.aws/workshops/79435b9d-cf2e-4afc-a3f6-4eceeaf0865d/en-US/aws-datalakes-for-sap/application-level/2-8-sap-redshift), or use multiple AWS partner solutions (e.g. Qlik Replicate or HVR - see here https://aws.amazon.com/blogs/apn/how-to-get-real-time-sap-data-into-amazon-redshift-with-hvr/), or Syntax connector (https://blogs.sap.com/2021/03/03/the-aws-connector-for-sap/). Ping me if you need more details or want to chat directly.

answered 2 years ago
  • Hi Pavol, Thank you for your response. I get that there are many options available for the data migration. I am curious to know about the available options to migrate the SAP HANA database (schemas, views, procedures, function....) to Redshift?

    Thanks.

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions