Database migration from SAP HANA to Redshift
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
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.
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?
SAP HANA on AWS & EC2 Placement GroupsAccepted Answerasked 2 years ago
SAP Bank Analyzer 9.0 support on AWSAccepted Answerasked 5 years ago
PowerShell script to Start and Stop of SAP Services and Ec2 instance running on windows platform using SSM
What SAP products are supported for deployment using AWS Launch Wizard for SAP?
Are there synergies between SAP Business Technology Platform and AWS services?*asked 13 days ago
Optimal AWS native service to migrate HANA to?asked 7 months ago
Database migration from SAP HANA to Redshiftasked 2 months ago
Migration of SAP HANAasked a month ago
Automate Start or Stop of SAP HANA systems Ec2 instance running on hybrid platform
How do I configure GP3 for SAP HANA?Accepted Answer