Talend tNotesInput Connector Instructions:

Please Note:  If you don’t really “know” Lotus Notes, then these components probably won’t help you much.  Notes doesn’t work like traditional SQL databases (it is more of a NoSQL type database).  As such, you may need help.  Support, maintenance, and training packages are available for our components.  Please contact us for additional information:  Traction Consulting Group – Contact Information

Download The Components:

  1. Download them from Talend Exchange

Initial Setup:

  1. Install our components in a new directory under your Talend directory.
  2. In Windows -> Preferences -> Talend -> Components, change the User Component path to your extracted path.
  3. For tNotesInput to work, you need to load the Notes.jar library.  This file is available from either the Client or the Server.  So, your first component in your job should be tLibraryLoad, which will declare Notes.jar

Configuring tNotesInput:

  1. DIIOP – Allows you to bypass the local Client and instead execute remote instructions to the server.  Minimizes the footprint on the client, but slows down processing.  This option is necessary if you are working in 64bit client environments.
    • Set the iNotes user id and password if you use DIIOP.  Also, specify your server address for the DIIOP port.
    • Use the local client Password (current .ID file) if you do not use DIIOP
  2. Domino Server & File/Path Name – Server can be local (leave as “”), or enter the server name here.  File/Path should use forward slashes (like in the example)
  3. ViewName – The name of the view you will “read”.  Alternatively, you can select the @Formula checkbox.  When checked, you can specify a Lotus Notes Select formula instead of a view (return a NotesDocumentCollection).
  4. ReverseIndex – Read from the bottom of the View (or Collection) instead of the top.
  5. # Docs To Return – Leave ALL if you want all docs in the view.  Otherwise, specify the limit (integer).
  6. Schema:  The schema needs to be declared (since every notes entity can have unlimited fields).  To do so, please review the following picture.  IT shows an example schema for an Email message in Notes.  Note how you can override Field names (Db Column) with an @Function formula placed in the Comment box.

Additional Support:

  1.  You can purchase a support, maintenance, and training package for your company.  This is the best way to fully utilize the components, and ensure your production environment is supported.  Please contact us for additional information:  Traction CG