So, you're the admin, and you're ready to roll with an SAP HANA Cloud database instance. Great call! Let's map out the essentials to make sure you're all set.
Getting Subaccount Access Right
First things first – to deploy the database, you'll need access to a subaccount in your company's SAP Business Technology Platform (SAP BTP) global account. But, not just any access – you'll want the Subaccount Administrator role collection. If you find your user account missing this role, no worries. Just give a shout to your SAP BTP global account admin and ask them to hook you up. It's like getting the backstage pass for the deployment concert.
Unlocking the Toolbox: SAP HANA Cloud Administration Tools
Now, let's talk tools. To craft and manage your database instances, you're going to need the SAP HANA Cloud - tools plan in your subaccount. This magical plan opens the door to a trio of game-changers: SAP HANA Cloud Central, SAP HANA cockpit, and SAP HANA database explorer
To activate the new multi-environment SAP HANA Cloud tools, follow the instructions in the blog
Benefits and features of the multi-environment SAP HANA Cloud tools
The Old VS The NEWHANA Cloud tools in Cloud Foundry are still hanging around, but here's the scoop – the Cloud Foundry edition of SAP HANA Cloud Central is waving goodbye. It's officially on the way out. SAP's advice? Make the shift to the new multi-environment SAP HANA Cloud tools. That's where the buzz is, and that's where the future is headed.
Implementation Starts here
However, for SAP HANA on-premises scenarios, ensure the connectivity_proxy service plan is added to the connectivity service. If not available, contact the SAP BTP global account administrator to add this required service plan for self-service migration as this needs to be connected via cloud connector
Deploy a SAP HANA Cloud Database
SAP HANA DB SIZE
MEMORY AND STORAGE SIZE SUPPORTED BY HANA
Creating a Migration user in source database
Migrating from an SAP HANA database to SAP HANA Cloud requires a dedicated user in your SAP HANA source database. The Self-Service Migration tool will check whether the provided user has all needed privileges to perform the migration. Any missing privileges and the objects on which they must be granted will be displayed in the user interface.
On the source database, open a SQL Console in the Database Explorer.
Create a migration user by executing the following statement in the Database Explorer -
1 CREATE USER <username> PASSWORD <password> NO FORCE_FIRST_PASSWORD_CHANGE;
2. Grant the necessary privileges to the migration user by running the following script in the Database Explorer
GRANT SELECT ON _SYS_REPO.DELIVERY_UNITS TO <username>;
GRANT SELECT ON _SYS_REPO.ACTIVE_OBJECT TO <username>;
GRANT CATALOG READ TO <username>;
GRANT INIFILE ADMIN TO <username>;
GRANT TRUST ADMIN TO <username>;
GRANT CERTIFICATE ADMIN TO <username>;
GRANT CREATE REMOTE SOURCE TO <username>;
3. For each schema you need to migrate add this scenario :
GRANT SELECT ON SCHEMA "<SCHEMA_NAME>" TO <username>;
The SQL statement must be executed by the owner of the schema or any user who has the permissions to grant the required privileges.
Install and Configure the Cloud Connector
Connect to an SAP HANA Platform On-Premise Database
Migrating from SAP HANA On - prem
Fill the details in Self Migration Tools :-