migrate data from PostgreSql to Couchbase

One Star

migrate data from PostgreSql to Couchbase

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