Solved

Import and Export data to Google Docs spreadsheet from MSSQL

Posted on 2014-01-02
2
8,654 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 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

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

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

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
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.
Shows how to create a shortcut to site-search Experts Exchange using Google in the Chrome browser. This eliminates the need to type out site:experts-exchange.com whenever you want to search the site. Launch the Search Engine Menu: In chrome, via you…

623 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