1. Executive Summary:
Data is critical to all aspects of an organisation, and data integration is widely recognised as a key component of most IT budgets. The problem of transforming and integrating data is widespread throughout virtually every business sector and the task is often formidable. As the business environment changes with ever more pace, so too do the demands placed upon existing infrastructures, applications and processes to move to meet the new requirements. Organisations continually need to react increasingly quickly to market and competitive pressures, while still seeking the most cost effective solutions.
This whitepaper outlines the solution choices available and then the key role a data integration and extract, transform and load (ETL) tool can play in significantly empowering the organisation’s existing IT resources. It seeks to outline areas where such a tool can deliver solutions more effectively and describes specific features and functionality that can add real practical value to both developers and domain experts alike.
ETL Solutions’ data transformation product, Transformation Manager (referred to as TM), is an ETL tool providing a proven, practical, robust and capable solution to complex data integration and transformation requirements and is gaining significant customer-base. This whitepaper provides an overview of TM, describing its features and identifying its position within the landscape of ETL tools .
ETL Solutions is a specialist in the field of data transformation and our approach is to provide an extremely flexible and powerful meta-data driven, code generating, suite of tools. This approach ensures architects have full freedom to adopt a data integration architecture of their choice with access to all forms of data. In these respects TM is an ideal solution to any organisation wishing to be flexible and maintain control of their architecture decisions.
