SAP HANA Multitenant Database Containers (MDC) scenarios now on trial landscape
The SAP HANA Multitenant Database Containers (MDC) feature enables hosting multiple SAP HANA databases on a single SAP HANA system. All tenant databases in the same system share the same system resources (memory and CPU cores) but each tenant database is fully isolated with its own database users, catalog, repository, persistence (data files and log files) and services. And now you can use all this on a trial landscape.
Note: You can have only one tenant database per account.
Create a tenant database on trial landscape
To be able to access a trial landscape, you need to have a developer account first. If you still need to create a developer account, you can start from here: Signing Up for a Developer Account.
To create and configure a trial tenant database, follow these steps:
- Log on to the SAP HANA Cloud Platform cockpit and select an account.
- Choose Persistence and then Databases & Schemas from the menu on the left. Choose New.
- In the Database ID enter a unique ID that contains lower-case letters and numbers.
- In the Database System field select the HANA MDC (<trial>) option. Fill in the SYSTEM User Password field. Choose Save.
The Events page is displayed. It shows the progress of the database creation.
- Wait until the tenant database is in state Started. It might take a while.
Note: If there are no free resources available you will not be able to create a tenant database. You should try again later.
Now you have your tenant database created and configured.
Web IDE scenario
In case you want to work with your tenant database from the Web IDE, you have to do an additional configuration after the tenant database is started:
- In the overview of the new tenant database, open the link SAP HANA Cockpit.
- Enter SYSTEM in the Username field and the password you have set in the Password field. When you choose Log On, an Information dialog appears. It says you are not authorized to open the SAP HANA Cockpit and you will be assigned the necessary role. Just choose OK and proceed. Another dialog appears. Choose Continue.
- The SAP HANA Cockpit opens for the new tenant database.
- Go back to the SAP HANA Cloud Platform cockpit and then go to the tenant database page in Databases & Schemas. Open the link SAP HANA Web-based Development Workbench.
- (Optional) Choose the Security option. Add all the roles described here: Roles Required for Web-based Tools. To assign the roles to the SYSTEM user, you have to:
- Go to Users and then SYSTEM.
- In the Granted Roles tab, choose Add.
- In the Search field enter the required roles and choose OK.
- Save the changes.
- To work with the Web IDE Editor, you need a database user first. Here you can find out how to create a database user with permissions for working with Web IDE: SAP HANA Cloud Platform
To open the Web IDE, you have to go to SAP HANA Web-based Development Workbench for this tenant database. Select the Editor option and now you have the Web IDE ready to work.
Eclipse IDE scenario
If you want to use Eclipse IDE to try out the tenant database on the trial landscape, you can use your own test application. This is what you have to do:
- Install the SAP HANA Tools in the Eclipse IDE. If you haven’t done this already, read this procedure: Installing SAP HANA Tools for Eclipse.
- If you want to import your test application delivery unit (DU), continue with the procedure.
- Go to Eclipse and open the SAP HANA Development perspective.
- In the System view, choose Add Cloud System.
- In the Account Information page, enter your developer account details. Choose Next.
- In the SAP HANA Schemas and Databases, enter the tenant database details you have set when you created it. Choose Finish.
- To import the DU, choose File and then Import.
- Expand SAP HANA Content and then choose Delivery Unit. Choose Next.
- The target system is your tenant database in the trial landscape. Choose Next.
- Browse to the YOUR_DU.tgz file you have downloaded in the File field and choose Finish.
When you create a tenant database, you can use it for 12 hours. After that it will be automatically shut down to free resources. You can start it again from the SAP HANA Cloud Platform Cockpit. Have in mind that if you don’t use this tenant database for 7 days it will be automatically deleted.
For more information, you can check out the Databases documentation and the Creating as SAP HANA Database from the Cockpit tutorial.
It is great to have access to full blown HANA instance for training purposes (and free). Thank you Katya for sharing this with us.
Some question were already asked in social media about AFL/PAL and "Script Server" switch that cannot be switched "ON" and is good to be known that AFL/PAL are runing in embedded mode so this switch can be left in "OFF" state!
Really happy to see this feature available for all now! Should make the HANA / XS experience soo much smoother ... great work team!
I get '403 Forbidden' error while opening 'Editor'
All the required roles are already there in 'development workbench:Security
Did i miss something?
Please refer to HANA Developer Guide for SPS10 (complete documentation as zip file for SPS10) for roles required for Web IDE. The role sap.hana.xs.ide.roles::Developer should grant you the required privileges.
Had the same issue but "sap.hana.xs.ide.roles::Developer" role has nailed it
Are you sure you've granted the roles to the correct user SYSTEM? I had a similar problem when I granted the correct roles to a different user.
When I open the link SAP HANA Web-based Development Workbench then only "I get this 403 Forbidden' error" how do I add the security roles.
you can open the SAP HANA Cockpit link and log on as SYSTEM. There will be two dialog boxes, one telling you that you don't have the necessary privileges yet to open the cockpit, but that you can proceed and that they will automatically granted to the SYSTEM user. The second informs you that the SYSTEM user now has the necessary privileges. After that you should see the SAP HANA Cockpit (not to be confused with the SAP HANA Cloud Platform Cockpit), where you can open the "Manager Roles and Users" tile to assign additional roles needed for the Web-based Development Workbench.
Very helpful post.
When I try to create a new MDC database with my Trial account after pressing Save it stays forever with the spinner and doesn't do anything for long time and at the end I get an "Internal error 500" message! Do you know what it could be?
It happened to me as well. Probably it is a central issue. Try again in a couple of hours.
Please follow HANA MDC (<trial>) : Impossible to create a Database (Connection lost), the solution will be posted there once available.
NOTE: Unless you are asking for clarification/correction of some part of the Blog or Document, please create a new Discussion marked as a Question. The Comments section of a Blog (or Document) is not the right vehicle for asking questions as the results are not easily searchable. Once your issue is solved, a Discussion with the solution (and marked with Correct Answer) makes the results visible to others experiencing a similar problem. If a Blog or Document is related, put in a link to it in the Discussion. Read the Getting Started documents (link at the top right of each SCN page) including The SCN Rules of Engagement.
When I attempted to add hana cloud system in Eclipse , I received an error
" Authorization Error- the execution was rejected".
Please advise on this error .
I have supplied below Account information in Eclipse for adding account :
Host : hanatrail.ondemand.com
Account Name : <p09xxxxtrail>
User Name : <p09xxxx>
Password : <pwd>
Host : hanatrial.ondemand.com
Account Name : <p09xxxxtrial>
User Name : <p09xxxx>
Password : <pwd>
There is a spelling mistake "trial" is the right term.
It works now . I overlooked on that spell 😛 . Thanks for the help
the HANA instance in Started
but to login Cockpit don't work because credentials!
SYSTEM: HANA MDC (<trail>) for Username???
is it right?
Are you trying to login to cockpit or Web IDE? For cockpit the username is same as that you used to login to https://account.hanatrial.ondemand.com/. For Web IDE, Web-based Development Workbench- Use the SYSTEM user Id and password that you created in step-4 of “creating a tenant database on trial landscape” section above . Once you log in with SYSTEM user go to security perspective and copy SYSTEM user Id and create a new UserName of your like.
Hi Ekaterina Mitova,
So the existing free trial HCP will be shutdown, and we will now have to "maintain" the HANA Instance every week?
The term you use is not correct, but I think I know what you have in mind,
The trial landscape on SAP HANA Cloud Platform will not be shut down!
The shared HANA XS on trial landscape is replaced by MDC database, that gives you more complete HANA experience, but for a limited time. The shared MDC database is switched off after 12 hours and is deleted, if you don't use it for 7 days.
So, now we will have to do something to keep it alive, right?
While now, we create a HANA Instance, and then we can leave it there - up and running.
Is this correct?
This is great. My first reaction was "what ? only 7 days ?". But as the previous hana xs limitations was quite frustrating, I must admit this is definitively an interesting compromise.
Just a question : access to Design Studio seems to be forbidden with the Web IDE workbench, is it an authorization issue or a trial limitation ?
I think this is just a missing role for the HANA user you are trying this with.
Please grant the role "sap.bc.ina.service.v2.userRole::INA_USER" to the HANA user and check if the error message goes away.
Right. This was it.
I can't access SAP HANA Cockpit and get Service Unavailable issue.
There were a recent planned upgrade of the trial landscape. I suggest you wait a bit and try again.
Hi Benny Mei. Have you tried the solution from http://scn.sap.com/thread/3858146 ?
Thanks a lot, it works now.
By the way, it seems this kind of issue only occurs when I use P* user, because it is always OK when I use my SAP internal account.
Hi Ekaterina and All,
I am getting Insufficient Authorization error when activating or Data preview the model of SHINE views and other views. Please help me how i can get the required Roles or Privileges. Screenshot attached. I can't even have access to Admin console to trace.
Unless you are asking for clarification/correction of some part of the Document, please create a new Discussion marked as a Question. The Comments section of a Blog (or Document) is not the right vehicle for asking questions as the results are not easily searchable. Once your issue is solved, a Discussion with the solution (and marked with Correct Answer) makes the results visible to others experiencing a similar problem. If a blog or document is related, put in a link. Read the Getting Started documents (link at the top right) including the Rules of Engagement.
NOTE: Getting the link is easy enough for both the author and Blog. Simply MouseOver the item, Right Click, and select Copy Shortcut. Paste it into your Discussion. You can also click on the url after pasting. Click on the A to expand the options and select T (on the right) to Auto-Title the url.
Thanks, Mike (Moderator)
SAP Technology RIG
Thanks Ekaterina for this blog.
May I request you to clarify my query on HANA trial account with MDC . Below is my thread
Unable to find Database Tables in Multitenent Database of trial account
I was able to perform Modeling with previous version but with the new version, I am not able to develop anything in Modeling. Please help,
I use Eclipse for HANA Modeling.
I do not find any DB tables in any of the Schema with new MDC database.Also I am not able to develop any information models. I raised this query in the forum Unable to find Database Tables in Multitenent Database of trial account
but couldn't get any response. Could you please check this?
Thank you for the details on how to setup the MDC on the trial account.
One question about the 7 days to delete the instance seems way too short to me. Is there any way to campaign to get this extended? I did think about opening an idea in Idea Place: Enterprise Home that maybe people could vote for. However the HCP does not seem represented or have an area that I can access. I always have issues with permissions on ideas.sap.com and for example I am not allowed to visit HANA platform section of that site.
It would be good to ask the relevant people for this 7 days to be extended, Do you know who I could contact and at least ask about extending the time period for deletion. Thank you.
I have no issues with 12 hours stop and maybe could live with the actual deletion of the instance although it does seem a step backwards to what the original trial allowed. The 7 days seems too short, if I go on holiday for over a week I have to logon to the system to start my HANA trial. Only an example it seems a shame that I have to remember to stop/start a trial system.
I appreciate SAP have a significant investment in the trial accounts and I really appreciate the access I have now. It is a fantastic platform and I love the variety of options that are available and a great training resource. So I can live with some restrictions but 7 days seems too short. Yes 7 days seems too short if I have not made my point yet 😉 . I have invested quite a bit of my time on the soon to be deleted old HANA XS trial platform. I found the document in time to archive my work on this system and while I have nothing productive it was only recently I found out about the removal of the old trial HANA platform. It would be a shame if it was deleted because I had access issues on day 7 or went on holiday for over a week.
Thanks for the MDC steps I am up and running and it seems way more options available to check out and learn more about the platform. However 7 day limit I am not sure how much time I will invest this time out. I will have to keep reminding myself to stop/start the instance. Maybe only invest short attempts to set things up and then have to repeat all those initial steps every time. I am testing out the email notifications at the moment I am getting emails about the system stopping, I assume I will get an email that it will be deleted. I will see how that goes first time around and see how it works out.
Also to state I do value your blog to get up and running with the MDC and if you do know who I could contact about the 7 day limit that would be great.
I am afraid that with the current resources we cannot keep the database for more than 7 days. However if you are aware that you are going into vacation you may export and import your data after that. You may try the following tutorial: SAP HANA Export and Import
Thanks for the reply and info, I was aware of the export / import. I have saved my data but that was just lucky timing as I have experience of losing data before in the SAP cloud. My portal site was removed before I saved my data from the site as per this comment
At the end of the day I do not have anything that I can't live without but happy this time I got my data out in time. Although it only makes sense to have the data on the HANA Cloud Platform. I got to know about the retirement of the HANA XS trial instances just recently and it did trigger the thought it would be good to have a longer period before any deletion from my past experience. Going through the export / import every time may make sense and I will have to just see how that goes but I doubt I will remember that every time. That's my problem now and how I use the site. Although I do see there are HANA Shared instances on an old SPS still, so a bit more reading about that for me.
I must state again, I am more than happy that I have free access and do appreciate the effort and input from SAP into the free trial.
As others have pointed out seven days is too short. Most of use are students learning the tool and the amount of data we store is trivial. The last Introduction to SAP HANA Cloud had less than 10,000 started and about 2500 who completed the course. Even if each had a meg of data we're looking at a database small enough to put on the memory stick. SAP saves nothing be clearing out tenants so quickly.
Having to log in a couple of times a week to avoid losing our work is a pain. I know SAP supply this for free but we too invest time into writing our models and if they are at risk we are less inclined to adopt this platform.
Is there any way to enable database traces? I can change trace levels in admin console, but when I press "Finish", I get an error " SAP DBTech JDBC: : general error: change not allowed for tenant database".
Thanks for sharing.It's a great help!
My Database is "creating" by 2 hours... could you tell me how can stop the process?
I am not able to run the following on any newly created schemas with the SYSTEM account. I created a new schema and a new user. I wanted to give the new user access to create objects in the schema but it is not allowing me to even though I am logged into as the SYSTEM user. Here is the command I am running:
‘select, create any, insert, delete, update, execute, alter, drop’,
I get the following error:
Error: (dberror) 258 - insufficient privilege: Can only grant privileges for objects owned by _SYS_REPO, not for NEWSCHEMA
Any feedback is appreciated. Thanks.
Are we able to develop NodeJS applications using the HANA Trial MDC trial account? I do not see an option to create NodeJS applications when I start my HANA Trial MDC instance and then open up the webIDE editor.
I am using SAP Cloud platform Cockpit and I keep getting "Login failed : wrong credentials." when I login as SYSTEM and the password I used to create the DB. The DB is started. I've tried everything and it will not let me log in to SAP HANA.
Thank you for information. Great help.
I have a specific scenario where I want to add my existing hana DB to Cloud platform in database Explorer.
According to online tutorials, when I go to Database Explorer and click + sign, I should get 3 options for Database Type i.e. "HDI Container", "SAP HANA Database (Multi-tenant)" & "SAP HANA Database".
However, when I go to my trial account web IDE and go to database explorer and try adding the system, I get Database Type "HDI Container" and "Application Managed Service Instance" only. There are no other option to add Multi-tenant Hana db. Can you help me with this issue? Am I missing on any settings?
Please let me know if anyone has an answer to this.