1 Answer, 1 is accepted
Thank you for posting to the Telerik Developer forums. Based on the information you provided I am assuming that you have a MS SQL Server database and you would like to consume the data from it in your mobile app.
Yes, this is possible, and I can suggest a few approaches, either integrated in Telerik Platform, or that require additional development efforts on your end. To do this you will need to have a web services layer on top of the SQL database and consume the data through HTTP requests from the client app.
The integrated solution in Telerik Platform allows you to achieve this by installing a Data Connector in your infrastructure. After that you can quickly expose the database tables through HTTP endpoints. Consume the data from the endpoints from your client app using the JavaScript SDK of Backend Services.
Using this approach allows you to use web services with offline synchronization mechanism out-of-the-box.
The latest sample project of Backend Services is available in this repository. You can clone it directly in your Telerik Platform account by clicking on this link. More samples could be explored here.
You may also consider using the Telerik Data Access services wizard to quickly scaffold and build a web services layer on top of the SQL database, and deploy them to your own web server.
A third approach might be to build your web services with a technology like ASP.NET Web API (for .NET), or frameworks like Spring for Java.
When you have your web services layer ready, proceed with connecting the mobile app to them, for example, with Kendo UI DataSource that feeds Kendo UI mobile widgets. Demos for all widgets are available here. You can also work with this services with HTTP requests.
Regards,
Anton Dobrev
Telerik
Visit the Telerik Verified Plugins Marketplace and get the custom Cordova plugin you need, already tweaked to work seamlessly with AppBuilder.