Talend Open Studio for Data Integration is an Eclipsed-based Java code generator that allows you to create ETL (extract/transform/load) jobs. It does this primarily through a visual programming editor employing a wide assortment of components to connect to databases, files, and applications. However, it can be extended by injecting Java or Groovy code where needed, or by developing custom components in Java. In essence, it's a Swiss Army knife for your data.
In this introductory talk I will cover what TOS DI is capable of, best practices, and give a live demo showing you how to:
• connect to databases and work with files
• map input and output schemas
• filter and join data
• insert Java code for more advanced data manipulation
As time permits, I will delve further into the feature set. Hope to see you there!
Background: I am a startup cofounder and independent consultant working in the area of enterprise ecommerce and business intelligence. I have worked or consulted for JPL, Boeing, Toyota, and various retail brands such as O'Neill, Rusty, Coolibar, and BUDK. I was also the technical reviewer for the book "Getting Started with Talend Open Studio for Data Integration." You can find out more on my blog and LinkedIn.