Happy #APIFriday all! I was at the airport a couple of weeks ago when the weather went crazy and the chances your flight was actually going to take off was dropping with the sun. After getting on a plane then being kicked off and spending 16 hours traveling to get from San Francisco to Chicago, I thought it would be nice to talk about systems working in harmony OData Service.

Select Service URL from the Sources list. Select your HANA DB OData service from the list and enter the relative path. It might just be a / or it be a longer path. When you click Test, you should see your HANA DB table(s).

Go ahead and click Next and Finish.

This will create a new data source in your dataSources array in your manifest.json file. Take a look at your manifest.json file and verify the new Data Source is there. Also note there is a new metadata.xml file in the local service folder. The OData service created a metadata.xml file so you can test locally and against the live service.

To use this new data source in our view, we need to also create a model in our manifest.json file. You can do this by adding some code to the models array or by using the description editor to visually define a new model. The model can be your default model (if you do not already have one defined) or it can be named. The data source should be the new data source you just added to your application. Mine is called KeggieData. Make these changes and Save your changes.

We can now use our OData model in our view! In your view file, let’s add a table to display data from one of our tables. In the table, we can define the items aggregate as the model and specific table we want from the database. In my example, I want to display the temperature data, so I use model keggieData and go to the temperature table. Add some s to the of the table to define the column headers. Once all the are defined, create the template. For each item in the "items" aggregate, one will be created. I only have 2 columns, so I need 2 controls in my cells. In the cell control, we define the data to be bound to the row. In my example, I want one column to show the timestamp and another to show the temperature at that time in Celsius. Save your changes.

Make sure all your changes are saved and RUN your application. You will see a table in your UI with data from your selected table in your HANA DB.

That was easy, right?

Life is so much easier when everything works in harmony. Hope this makes it simpler to integrate your OData service in your UI5 app

，云服务器服务商，淘客系统开发，云免费，智能工厂解决方案，免费网站自助建站