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

Will Telerik Spreadsheet Support Data Binding from mysql

3 Answers 65 Views
Spreadsheet
This is a migrated thread and some comments may be shown as answers.
louis chan
Top achievements
Rank 1
Iron
louis chan asked on 16 Oct 2015, 05:13 AM
Will Telerik Spreadsheet support data binding for mysql, mssql etc?

3 Answers, 1 is accepted

Sort by
0
Bozhidar
Telerik team
answered on 16 Oct 2015, 08:13 AM
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
0
louis chan
Top achievements
Rank 1
Iron
answered on 03 Nov 2015, 12:59 AM
Thanks a lot !
0
Tomica
Top achievements
Rank 2
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!)

 

 

 

Tags
Spreadsheet
Asked by
louis chan
Top achievements
Rank 1
Iron
Answers by
Bozhidar
Telerik team
louis chan
Top achievements
Rank 1
Iron
Tomica
Top achievements
Rank 2
Share this question
or