?
Solved

Import and Export data to Google Docs spreadsheet from MSSQL

Posted on 2014-01-02
2
Medium Priority
?
10,317 Views
Last Modified: 2014-11-12
Hi
I'd like to create a Google docs script which would import data from a Microsoft SQL database.
I'd also like to create a Google docs script which would write from my Google docs spreadsheet back to MSSQL.
Has anyone done this or seen example code?
Thank you.
0
Comment
Question by:JEClark
2 Comments
 
LVL 61

Accepted Solution

by:
Kevin Cross earned 2000 total points
ID: 39751433
Are you looking for something like this?
https://developers.google.com/drive/examples/dotnet#requests_to_the_files_service

If you just want the integration without coding it yourself, you can look into paid products, such as https://zapier.com/app/pricing that also offers a free version.  I have not used it myself, but suspect they have just written the code using above API.

Per the Google forums, you also can use the Secure Data Connector with premium/education editions of Google Docs - https://developers.google.com/secure-data-connector/.  The site says it is a deprecated tool but is available through April 2015; however, it does not list the replacement.  I suspect code integration using Java/JDBC or other languages on the Google Drive API link above can handle it moving forward, though.
0
 

Author Comment

by:JEClark
ID: 39762598
Thank you for the suggestions.

As you pointed pointed out, the Secure Data Connector is deprecated.  

I had looked at Zapier, bt want something I can control more granularly,

The Google example looks intriguing, but appears to be m ore directed to reading and writing from data that already exists on Google drive.

I think I will need to use JDBC as outlined on this link.  https://developers.google.com/apps-script/guides/jdbc

Thank you for the excellent suggestion
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Windocks is an independent port of Docker's open source to Windows.   This article introduces the use of SQL Server in containers, with integrated support of SQL Server database cloning.
Microsoft provides a rich set of technologies for High Availability and Disaster Recovery solutions.
This Micro Tutorial will demonstrate how marketers can use the Mobile Emulation Tool in Chrome Developer Tool. This will let you preview your site on any mobile device.
This Micro Tutorial demonstrates how to quickly find related content for YourTango's posts using MozBar Chrome extension.

621 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question