[teiid-issues] [JBoss JIRA] (TEIID-1064) Create connector for Google Spreadsheets.

[Filip Nguyen (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-1064?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12712626#comment-12712626 ] 

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_data_source
[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.html#TableFeeds
> 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