Migrate data from MongoDB to Postgresql

[Anonymous]

I need to move data from MongoDB to Postgresql ?

[Anonymous]

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 🙂

[Anonymous]

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

[Anonymous]

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 🙂

[Anonymous]

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?

[Anonymous]

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 🙂

[Anonymous]

I have no idea to proceed can you give brief explanation

[Anonymous]

Type mismatch: cannot convert from Object to String using tMap

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

[Anonymous]

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

[Anonymous]

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