Saturday 11 April 2020

Migrate Calculation Views from On-Premise SAP HANA to SAP HANA Cloud – Part 2

Overview


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.

SAP HANA, Cloud Services SAP HANA, SAP HANA Study Materials, SAP HANA Learning, SAP HANA Cert Exam, SAP HANA Prep

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.

1. Access to SAP HANA Cloud
2. 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. 

SAP HANA, Cloud Services SAP HANA, SAP HANA Study Materials, SAP HANA Learning, SAP HANA Cert Exam, SAP HANA Prep

1.2 Create a project

At “Development” tab, right-click on the “workspace” and create a new project from template.

SAP HANA, Cloud Services SAP HANA, SAP HANA Study Materials, SAP HANA Learning, SAP HANA Cert Exam, SAP HANA Prep

Choose “Cloud Foundry” for Environment and select “SAP HANA Database Application”.

SAP HANA, Cloud Services SAP HANA, SAP HANA Study Materials, SAP HANA Learning, SAP HANA Cert Exam, SAP HANA Prep

Enter project name and create project.

SAP HANA, Cloud Services SAP HANA, SAP HANA Study Materials, SAP HANA Learning, SAP HANA Cert Exam, SAP HANA Prep

SAP HANA, Cloud Services SAP HANA, SAP HANA Study Materials, SAP HANA Learning, SAP HANA Cert Exam, SAP HANA Prep

Project “SALES” has been created.

SAP HANA, Cloud Services SAP HANA, SAP HANA Study Materials, SAP HANA Learning, SAP HANA Cert Exam, SAP HANA Prep

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.

SAP HANA, Cloud Services SAP HANA, SAP HANA Study Materials, SAP HANA Learning, SAP HANA Cert Exam, SAP HANA Prep

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.

SAP HANA, Cloud Services SAP HANA, SAP HANA Study Materials, SAP HANA Learning, SAP HANA Cert Exam, SAP HANA Prep

SAP HANA, Cloud Services SAP HANA, SAP HANA Study Materials, SAP HANA Learning, SAP HANA Cert Exam, SAP HANA Prep

Files are imported successfully. Delete “.hdbgrants” file because it is not used anymore.

SAP HANA, Cloud Services SAP HANA, SAP HANA Study Materials, SAP HANA Learning, SAP HANA Cert Exam, SAP HANA Prep

Adjust the schema name of “.hdbsynonym” file if needed.

SAP HANA, Cloud Services SAP HANA, SAP HANA Study Materials, SAP HANA Learning, SAP HANA Cert Exam, SAP HANA Prep

You can confirm the Calculation Views are successfully imported.

SAP HANA, Cloud Services SAP HANA, SAP HANA Study Materials, SAP HANA Learning, SAP HANA Cert Exam, SAP HANA Prep

2.3 Build the source files

Build the source files.

SAP HANA, Cloud Services SAP HANA, SAP HANA Study Materials, SAP HANA Learning, SAP HANA Cert Exam, SAP HANA Prep

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.

SAP HANA, Cloud Services SAP HANA, SAP HANA Study Materials, SAP HANA Learning, SAP HANA Cert Exam, SAP HANA Prep

We have successfully migrated tables and Calculation Views from On-Premise SAP HANA to SAP HANA Cloud.

No comments:

Post a Comment