After implementing the next tutorial BTP Onboarding: SAP HANA Cloud, as the best step by step tutorial that i found, i would like to share my experience in what i really did in a quick way since i created the HANA instance until i opened my SQL console at first time, so you will win a lot of time trying to access with maybe not required steps that are documented in that great video (if in your case you need to follow all the steps, then feel free to do it in this case i had good luck to find a quick way):

 

  • Search; SAP HANA Cloud and click

  • Create your instance with hana plan:

  • Dont forget your password, so you need to find the nex json node and then set your password:

“systempassword”: “WAO_Robotics_HANA_1”,

{
    "data": {
        "additionalWorkers": 0,
        "availabilityZonePlacement": {
            "highAvailabilityCrossMultiAZEnabled": false,
            "initialReplicaAvailabilityZone": "",
            "initialSourceAvailabilityZone": "",
            "primaryAvailabilityZone": "",
            "secondaryAvailabilityZone": ""
        },
        "edition": "cloud",
        "enabledservices": {
            "docstore": false,
            "scriptserver": false
        },
        "extensionservices": null,
        "memory": 30,
        "memoryScaleOut": 0,
        "productVersion": {
            "id": "",
            "releaseCycle": "",
            "track": ""
        },
        "project_name": "",
        "serviceStopped": false,
        "slaLevel": "standard",
        "storage": 120,
        "systempassword": "WAO_Robotics_HANA_1",
        "template_name": "",
        "update_strategy": "with_restart",
        "vcpu": 2,
        "versionIndicator": "",
        "whitelistIPs": []
    }
}

 

  • Your BTP system will start creating your instance:

  • Once your instance is complete, you will see the status as Created:

  • Now you need to create a subscription called tools where i didnt configure any service or any complex steps (for me was very simple):

  • Now you need to configure the role collection: SAP HANA Cloud Administrator

  • Here there is an step that is not completelly explained in the video, when we can to see in the right menu the tool called: SAP HANA Cloud, you only needs to go to your subaccount for example and click then in “dev” sapce:

 

  • Now you will find SAP HANA Cloud in the menu:

  • Now if you click in SAP HANA Cloud, you will see your SAP HANA Database Instances:

  • Now you will be able to open the SQL Console:

  • Once you click then you will be requested to add your credentials with your same identity provider user that you gave the role collection:

 

 

  • Sometime you will be requested to use an special user and password, so:

User is: DBADMIN

https://help.sap.com/docs/HANA_CLOUD_DATABASE/c82f8d6a84c147f8b78bf6416dae7290/de4ee8bbbb5710148a04f023da147c8d.html 

Password: what you added when you created the instance WAO_Robotics_HANA_1

 

  • In the video we are requested to create an instance from SAP HANA Cloud Central, but it is important to say that i didnt create anything, for me was automatic:

  • Even as last configuration if you want to see technical configurations click in the next menu: Manage Configuration option and then even you will confirm the standard user that i explained steps above

 

Enjoy it and success!

Sara Sampaio

Sara Sampaio

Author Since: March 10, 2022

0 0 votes
Article Rating
Subscribe
Notify of
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x