topic Re: Migrate data from MongoDB to Postgresql in Talend Studio

Migrate data from MongoDB to Postgresql

Anonymous — Sat, 16 Nov 2024 06:35:51 GMT

I need to move data from MongoDB to Postgresql ?

Re: Migrate data from MongoDB to Postgresql

Anonymous — Thu, 14 Feb 2019 07:14:45 GMT

Hi,

Did you try tMongoDBInput to extract the data and tPostgresqlOutput to write the data? The links for these components are as shown below.

https://help.talend.com/reader/KxVIhxtXBBFymmkkWJ~O4Q/fo4hMI0RDFj9ItYxXniDIA

https://help.talend.com/reader/NNO~fmVQU4rlkF9Depfdxw/7~Omg_wYV8i0ANNFrIORzw

If you need to do any transformation, you will have to use tMap or any other related components according to your use case.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Re: Migrate data from MongoDB to Postgresql

Anonymous — Thu, 14 Feb 2019 07:24:04 GMT

migrate entire database in single shot. the database as multiple collections i need to do it in single shot

Re: Migrate data from MongoDB to Postgresql

Anonymous — Thu, 14 Feb 2019 07:30:02 GMT

Hi Akash,

Talend do not have the capability to perform database import and export as it is essentially an ETL tool. So you will have to plan in an iterative fashion for each input set from MongoDB.

Below are the list of components available in Talend for MongoDB. The above help document link will lead you to the links of other components also.

But there is no one shot solution to migrate the entire DB to Postgresql.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Re: Migrate data from MongoDB to Postgresql

Anonymous — Thu, 14 Feb 2019 08:02:01 GMT

I need to map from one collection to another collection

eg:

{
"_id" : ObjectId("5b22508e59d7d42e2fce9a1a"),
"messagedate" : ISODate("2018-06-14T11:25:02.562Z"),
"refvalue" : ObjectId("5b22508e59d7d25g2sdf651"),

}

refvalue is pointing to another collection. how to do?

Re: Migrate data from MongoDB to Postgresql

Anonymous — Thu, 14 Feb 2019 09:36:00 GMT

Hi,

Did you try parsing the first collection and then take the value as iteration to get the reference collection?

I don't have a MongoDB envt handy with me. So you may have to try and show the results if you are getting any error.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Re: Migrate data from MongoDB to Postgresql

Anonymous — Fri, 15 Feb 2019 07:42:11 GMT

I have no idea to proceed can you give brief explanation

Re: Migrate data from MongoDB to Postgresql

Anonymous — Fri, 15 Feb 2019 13:09:19 GMT

Type mismatch: cannot convert from Object to String using tMap

Screenshot (7).png
Screenshot (8).png

Re: Migrate data from MongoDB to Postgresql

Anonymous — Thu, 13 Jun 2019 09:13:53 GMT

Can we shift entire mongodb table to postgres ?

Its showing some error.

You can see in the screenshot I have attached , we are able to shift data for only hub_id , but when we keep the query empty it shows an error ,

Can you provide any link which provides guidance for this.

Its urgent can you reply as soon as possible to khushboo.priya@everlytics.io

Re: Migrate data from MongoDB to Postgresql

Anonymous — Thu, 13 Jun 2019 09:14:22 GMT

Can we shift entire mongodb table to postgres ?

Its showing some error.

You can see in the screenshot I have attached , we are able to shift data for only hub_id , but when we keep the query empty it shows an error ,

Can you provide any link which provides guidance for this.

Its urgent can you reply as soon as possible to khushboo.priya@everlytics.io

Screenshot from 2019-06-13 13-38-54.png