• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 11084
  • Last Modified:

Import and Export data to Google Docs spreadsheet from MSSQL

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
JEClark
Asked:
JEClark
1 Solution
 
Kevin CrossChief Technology OfficerCommented:
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
 
JEClarkAuthor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Tackle projects and never again get stuck behind a technical roadblock.
Join Now