Will Telerik Spreadsheet Support Data Binding from mysql

4 posts, 0 answers
  1. louis chan
    louis chan avatar
    50 posts
    Member since:
    Feb 2010

    Posted 16 Oct 2015 Link to this post

    Will Telerik Spreadsheet support data binding for mysql, mssql etc?
  2. Bozhidar
    Admin
    Bozhidar avatar
    1102 posts

    Posted 16 Oct 2015 Link to this post

    Hi,

    Currently we don't have plans to include an out of the box solution for binding to databases, due to the difference in formats. What you can do however is implement a custom provider, which will provide the interface between the spreadsheet and sql database. I've attached a sample DataBaseProvider, which you can use, and extend to your convenience.

    Regards,
    Bozhidar
    Telerik
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
  3. UI for ASP.NET Ajax is Ready for VS 2017
  4. louis chan
    louis chan avatar
    50 posts
    Member since:
    Feb 2010

    Posted 02 Nov 2015 in reply to Bozhidar Link to this post

    Thanks a lot !
  5. Tomica
    Tomica avatar
    147 posts
    Member since:
    Apr 2008

    Posted 04 May in reply to Bozhidar Link to this post

    I find the proposed solution to be very applicable to a current client project. Please share any thoughts on how I might refine our technical approach. All work will be done in VS2015 with latest AJAX UI (web forms or Azure web apps) talking to Azure SQL DB.

    Current process: (1) obtain client data in Excel CSV format, (2) stage to Access 2016, (3) map incoming fields to standard DW schema, (4) run append query against ODBC link to the table in Azure, pushing local staging table to cloud, (5) do BI stuff

    Future process:

    (1) obtain client date in Excel CSV format

    (2) use Upload control to copy file into Azure Blob Storage

    (3) read XLS file row by row, re-map according to DW business logic, followed by SQL insert, i.e. using slightly modified code from sample DataBaseProvider (a great learning example!)

     

     

     

Back to Top