[
https://issues.jboss.org/browse/TEIID-1064?page=com.atlassian.jira.plugin...
]
Filip Nguyen commented on TEIID-1064:
-------------------------------------
There are basically 2 ways to implement this. Either using older GData java-library [1]
(note this library is being migrated to newer API [4], migration not yet done) that
implements Google Spreadsheet API [2] or using Google Visualization Data Protocol [3]. We
can offer the best user experience with implementing [3] because many constructs can be
pushed down with it as it supports sort of a query language [5].
For broader Google services integration, the best option in many cases is to implement new
API [4]. We believe this is not true in the case of Spreadsheet service.New Spreadsheet
API probably still won't feature Query language.
[1]
http://code.google.com/p/gdata-java-client/
[2]
https://developers.google.com/google-apps/spreadsheets/
[3]
https://developers.google.com/chart/interactive/docs/dev/implementing_dat...
[4]
http://code.google.com/p/google-api-java-client/
[5]
https://developers.google.com/chart/interactive/docs/querylanguage
Create connector for Google Spreadsheets.
-----------------------------------------
Key: TEIID-1064
URL:
https://issues.jboss.org/browse/TEIID-1064
Project: Teiid
Issue Type: Feature Request
Components: Misc. Connectors
Affects Versions: 7.1
Reporter: John Doyle
Fix For: Open To Community
Connectivity to Google spreadsheets for Teiid was identified as a desirable feature.
I've hacked together a little prototype code that can access Google Spreadsheets
through the Table feed.
http://code.google.com/apis/spreadsheets/data/3.0/developers_guide_java.h...
I envision the connector as driven by a text file for it's metadata just like the
Text connector is. I imagine it would be possible to create some tooling that could
define a model from the same text file, but that is out of the scope of this Jira.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see:
http://www.atlassian.com/software/jira