Mobile Back-End Tools¶
The Mobile Back-End Tools (MBT) is a set of tools that enable a developer to model an OData service and generate a Java EE web application to implement the OData service, along with automatic creation of the necessary database tables within a preexisting database schema.
A developer defines the model by providing an OData CSDL (Common Schema Definition Language) XML file for version 2.0 or 4.0 of the OData specification. A CSDL graphical modeling tool is also available to help create a model or modify an existing model.
To store OData entity sets, the generated OData service uses an in-memory database or SQL database. Use an in-memory database (for testing only) or use a SQL database that's available in SAP Cloud Platform (e.g. SAP HANA) or from a hyperscaler (e.g. Azure SQL, PostgreSQL).
A number of other database products are supported, primarily for delta-enabling existing on-premise
SQL database back-ends to enable offline consumption. See Cache Databases
-bind option for more details.
Except for the in-memory database, installing, creating, and configuring SQL databases and schemas is outside the scope of these instructions. See the SAP Cloud Platform Cockpit documentation set for additional information.
The generated OData service, when first started, automatically generates the tables and other SQL artifacts within your selected target database or schema. The configured database credentials must therefore be for a database user with suitable permissions for table/index creation.
Please take note that HDI container based HANA databases do not have suitable permissions for dynamic table/index creation. Since the HANA database available on SAP trial landscapes is based on an HDI container, this is not a supported scenario.
Tools are also provided to model and generate an OData service that exposes existing database tables, with or without OData change tracking. See Working with Existing Database Tables.
There are a number of ways that you can use the Mobile Back-End Tools to develop an OData service.
With the Mobile Back-End Generator plugin for SAP Web IDE Full-Stack.
The plugin includes a graphical CSDL editor, which is not currently available in any of the other environments.
Once the graphical CSDL editor feature becomes available in SAP Business Application Studio, the plugin will be retired.
With the Visual Studio Code Extension.