> DISCOVER MORE BLOGS

The Difference Between Data Transformation and Data Translation

Data mapping is ultimately used to perform one of two operations: data transformation or data translation

Please note: This post originally appeared on Extol.com (EXTOL has been acquired by Cleo).

When talking about integration, whether it is application to application (A2A), business to business (B2B) or data and cloud integration, the goal is to exchange data, documents, information, and/or messages between a source and a target.

To accomplish this goal, we identify business patterns related to the sources and targets of these “integrations” and then apply the identified patterns to similar scenarios that meet specified criteria.  Most, if not all of these patterns will require data mappings, also known as “maps” or “rulesets”, at some point during the integration process.  These maps are ultimately used to perform one of two operations: to transform or translate data.  We often use the terms, transform and translate, interchangeably.  But, is there more to them?  Are these terms synonymous, or do their meanings differ?

Let’s look at this a little closer to see if there is a difference. 

What is Data Translation?

Data translation can be defined as the process of converting volumes of data from one syntax to another and performing value lookups or substitutions from the data during the process.  Translation can include data validation as well.  One example of data translation is to convert EDI purchase order document data into purchase order database files or even flat files while performing data validation on the source data.

Data Transformation Example

Here is a comprehensive guide to data transformation.

An example of a data transformation tool is routing a purchase order to a specific process that will perform a data translation to convert the shipping and billing address information to an invoice document.  We can also use the translation example from above, transforming an EDI purchase order to a database and then during this transformation, also perform additional processing using formulas such as determining a total number of items or total dollar amount by looping through specific data constructs.  Other actions that can be performed during the data transformation process include invoking web services and calling a process.  Another transformation example may be to convert character data from one character-encoding scheme to another.

It looks like we were able to answer the question.  A data transformation tool is not only used for data translation, but a lot more.  Data translation is limited to data operations, whereas data transformation combines data operations and process control in a single model.

More About Data Transformation

Translating an EDI 850 into Back Office Systems
Best-Kept Secrets to B2B Integration Success GUIDE
How to Gain B2B Integration Control

One of the most efficient and effective ways to improve communication in 2023 is through B2B integration. And while there are plenty of B2B integration platforms and solutions on the market, a large majority of them fall short in one key area — giving you control.

WHITE PAPER WHITE PAPER
Your B2B Integration Strategy is Broken

If you can't support end-to-end API & EDI integration or if onboarding partners and customers is painful.... your B2B integration is broken.  Here's what to do about it.

VIDEO VIDEO
Demo Video Library

Instantly access our library of demo videos to see how Cleo Integration Cloud handles all EDI, non-EDI and API integration use cases.

CASE STUDY CASE STUDY
Mohawk Global Logistics

Mohawk Global Logistics cut EDI costs by $60K a year with Cleo. Here's their success story.

RECENT POSTS