Is this possible?

2 posts, 0 answers
  1. Magnus
    Magnus avatar
    1 posts
    Member since:
    Jun 2015

    Posted 29 Jun 2015 Link to this post

    I will try to build an app for Android an ios. We do not have a website and we will store data in mssql can we add and get data direct from the app? Also is it Appbuilder i need to do this? I know c# but it is the first app i will try to Build. 
  2. Anton Dobrev
    Anton Dobrev avatar
    529 posts

    Posted 02 Jul 2015 Link to this post

    Hi Magnus,

    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.

    Let me know if you have further questions.

    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