migrate data from PostgreSql to Couchbase

Anonymous — Thu, 12 Apr 2018 14:39:56 GMT

Hi,

someone can help e to create job to migrate data Postgresql to couchbase

My Job : TPostgreSqlInput=>tWriteJSONField=>tCoubaseOutput

my problem is that json content of tWriteJsonFiled is stored in couchbase a value of my json file :

{

"srv_id" : 1,

"json": "[{\"db_name\":\"NKO000S\"},{\"db_name\":\"GSE000V\"},.......

}

i can't structure my json like :.

{

"srv_id" : 1,

"db_name":["NKO000S","GSE000V",.......]

}

in input i have 2 tables serveurs (list of serveur) and databases (liste of database) with relation 1 ot n

i whant to generateone entry by serveur in couchbase with and json file with serveur attributes and databases list.

TALEND Version 6.5.1

Couchbase Version 5.0.1

Thank's

topic migrate data from PostgreSql to Couchbase in Talend Studio