Posts

Showing posts from March, 2014

Database connectivity with Google Sheets

Image
Overview I happened to be watching some Google I/O videos from 2013 last week and was watching some on apps-script, which I had never really used up until now. They mentioned about having JDBC connector so that you could connect to external data sources (Oracle, MySQL, SQL Server, etc). It's worth noting, there are 2 types scripts that can be container bound to a spreadsheet: 1. Add ons 2. Script gallery Script gallery is not supported in the new version of sheets, in favour of add-ons. There is a market place where you can search for and install add-ons, and if your organisation is using google apps, you can even restrict your add-on to your organisation. Unlike the script gallery where you could view the source, that is not the case for Add-ons (the code is not visible to end users). Excluding if you share the document with the development version of the code attached to the document. Add-ons are currently in developer preview, so whilst you can develop add-ons, only