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

Tue Oct 30 13:47:01 EDT 2012

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

Steven Hawkins commented on TEIID-1064:
---------------------------------------

This looks very good.  I've been doing a review and making some modifications along the way.  I have some proposed changes that we can first push to you or just get them into master and then make additional refinements.

- remove the getAsCsv procedure and just rely on the built-in textAgg against the appropriate source query selecting the columns, limit, and offset.  is there a reason to not use textAgg?
- add the translator/ra to the embedded kit
- use json instead of csv for results.  there is additional metadata available and the csv library can be removed.
- remove the use of the datatype metadata overrides.  the use of jaxb has been discouraged and with json metadata we have a better guess at the types.

Other considerations:
- allow the integration tests to be run in a specific profile (but they would probably need their own harness to setup the expected data)
- use JSONSimple for json processing to cut down on embedded kit size
- the GDataClientLoginAPI retry delay seems large, should it be configurable?  also won't retry only be needed on ServiceExceptions, shouldn't an IOException be immediately rethrown?

> 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
>            Assignee: Filip Nguyen
>             Fix For: 8.2
>
>
> 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
For more information on JIRA, see: http://www.atlassian.com/software/jira