topic How to extract data from the couchbase into mysql. in Talend Studio

How to extract data from the couchbase into mysql.

Anonymous — Sat, 16 Nov 2024 07:19:45 GMT

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 — Fri, 09 Nov 2018 14:08:38 GMT

Hello,

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

Anonymous — Mon, 12 Nov 2018 04:48:22 GMT

please find the attachment for the couchbase input.

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

Anonymous — Wed, 28 Nov 2018 12:51:25 GMT

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 — Tue, 09 Jul 2019 08:07:13 GMT

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.