Migrate Calculation Views from On-Premise SAP HANA to SAP HANA Cloud – Part 2
The objective of this blog series is to share the experience of migration test from SAP HANA On-Premise to SAP HANA Cloud. In Part 1, I have converted classical Calculation Views to XSA based HDI Container model. In this blog i will migrate the model from SAP HANA On-Premise to SAP HANA Cloud.
Step1. Migrate classical Calculation Views to XSA HDI Container objects
Step2. Import the migrated objects to SAP HANA Cloud
Step3. Transfer data from On-Premise to Cloud.
Please note that SAP has plan to release migration tool (the planned first scope is from SAP Cloud Platform, HANA Service (HANA as a Service / HaaS) to SAP HANA Cloud), this means probably the steps described in this blog will be obsolete in the future.
Let’s get started. We will proceed in the following steps.
- Access to SAP HANA Cloud
- Import and Build the model
1. Access to SAP HANA Cloud
1.1 Access to SAP HANA Cloud with SAP Web IDE for full-stack
Open SAP Web IDE for full-stack and go to “Global Preferences > Workspace Preferences > Cloud Foundry”, and then configure API Endpoint, Organization and Space of SAP HANA Cloud. For details, please refer to SAP HANA Academy Youtube channel.
1.2 Create a project
At “Development” tab, right-click on the “workspace” and create a new project from template.
Choose “Cloud Foundry” for Environment and select “SAP HANA Database Application”.
Enter project name and create project.
Project “SALES” has been created.
2. Import and Build the model
2.1 Export source files
Export source files from On-Premise SAP HANA. The file is exported as a ZIP file.
2.2 Import the source file
Import the ZIP file into SAP HANA Cloud. Right-click on the “src” folder under “Sales” project and import file.
Files are imported successfully. Delete “.hdbgrants” file because it is not used anymore.
Adjust the schema name of “.hdbsynonym” file if needed.
2.3 Build the source files
Build the source files.
Check that Build process is completed successfully. You can confirm that Calculation Views are created and accessible from Database Explorer. Output is 0 record because no data has been migrated at this point.
We have successfully migrated tables and Calculation Views from On-Premise SAP HANA to SAP HANA Cloud. Migrate data from On-Premise SAP HANA to SAP HANA Cloud on the next blog.
Great blog series!
what was the process to create the HDI container on the SAP HANA Cloud database? I have created a database instance, but when I build my MTA projects, the objects are not being created in my database