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?

score 1 · Answer 1 · edited May 23 '17 at 10:30

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.

edited May 23 '17 at 10:30

Community

1
1

answered Dec 19 '16 at 15:18

Théo Capdet

1,042
3
18
34

thanks a lot & i will try to create the jobs with mongodb component. – user3114967 Dec 20 '16 at 06:14
In my tMongoDBOutput have only 'use existing connection' option & it is empty in Basic setting. how to cofigure the connection manually? – user3114967 Dec 20 '16 at 06:21
You need to create two Db Connection (right click) in the metadata menu at the left of Talend – Théo Capdet Dec 20 '16 at 09:10

import Data from Excel to MongoDB in Talend

1 Answers1