import Data from Excel to MongoDB in Talend

Question

I'm using Talend ESB tool.Is it possible to copy data from "excel to mongodb" and "MySQL to mongodb" ? If it is yes, how to create the jobs? OR else any other way to achieve this?

Answer 1

If you don't have you need to import MongoDB component in Talend.

Tutorial to Import : Here

After you need a job that do :

tFileInputExcel -> tMap -> TMongoDBOutput

And a second :

tMySQLInput -> tMap -> TMongoDBOutput

You need to configure MySQL parameter and TmongoDB parameter in order to have a successful connection.