[teiid-issues] [JBoss JIRA] (TEIID-1070) Create Amazon SimpleDB Connector

[Radim Hopp (JIRA)]

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

Radim Hopp commented on TEIID-1070:
-----------------------------------

Hi,
My implementation uses java aws sdk (http://aws.amazon.com/sdkforjava/). 
Basic CRUD operations should be working and multivalued attributes are supported (in format {{[<value>;<value>;<value>]}})
As all data in SimpleDB are stored as strings, everything is in this application treated as strings also. End user (app developer) is supposed to make sure all data will be treated accordingly (they can follow for example http://docs.aws.amazon.com/AmazonSimpleDB/latest/DeveloperGuide/NumericalData.html)
Questions and suggestions to improving are  welcomed.
                
> Create Amazon SimpleDB Connector 
> ---------------------------------
>
>                 Key: TEIID-1070
>                 URL: https://issues.jboss.org/browse/TEIID-1070
>             Project: Teiid
>          Issue Type: Feature Request
>          Components: Misc. Connectors
>            Reporter: John Doyle
>            Assignee: Radim Hopp
>             Fix For: 8.7
>
>
> We need connectivity to Amazon SimpleDB.  This should be accomplished through a dedicated connector.
> Simple DB presents a few challenges as a Teiid source as it is more like a spreadsheet than a database.  Simple DB "Domains' are like individual worksheets and contain any number of items.  Items however can have any number of attributes, and the attributes do not have to be the same for ever item.  So in a single Domain you can have an item with the attributes Size and Color, and another item with the attributes Color and ExpirationDate.  This presents both modeling issues and SQL execution issues.  None of them are insurmountable, but users will have to understand the issues and design their integration around them. 

--
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