How to extract data from the couchbase into mysql.

[Anonymous]

Hi,

Could you please help me, how to extract data from the couchbase DB into mysqldb.

couchbase version is 5.5 and TOS BD 7.0 am using it.

am getting an error while doing like following

couchbaseInput-->textracjson-->mysql

as couchbase input component contains the default schema..event,partition,key,...content.

the data is in content. feild which of Byte[] type.

how to extract the field from the couchbase.

Any suggestion is appreciated.

[Anonymous]

Hello,

Could you show us a picture of the component couchbase input, it will be better to see where's your error

[Anonymous]

Hi

please find the attachment for the couchbase input.

please let me know how to get the fields which are convenient for mapping.

couchbaseiput1.png

[Anonymous]

Hello @kolen,

You can transform byte[] into String using tMap with mapping 

new String(row.content)

Seems not so elegant but might be as a workaround.

[Anonymous]

hi Bitler,

Thank  you for the approach.

I tried the below approach, it could fetch the data. Actual  issuse is, am unable to read the complete bucket from the couchbase.

the couchbase version  is 7.2.

the job gets struct by reading no data after reads some records ...we are forcefully killing  the job.

i am not understand what might be the issue.Is that with talend or jars that are not supporting couchbase version.

Don't know.

please suggest any possible case that works.

Thanks in advance.