Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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

 

Labels (3)
0 Replies