Create HANA 2.0 Custom View in SAP Web IDE using Cloud Foundry HANA Trial account: Part 1
Part 1: Set up the Cloud Foundry Trail Account for using SAP Web IDE
With SAP Marketing Cloud you are able to import own SAP HANA Views by using the SAP Fiori App “Add Custom View”. This blog post will tell you steps you need to carry out to set up the SAP Web IDE to build the HANA Calculation Views.
There is an information that is now showing up in “Add Custom View” application in SAP Marketing Cloud that in the upcoming release HANA views would be migrated to HANA 2.0. Post that migration you can only import views that are modelling using HANA 2.0 Modeller ( ex: SAP Web IDE)
In this blog post it is explained how to set up SAP Web IDE in Cloud Foundry HANA Trail Account of SAP Cloud Platform.
Create TRIAL ACCOUNT in Cloud Foundry
Enter the HANA Trail account using URL URL: http://hanatrial.ondemand.com/.
If you have not created the trial account for Cloud Foundry you would be asked to create the trail account
Create the account and then global account, sub account, organisation and space would be created.
Click on continue post creation.
Click on service entitlement section and cross check if SAP HANA schema and HDI Containers(Trial) has been enabled for your account.
Enable Web IDE for HANA Views
Login to SAP Cloud Platform HANA trial account with the URL: http://hanatrial.ondemand.com/
Now click on SAP Web IDE.
If you are entering for the first time then you will be asked to enable the SAP Web IDE Full Stack. where you can enable the same as in below image.
After the service is enabled when you enter SAP Web IDE you would see below screen.
In SAP Web IDE select Preferences -> Cloud Foundry and then select the Frankfurt API end point which starts with api.cf.eu10.. as the API End point and then choose Organisation and space of the trial account.
P.S: If you are located in the region which is more closer to other data centre, you would have the Cloud foundry trial account and end point accordingly. For example if its US then you need to choose US API end point accordingly.
Log out post Enablement and then Log in again to the SAP Web IDE.
Now the set up is ready to build the new HANA calculation views in SAP HANA 2.0.
In part 2 we will cover how to export the HANA content from SAP Marketing Cloud, build the calculation view and import back into the application using Add Custom View Application.
thanks for blog.. i am trying it in a productive tenant and not trial one.. cant see WEBIDE as service to be activated under service market place.. is there some pre-requisite for same?
You can check some of the tutorials that are available in below link.
Hello Latha B ,
FYI, I had to create an instance in order to be able to build the imported data (from part 2).
Via Trial subaccount -> spaces -> dev -> SAP HANA Cloud (none was running) -> Create Instance
Can you please add a step to create a HANA instance within trial (after Account setup, before Web IDE)?
Hi Sascha Tom Ulbrich & Latha B
I think I also first have to build an instance for SAP HANA, because in part 2 when trying to do the build I get the error message:
"Can not create service instance 'MKTMetadata-hdidb-SUserID-otherID': There is no database available. Ensure that you have a database available in space 'dev' within organization 'mytrialidtrial'"
But what do I have to choose to create an instance? Which plan should I choose and which details do I have to provide?
To resolve the error that you’re facing, please follow the steps:
Note: If you continue facing the same issue, consider deleting all the plans and try again.
Hi Halley Rozario,
thank you so much for your reply! Removing the hdi-shared plan worked and the build was now successful! 😀
Thanks so much for this valuable hint. I was also facing errors in the built task which were solved by removing the plan hdi-shared.
I did not have a Web IDE link. I had to go into subscriptions and enable it.
I created a hana instance.
I can't load the data from HM. It gives a permission error. I tried some of the suggestions from the comments, but didn't have any luck.
To resolve the error that you’re facing, please follow the steps to access the Web IDE.
Thanks, but the Neo environment is going away in 2 months. Am I missing something?
Hello Latha B
How long this approach with modelling in trial web ide will be supported?
Now, when creating trial account and accessing WebIDE i can see following message:
"On November 13, 2020 the SAP Cloud Platform, Neo trial environment will be discontinued and as a result SAP Web IDE Full-Stack trial will also be discontinued."
What will be the options from next SMC release?
please see blog post https://blogs.sap.com/2020/08/20/sap-web-ide-trial-update/. It states that you can use SAP Web IDE for SAP HANA development which is available on the SAP Cloud Platform multi-cloud trial environment. This temporary solution will be available until SAP HANA development tools are supported in SAP Business Application Studio.