I made a local copy of my live development environment to test Talend as an ETL tool for Mongodb->Mysql. It's been several years since I last used Talend but everything seems to be generally the same. I followed the instructions from this article https://help.talend.com/pages/viewpage.action?pageId=251330705 but when I right click to retrieve schema, i get nothing. It's blank. All my connections test as valid, and everything is localhost so I don't think there's a connection issue. My mongodb localhost replication is running fine, I can query it locally with no issue. What could I be missing?
Could you please indicate which talend build version you are using? What's Mongo DB version you are using? More information will be helpful for us to address your issue.
I'm facing the same issue with mongodb 3.4.
I managed to create the schema manually and it worked, but I really don't want to do this for each collection in our db.
I've read that talend supports mongodb up to version 3.2, but is there any future plans to support 3.4 and if so, any idea when it will happen?
a side note: we currently checking talend as the ETL tool for our project and the support of mongodb 3.4 is essential for us
Could you please take a look at this document about TalendHelpCenter: Supported systems, databases and business applications by Talend components for 6.3.
Is it OK with you when use V 6.4?
I am looking to read data from MongoDB 3.4 from Talend Open Studio for Big Data 7.0, but in the tMongoDBInput component I do not see MongoDB 3.4, but 3.5 is there, could you please confirm if this would work, if yes, how could I check the connectivity.
According to this documentation, the MongoDB 3.4 is supported on Talend Open Studio for Big Data 7.0.
In Repository, create a Nosql connection under Metadata, select DB type as MongoDB and version '3.5' and check if the connection is successful or not.
@shong Thank you so much for your reply, I could able to create successful connection, but when I am trying to write data from Mongo to csv, the data is not being copied, Job is running successfully, but no data is being copied, I am attaching the screenshot of the job I have created, also I am attaching the screenshot of my mongo DB structure if that is helpful to make adjustment in Mapping in Talend.
Thanks in advance.