Solved

Import and Export data to Google Docs spreadsheet from MSSQL

Posted on 2014-01-02
2
6,552 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 59

Accepted Solution

by:
Kevin Cross earned 500 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

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

Whether you’re looking to gather data for research or gather feedback on an idea, being able to build and distribute your own online survey is not only cost-effective, but allows you to reach a larger audience and receive results in real-time. Googl…
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
This Micro Tutorial will demonstrate importing calendar invites from events such as webinars into your Google Calendar.
This Micro Tutorial demonstrates in Google Analytics how to create a custom report that shows you traffic over time using the month of year dimensions. There are also instructions on how to fix Google's odd month of year formatting, which Microsoft …

708 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now