This is a migrated thread and some comments may be shown as answers.

Will Telerik Spreadsheet Support Data Binding from mysql

3 Answers 160 Views

Spreadsheet

This is a migrated thread and some comments may be shown as answers.

3 Answers, 1 is accepted

answered on 16 Oct 2015, 08:13 AM

Spreadsheet-Custom-Provider.zip

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

answered on 04 May 2016, 08:08 PM

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!)