Tagged: Talend Toggle Comment Threads | Keyboard Shortcuts

  • Joe Wichowski 1:22 pm on January 3, 2012 Permalink | Reply
    Tags: , Data Integration, , Talend   

    Talend Components for Lotus Notes released… 

    We have just released our Talend Components for Lotus Notes.  What is Talend?  It is an ETL (Extract, Transform, Load) tool, that allows us to perform better data integration than just utilizing tools like Lotus Domino Enterprise Connection Services (DECS).

    With Talend and our components for Lotus Notes, we are able to offer true integration to just about ANY system – cloud services, web services, Big Data, traditional databases, excel worksheets, and more.

    If you have a project that requires data integration, give us a call.  We’d love to explain how we can eliminate the “swivel chair” within your company.

    Download the components here:

    • tNotesInput – Reads data from a View (or @Function Select formula) and exposes as rows within Talend.
    • tNotesOutput – Write data to a database (Inserts and Updates)
    • tNotesRunAgent – Runs a background agent in Lotus Notes
  • Ian Leu 1:09 pm on January 31, 2011 Permalink | Reply
    Tags: , Talend   

    Working on enhancing an existing notes application for one of our customers.

    Part of this involves adding some fields to a data warehouse that we set up to sync notes with SQL server(using talend). This allows them to generate reports using SQL statements rather than setting up custom reports in the notes application. Setting up a data warehouse for notes data is a great way to simplify reporting.

  • Ian Leu 8:02 am on November 15, 2010 Permalink | Reply
    Tags: , , Talend   

    Recently had a project to move an old notes database to a read only ASP application. Using our custom Talend component to pull data from notes along with Ironspeed (the rapid development software for ASP) we were able to quickly and easily pull the data from notes and create an ASP application that allowed the customer to find all the old data they needed.

    With these tools, this is a process that can be replicated quite easily.

    • Juan Yip 7:16 pm on December 2, 2010 Permalink | Reply

      I’m new to Iron Speed and have been searching for a way to migrate notes to ASP. Do you have a quick ‘how to’ video or specs doc you can share? Feel free to email me, yip_juan@yahoo.com. Thanks!

      • Ian Leu 8:57 am on December 7, 2010 Permalink | Reply

        I don’t have any specific materials like that but I can tell you that to get started you just need to be able to get the data out of notes into something like SQL server. We use our own in house tools to accomplish that but any method is fine. You will need enough knowledge of notes to keep the referential integrity and rebuild the relationships in the new database. Given that notes isn’t inherently relational, you will need to use unique IDs, REF values for response documents, or built in key values(it will all depend on how the notes application was designed).

        Once you have the data exactly the way you want it with the relationships perfect, ironspeed can build the basic application for you easily, the rest is custom ASP code and UI tweaks to make the functionality mimic notes (in my case above, I was making a read only app for archive purposes, but anything is possible), there is some very helpful ironspeed documentation on how to get started with new applications on their website.

        Hope that helps!

Compose new post
Next post/Next comment
Previous post/Previous comment
Show/Hide comments
Go to top
Go to login
Show/Hide help
shift + esc
%d bloggers like this: