ETL from RDBMS to MongoDB

[Anonymous]

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

[Anonymous · Accepted solution]

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