5. The Benefits of Transformation Manager:
5.1. Higher Productivity:
- Produce data integration or ETL components at a fraction of the time taken by hand coding.
- Create more simple transforms simply by drag and drop in minutes.
- Build components to handle the most complex logic fast and accurately.
- Data models are easily captured and presented in a simple common tree structure, regardless of format.
- Its easy to use wizards ensure that the first transforms are created within minutes.
- Its comprehensive Online Help allows concepts to be quickly understood and employed.
- Test and re-work instantly allowing errors to be detected early in the development cycle.
- Rapidly incorporate changes and dramatically reduce time to market.
- New methods and features are added rapidly to move with customer requirements.
- TM is easy to learn unlike the implementation skills for multiple technologies.
5.2. Handle the Most Complex Requirements:
TM has the depth of capability to handle the most complex data transformations without the need for hand-coded extensions or use of multiple tools/technologies:
- Its range of functionality goes beyond traditional extract, transform, and loading of data, and provides for a complete data integration solution, complete with cleansing, reconciliation, documentation, and model management.
- Existing or complex java functions are re-used rather than re-written.
- It supports transformations between multiple sources and targets that may be a combination of different data formats, e.g. Database, XML, Java, or Excel spreadsheets , therefore avoiding the need for additional skills .
- It has unrivalled database capabilities, for example, allo wing access to Binary Large Objects, Triggers, and Views.
- It allows for completely scalable XML transforms with a variety of policies for caching data.
5.3. Deployment Flexibility to Suit Project Requirements:
TM offers significant benefits at implementation and deployment:
- Unlike so many of its competitors TM is truly open-ended. Users take delight in being able creatively to extend and modify its behaviour in order to solve their business problems elegantly.
- Rich deployment choices allow users to partition the transforms as they wish, operate in either near real time processing or bulk modes of operation, operate in pull or push modes, and interact with system architecture to implement security and transaction control as required.
- Use existing hardware and skill sets .
- Deployment options for Java and .NET Architectures.
- TM generates standard portable Java code, which can be deployed in virtually any Java Virtual Machine, allowing TM to integrate with your existing infrastructure without the need for a proprietary run-time environment and production overhead.
- Alternatively, TM deploys XML transform descriptions with surprisingly little overhead and provides for an easier deployment solution for both Java and .NET architectures.
- TM transforms have been deployed with a range of messaging architectures.
- Performance optimisation to meet even the most demanding data volumes.
- A simple deployment tool can be provided to schedule and run transforms with ease.
