Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Import and Export data to Google Docs spreadsheet from MSSQL

Posted on 2014-01-02
2
Medium Priority
?
9,352 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 60

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 Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

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

A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
This Micro Tutorial will demonstrate importing calendar invites from events such as webinars into your Google Calendar.
This Micro Tutorial demonstrates in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

722 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