Json example

Thread is closed for posting
2 posts, 0 answers
  1. Jigar
    Jigar avatar
    3 posts
    Member since:
    Sep 2015

    Posted 18 Sep 2015 Link to this post


    I am creating one hybrid mobile application and i want to fetch data from SQL server so can you give me any hint or demo example for that as soon as possible.


    Thank you


  2. Anton Dobrev
    Anton Dobrev avatar
    609 posts

    Posted 23 Sep 2015 Link to this post

    Hi Jigar,

    Based on the information you provided I am assuming that you have an existing SQL database and you would like to consume the data from it in your mobile app.
    You may want to consider 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, also available for Linux. After that you can quickly expose the database tables and stored procedures through HTTP endpoints. Consume the data from the endpoints from your client app using the JavaScript SDK of Backend Services or jQuery Ajax requests.

    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 these services with HTTP requests.

    Let me know if this helps.

    Anton Dobrev

    Visit the Telerik Verified Plugins Marketplace and get the custom Cordova plugin you need, already tweaked to work seamlessly with AppBuilder.

Back to Top