ETL from RDBMS to MongoDB

One Star

ETL from RDBMS to MongoDB

Hi
I am new to the Talend products
We have a large relational history DB that has some reports on it
I want to configure a ETL process on top of this relational history DB (PostgresSQL) as a source when the target should be Mongo DB
Then I would like to enable reporting on the MongoDB database.
1) How can I start, which products I need for that
2) How should I configure the ETL ?
3) Should I need a MongoDB connector for that
Any information , samples , white papers etc. are highly appreciated.
Thanks
Eli
Moderator

Re: ETL from RDBMS to MongoDB

Hi,
We have a large relational history DB that has some reports on it
I want to configure a ETL process on top of this relational history DB (PostgresSQL) as a source when the target should be Mongo DB
Then I would like to enable reporting on the MongoDB database.

From your description, it seems that you have some reports for relational history and you want to extract the data from PostgresSQL to Mongo DB?
Component(connector)
tPostgresqlInput reads a database and extracts fields based on a query.
tMongoDBOutput inserts, updates, upserts or deletes documents in a Mongo database collection based on the incoming flow from the preceding component in the Job. (tMongoDBOutput is Bigdata component)
In addition, you should choose talend open studio for Bigdata big-data
The workflow should be:tPostgresqlInput-->tMongoDBOutput, please read the online component reference to study How to use these components.
Feel free post your issue on forum.
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.