Skip to Content
Author's profile photo Waldemar Schakiel

Howto create data model for SAP Web IDE Mock Data Server

In most cases, a oData service is available when creating an SAPUI5 application. For times when a oData service is not available, it is possible to build apps with SAP Web IDE with a file-based data model (EDMX-file) and then run on simulated data (Mock Data Server in SAP Web IDE).

Once the data service is available, the app can then be configured to run against the live service rather than the mock data with no other changes. The mock data approach is also useful if you want to prototype an app and have realistic data appear in the UI.

A metadata document (EDMX-file) is defined in the Common Schema Definition Language (CSDL)

Related link

Typical construction of a EDMX-file:


This sample illustrates a simple relation between employees and skills.



XML declaration

Not necessary for .edmx files, but useful to include if you want to view the file in an editor that supports XML syntax highlighting

Edmx and DataServiceselements

The “wrapper” for your data model


Container for the EntityTypes, Associations and EntityContainer elements

EntityType 1

Employee collection

EntityType 2

Skill collection


Defines the nature of the connection between the two collections (employee and skills)


Exposes the OData collection

Complete sample EDMX-file

The completed model can now be imported into a SAP Web IDE project. During working on your model you can take advantage of the oData Model Editor (which is a plug-in to SAP Web IDE). To enable it, select Tools > Preferences in Web IDE, click on Plugins, locate the OData Model Editor plugin, click the slider to “on”, then Save and Web IDE will reload.

Assigned Tags

      Be the first to leave a comment
      You must be Logged on to comment or reply to a post.