SAP API Management & HANA XS - Part I

In this blog series, I will develop a complete API scenario step by step. For this, I will use SAP API Management for the API and SAP HANA XS with HANA DB for the underlying data management. This series will come in multiple parts so that the components remain clear and structured.

In our scenario, we want to model a database in which companies can be stored. These companies have one or more locations. In our case, a location can be either a gas station or a shopping center. For each location, we store the address and opening hours. This data should be accessible via an API so that it could subsequently be displayed on a visual interface.

This blog series will only allow read access to the data, however we will structure the project in a way so that it can be expanded in the future.

• Part 2 - HANA Database:
  In this part, we model the database as the foundation for the scenario. For this, we use a HANA database on the SAP Cloud Platform.
• Part 3 - HANA XS - oData Services:
  In this part, we wrap an XS OData service around the database, which gives us easy access to the data.
• Part 4 - API Management:
  In this part, we develop an API with SAP API Management for the stored data. We use the API Designer to specify the different routes for the API using the new OpenAPI standard.

For this blog series, I used the trial account for the SAP Cloud Platform. In the following articles, I will replace the SCP account ID with pXXXXXXXXXXtrial.