Let’s deep dive and see how easy it is to integrate data from MySQL database with a UI5 application. Below data is available in a MySQL instance,
We will create a simple UI5 application and try to display the data in a table using the sap.m.Table control.
We have now created a simple XML view using the sap.m.Table control and bound the items aggregation to a JSON model. The JSON model is sourced via API call to fetch data from MySQL database.
This is just a demonstration to showcase the capabilities of UI5 and its seamless integration with external data. The same approach can be leveraged to integrate data from Oracle,MSSQL etc where consumption/creation of OData services is not a feasible option.