DATA TRANSFORMATION

Data Transformation is the conversion of data from its existing format or structure to any number of different formats or structures. Data transformation is used to 'massage' the data in a source system to make it suitable for use at it's destination.

Transformation can be as simple as providing a data file for import into a Microsoft Excel spreadsheeet, or involve greater complexity such as the scheduled extraction and standardisation of data from numerous enterprise operational systems in prepration for cross-system financial reconciliation.

The functions performed during data transformation tend to change over time as data in the underlying systems evolves in line with business needs. A data transformation toolset is used to replace the laborious and risk-prone task of writing and maintaining custom software to undertake once-only or periodic transformations.


See also:
Transformation

Business Applications for Transformation
Business data transformation is commonly required prior to transferring data between different systems and when producing output with changed structures or formats.

Data Transformation is associated with data cleansing and data migration and is generally undertaken in conjunction with any of the following activities:
  • Replacing legacy systems.
  • Upgrading application software, databases or infrastructure.
  • Decommisioning old system platforms.
  • Preparing data for updating various business systems.
  • Extracting data for use in a range of analytical tools.
  • Business to business data exchange including:
    • importing data received from external sources
    • producing files containing data required by other organisations.

Data Transformation Services

Datalynx specialist data management services help to maintain the quality and integrity of your corporate data assets.

Data transformation is offered via:
  • Project-based services provided pre or post data migration.
  • Subscription-based services in combination with data profiling.

Datalynx Technology
Datalynx transformation services are supported by the Data Xchange system; our configurable toolset for high-speed large-volume data transformation. See Data Xchange software licensing for more information on licensing Datalynx products and the range of support services we provide.

Innovation through People, Technology & Information Management