topic Re: How to assign corresponding data types in tmongodboutput component Json tree in Talend Studio

How to assign corresponding data types in tmongodboutput component Json tree

krengan21 — Wed, 29 Aug 2018 15:18:39 GMT

Hi,

I have assigned data types for all the columns and after going to the advance tab of tmongodboutput component i am configuring the JSON Structure But after that in mongodb it is inserting all the data in string format other than the specified format .Please let me know what needs to be done for that or is that a bug ?

Thanks and Regards,

Kasthuri Rengan

Re: How to assign corresponding data types in tmongodboutput component Json tree

fdenis — Thu, 30 Aug 2018 08:29:26 GMT

MongoDB is document data base so it store only jsonString without type. type have to be managed by the software.
In Talend defined format are not used to convert data only for display data (it will be slow if Talend check or format all data for all links).
To solve it add tMap behind tMongodbOutput to format all your data as string.

Regards

Re: How to assign corresponding data types in tmongodboutput component Json tree

krengan21 — Thu, 30 Aug 2018 11:10:02 GMT

My problem is different and i have solved it !

Regards,

Kasthuri