B2B Data Integration and Transformation Blog

I am continuing on my integration ladder with flow.  My series started with Mapping - A Key Component Of B2B Integration, and continued with Transform And Translate - A Key Component Of B2B Integration, Communicate (Part 1) - A Key Component Of B2B Integration, and my last post, Communicate (Part 2) - A Key Component Of B2B Integration.  

Several months ago, I started this blog series to give an overview of the products that are in the IBM® B2B Integration track and explain how they work together and what they do. 

The series is based on the image below, which is my simplified version of the layers of B2B and data integration.  

So far I've gone through mapping, transform/translate, and a portion of communicate. This post will be the second part of communicate, which focuses on IBM's Managed File Transfer products.  These products can be stand-alone products or integrate with some of IBM's integration products. 

I took a hiatus from my IBM products review and now I am back to move to the next rung of the ladder….communicate.

For me, this is the most convoluted of all the areas of B2B integration. I think it is because I have been removed from the communications aspect of data integration for some time. Just looking at all the IBM products in the B2B Integration and Managed File Transfer product lines, made my head spin. For this reason, I'm going to split this blog into several to cover all the products.

In my last blog, Mapping - A Key Component Of B2B Integration, I focused on the different IBM® mapping tools and the products they typically work with.  This time, I will talk about the transformation and translation products.

While mapping is the tool to define how data will be formatted from a source file to a destination file, transformation and translation is the process of executing the instructions in the map to produce the destination file.  

Transformation and translation are often used interchangeably, although I personally think of them as slightly different.

Over the next several weeks, I'm going to give an overview of the products that are in the IBM® B2B Integration track and explain how they work together and what they do. 

The image below is my version of the layers of B2B and data integration.  

At the very bottom of the totem pole, is the map.  A map is what identifies which data in the input or source is going to be moved to the output or destination and where it is going to go.  A mapper has the capability to execute instructions based on rules.  For example, if you are receiving a ship notice, you may only want to capture the delivery date and not the ship date and purchase order date.  You would create a rule that would check for the delivery date and only move that one to the output.  A mapper also has the capability to cross-reference data, such as converting a customer SKU to your internal product code.