Hi
By request from @carbone I'm posting this summary of how I connected to a MongoDB for extracting data.
1) Downloaded the components from TalendForge web:
http://www.talendforge.org/exchange/?eid=286
(Components are not availble through the in-app TalendForge Exchange)
2) Extracted the files and put each of the component's folders in:
/plugins/org.talend.designer.components.localprovider_4.2.3.r67267
3) I also made a copy of mongo-1.3.jar from the component's folders an put it in:
%TalendInstallationPath%\lib\java (Thanks Pedro!)
4) Restart ToS.
5) Then I set up the test job with a tMongoDBConnection-component first, with
- URL to server (within quotation marks)
- Name of the database (within quotation marks)
- Port (without quotation marks!)
6) Next I pulled in the tMongoDBInput-component and connected it to the Connection-component with a OnComponentOK-connection.
7) In the basic settings of tMongoDBInput-component I,
- checked: "Use Existing Connection", and choose the tMongoDBConnection from drop list
- entered name of the collection i wanted to query (within quotation marks)
- Left query empty to get what ever
- and set a limit to not get drowned with data
😎 And set up the Schema (Edit Schema) of the tMongoDBInput-component, where each column is the keys of the key-value-pairs of the chosen mongodb collection.
9) Then, for testing, I connected the input component to a tLogRow, and ran it.
Cheers & good luck,
/Geuder
