I have talend and mongodb on two different servers and two different zones ( these timezones may change in future). I am trying to set context variable in taled to mongodb sysdate. I have tried few ways using tMongodbInput and tMongodbRow with new Date(), new ISODate() and $currentDate methods. But it is either a JSON parse exception or Bad Command. I am looking for mongodb query for select sysdate from dual. Is there any way to get sysdate like this in taled using mongodb
Can you please let me know TALEND VERSION?
is this 6.4.1 or 7.1.1 ?
there is some issue in 6.4.1 and 7.0.1 mongodb connector .
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema
Pick up some tips and tricks with Context Variables