Create a HANA MDC and access the SAP Web-based Development Workbench
In this blog you will learn how to create a HANA MDC Database and setup the SAP HANA Web-based Development Workbench on the SAP Cloud Platform trial account.
Prerequisites
SAP Cloud Platform Trail account (https://account.hanatrial.ondemand.com/)
Setup HANA DB
Navigate to Persistence > Databases & Schemas
Click New and select Database system of type HANA MDC, now enter a DB name and password, be sure to check Web Access, and click Save. Your DB will now be created.
Notice the creation process has started, wait for it to complete before starting the next step.
Access the SAP Web-based development workbench
Navigate to the persistence tab and select your DB.
Notice there are 3 hyperlink options down the bottom of the page, SAP HANA Cockpit, SAP HANA Web-based Development Workbench and SAP HANA Interactive Education (SHINE).
Click on the SAP HANA Web-based Development Workbench and you will see the following:
If you are getting this 404 whilst trying to access the Web-based workbench it is because you have not yet been assigned the roles to access it.
Navigate back to the HANA DB overview and select SAP HANA Cockpit.
you will see this screen pop up, enter your DB username (SYSTEM in most cases) and Password your created earlier:
Once logged in you will receive this notification. (this will only happen the first time you login)
Click OK and you will see you have been assigned the correct roles.
Click continue and you will be given access to the cockpit.
Now navigate back to the DB overview and select the SAP Web-based development workbench
The following screen will now be displayed.
Note: you will not yet be able to access the Editor or Catalog as you still require more permissions.
Click the Security button, navigate to Users on the left and select your DB user (SYSTEM in most cases).
Now you need to add further roles to your account, click the following button.
Now add the following roles:
- hana.ide.roles::EditorDeveloper
- hana.ide.roles::CatalogDeveloper
- hana.ide.roles::SecurityAdmin
- hana.ide.roles::TraceViewer
Click OK, then press Save.
Navigate back to the SAP Web-based development workbench and you are now able to access the Editor and Catalog
Editor Page
Catalog Page
Happy config!!
Click here to see how to connect to a HANA MDC, Create Schema & first DB table
Hello Shaun Bradridge,
nice blog. I followed the step but getting 404 error while accessing the cockpit. I tried adding the role eclipse too but there again the role itself is not available.
URL for cockpit : https://demodbXXXXXXXXXXXtrial.hanatrial.ondemand.com/sap/hana/admin/cockpit
Do you have any suggestions here?
Regards,
Thanu