topic Re: How to get mongodb sysdate in talend using mongodb connector in Talend Studio

How to get mongodb sysdate in talend using mongodb connector

Anonymous — Sun, 23 Dec 2018 02:48:31 GMT

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

Re: How to get mongodb sysdate in talend using mongodb connector

Anonymous — Sun, 23 Dec 2018 13:56:08 GMT

Try with Date() or new Date() functions

Re: How to get mongodb sysdate in talend using mongodb connector

Anonymous — Sun, 23 Dec 2018 17:00:59 GMT

Thank you for suggestion. As mentioned in my question description i have tried these two methods, but it is throwing an exception. I appreciate if you can share any screenshot if you have tried/implemented.

Re: How to get mongodb sysdate in talend using mongodb connector

Chandru — Mon, 24 Dec 2018 03:06:31 GMT

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 .

Thanks

Chandru

Re: How to get mongodb sysdate in talend using mongodb connector

Anonymous — Mon, 24 Dec 2018 18:12:18 GMT

I am using talend 7.1.1 with mongo db 3.2.x