B2B Data Integration and Transformation Blog

Articles by Tracy Loetz

Tracy Loetz

Tracy is the CEO and founder of Remedi Electronic Commerce Group. Tracy started her career as an EDI Coordinator and held a variety of positions in a large corporation before starting Remedi. At Remedi, Tracy was a consultant for many years before changing her focus to back-end operations and special projects.

Find me on:

Assessing Your B2B Maturity

Posted by Tracy Loetz on Jun 1, 2016 11:19 AM


I am going to take a time out on my blog series outlining the IBM B2B Integration products and their capabilities.  I'm just not as prepared as I should be, so I'll pick it up next round.

Read More

Transform And Translate - A Key Component Of B2B Integration

Posted by Tracy Loetz on Apr 13, 2016 1:32 PM


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.

Read More

Mapping - A Key Component Of B2B Integration

Posted by Tracy Loetz on Mar 1, 2016 11:32 AM


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.

Read More

Maximizing Your Data Integration Software Investment

Posted by Tracy Loetz on Dec 16, 2015 2:06 PM


When REMEDI started as a business twenty-one years ago, our focus was solely on EDI - integrating data from/to a trading partner from/to a company's business software. EDI software basically did what data integration software does today, but on a limited basis and it was strictly business-to-business. As companies began choosing software packages instead of developing applications in-house, the need for internal data integration grew and software developers answered the need with, what was then called, middleware. These days integration software satisfies the needs of business-to-business and application-to-application data exchange.

Read More

3 Benefits Of EDI Cross Training

Posted by Tracy Loetz on Oct 27, 2015 2:08 PM


Last week, I played "Undercover Boss" without the undercover part :)   Our office manager, Debbie, was on vacation, so it seemed like a great opportunity to see If someone else could do her job using the notes and documentation she had left. 

Read More