topic Re: Unable to retrieve schema on mongodb in Talend Studio

Unable to retrieve schema on mongodb

Anonymous — Sat, 16 Nov 2024 09:49:04 GMT

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?

Re: Unable to retrieve schema on mongodb

Anonymous — Mon, 08 May 2017 07:42:36 GMT

Hi,

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.

Best regards

Sabrina

Re: Unable to retrieve schema on mongodb

Anonymous — Tue, 09 May 2017 16:16:42 GMT

I am on Talend 6.3.1 and Mongo 3.4.2

Re: Unable to retrieve schema on mongodb

Anonymous — Wed, 02 Aug 2017 15:16:55 GMT

Hi,

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

Re: Unable to retrieve schema on mongodb

Anonymous — Fri, 04 Aug 2017 06:24:35 GMT

Hello,

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?

Best regards

Sabrina

Re: Unable to retrieve schema on mongodb

Anonymous — Wed, 22 Aug 2018 22:42:48 GMT

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.

Re: Unable to retrieve schema on mongodb

Anonymous — Thu, 23 Aug 2018 04:46:13 GMT

Hi AlokGarg

According to this documentation, the MongoDB 3.4 is supported on Talend Open Studio for Big Data 7.0.
https://help.talend.com/reader/f7Em9WV_cPm2RRywucSN0Q/dK2FwwJ~yPCR9kWwKWpwxQ.
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.

Regards
Shong

Re: Unable to retrieve schema on mongodb

Anonymous — Thu, 23 Aug 2018 12:33:40 GMT

sorry mate, It was POC I did like a year ago and I didn't touch Talend or
MongoDB since...

Re: Unable to retrieve schema on mongodb

Anonymous — Thu, 23 Aug 2018 18:51:57 GMT

@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.

Alok

Mongo_snapshot.JPG
Talend Screenshot.JPG