[teiid-issues] [JBoss JIRA] (TEIID-2820) Support Couchbase as a resource

[Ramesh Reddy (JIRA)]

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

Ramesh Reddy commented on TEIID-2820:
-------------------------------------

Couchbase seems to be much similar to MongoDB in terms of their document storage, type of query language supported. That could be lot more work, in magnitude of multiple weeks, depending upon how deep we want to integrate. Luckily we can draw upon the ideas of MERGE, EMBEDDED from MongoDB. For simple 1 to 1 bucket/table without nesting should be little less time consuming IMO. Either case one need to get very familiar with their N1QL language.

INFER seems to be logical way to go about figuring out metadata. Otherwise you would need to write similar utility anyway. See Mongo, I had to do something similar. Good thing with Teiid is you can even avoid this for time being and define the schema at Teiid layer and develop mapping semantics to Couchbase, but would need the reverse at some point in the development.

Yes, we need to follow the methodology similar to Simba driver above from [3]. We could have used Simba drivers, but that does not look like Open Source drivers, and I did not find any others either. Depending upon the community interest Teiid can be of good play in providing Open Source driver IMO.  Also see [4]

I would also poke the Couchbase community for any interest in opsn source JDBC/ODBC driver for this? May be someone with experience can help with our effort?

[4] http://docs.couchbase.com/admin/admin/Views/views-translateSQL.html

> Support Couchbase as a resource
> -------------------------------
>
>                 Key: TEIID-2820
>                 URL: https://issues.jboss.org/browse/TEIID-2820
>             Project: Teiid
>          Issue Type: Feature Request
>          Components: Misc. Connectors
>            Reporter: Kim Palko
>            Assignee: Kylin Soong
>            Priority: Blocker
>              Labels: data_source
>             Fix For: 9.3
>
>
> Support Couchbase as a data source in Teiid.  This requires resource adapter and translater development



--
This message was sent by Atlassian JIRA
(v7.2.3#72005)