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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
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