Skip to Content
Author's profile photo Ekaterina Mitova

Show me some cities! Or how to use MDC tenant databases in several easy steps

I guess you’ve already heard that the Multitenant Database Containers (MDC) scenarios are now available on trial landscape. If not, here you can read more:SAP HANA Multitenant Database Containers (MDC) scenarios now on trial landscape

Anyway, to give it a try, you need to have a simple, or not so simple scenario. Something like a “Hello World” application, but a bit more sophisticated. And not too complex.

I have exactly what you need. Instead of a “Hello World” application, I am offering you the “Show me some cities” application.

/wp-content/uploads/2016/03/city_907693.jpg

What does this application do?

It shows how simple OData service is implemented. It can be used to fetch a single item or list all records – in this case several South African cities with their coordinates. It can further be enhanced by adding more cities or even you may use this service to show these cities on a map. It is all up to you.

Why do I need it?

It shows you how you can use the HANA database in a real and simple example. This scenario also can be run without any modifications on the trial MDC tenant database.

How to run the example?

  1. Clone the GIT repository: https://github.com/SAP/hana-cities.git
  2. Login to your HANA MDC database with the SYSTEM user.
  3. First open the SAP HANA Cockpit link.
  4. Then, open the SAP HANA Web-based Development Workbench link and choose Security.
  5. Create a new user: CITY_DEV.
  6. Assign the following roles to this user:
    • CONTENT_ADMIN
    • sap.hana.admin.roles::Administrator
    • sap.hana.xs.debugger::Debugger
    • sap.hana.xs.ide.roles::Developer
  7. Grant the GRANT_ACTIVATED_ROLE object privilege and then mark the checkbox Execute.
  8. Logout and login to SAP HANA Web-based Development Workbench with the CITY_DEV user and choose Editor.
  9. Create a new package – cities, and then inside create two more packages: data and services.
  10. From the local GIT repository folder, drag and drop the files that reside in the data and services directories to the packages in the Editor respectively.
  11. From the context menu of the cities package choose Create Application and then Activate All.
  12. Assign the cities.data::user role to the CITY_DEV user.
  13. Open OData Explorer for cities.xsodata.
  14. Et, voila! You have all the South African cities listed together with their coordinates.

Here you have the GitHub location of the cities application: https://github.com/SAP/hana-cities.

Stay tuned for more examples and blogs.

Assigned Tags

      4 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Omer Khan
      Omer Khan

      Hi Ekaterina

      where i can find more documentations about it?

      Author's profile photo Ekaterina Mitova
      Ekaterina Mitova
      Blog Post Author

      Hi,

      In the end of this blog there are links to the documentation: SAP HANA Multitenant Database Containers (MDC) scenarios now on trial landscape

      And stay tuned for more blogs and examples.

      Best regards,

      Ekaterina

      Author's profile photo Omer Khan
      Omer Khan

      Thanks Ekaterina

      I really appreciate your response.

      Author's profile photo Former Member
      Former Member

      hello

      I have a scenario where, i have to fetch the data from MDC tables which are assigned to the logged in user. DO you know how to design a solution for that?

      Regards

      Daren