Summary

This was the first time we got our hands dirty with the Studio, the Studio, and we looked at some common integration scenarios based on common file formats. We looked at transforming files from one format to another—CSV to XML, for example. We also explored the tMap component and its built-in Expression editor. We built jobs using the multi-schema XML component, and saw how we can map data to the most complex XML structures using the advance XML output component. We also saw how to join data from different sources using both the tJ join component and the join functionality within tMap.

Let's move on to look at how the Studio can work with another common systems component—the relational database.