ETL Solutions



In use by several major banks, Transformation Manager (™) has been used in a range of projects to rapidly implement FpML based data, messages and systems and helps bridge the gap between developer and analyst when integrating FpML into the enterprise. A generic transformation and integration tool, TM combines a high level view of the integration models and rules with the ability to do complex and low level transformations. Code generation with a simple and lightweight runtime interface enables proven deployment into any enterprise system, including J2EE, Murex and proprietary messaging systems. TM is being used to integrate FpML derivatives with databases, Java APIs, flat files, documentation and non FpML-based XML schemas.

Key Features

Comprehensive IDE combining easy to use GUI, 300+ built-in functions, wizards, debugger and test tools, deployment tool etc with a unique powerful high level mapping syntax. TM generates portable Java code offering complete flexibility and freedom to deploy in client architectures Open Interface provides access and viewing of almost any kind of data Metadata driven Many additional features including validation, cleansing, test driven design, and reconciliation Support virtually any data sources and targets

Technical Details

Transformation Manager allows the user to describe the links or transforms between the different types of data at the highest possible semantic level using either an in-built "Simple transformation Language" SML or W3C's XSLT transformation language if this is preferred, or indeed a mixture of these. Very complex logic embedded in the tool is then used to generate code for deployment, either Java or XSLT (or again a mixture of these), that perform the transform. This paradigm solves a whole range of problems - from the simple problem of taking standalone Microsoft Excel data and updating a local database to the complex issues of generating and controlling the transformations embedded in types of global distributed applications required by the new era of e-Business. XML is the key piece in the building of the loosely coupled integration architectures and is being used by most major corporations to build web applications. These distributed architectures draw upon open standards such as the OMG's CORBA, Sun's J2EE or Web Services. transformation Manager fully supports these international standards and is application-vendor neutral. These features are extremely important in an integration product intended for widespread market acceptance. In short the product offers:

  • Model enhancement. TM enables the basic XSD model to be enhanced with additional or modified relationships, properties and facets. For example, whereas FpML schema may refer to a list of generic party elements, TM can identify parties more specifically, such as counter parties, and refer to them by name within the business rules.
  • Validation. XML schema cannot validate all constraints, for example elements which are optional for some message types, and mandatory for others. Business rules can be added to perform this sort of validation, with violations collected in a report or causing a fatal exception.
  • Ordering. When creating XML, including FpML, TM orders the output according to the schema, allowing the user to ignore low level details of creating target elements in the correct order.
  • Versioning. TM is ideal for migrating instances from one schema version to another. With the model comparator, support for identity transforms, assisted creation of transforms for similar sources and targets, developers of such transforms can concentrate on the differences between the two models.
  • Flexibility. Whether storing FpML into a relational database, producing documentation, transforming to an internal schema, instantiating equivalent Java business objects or creating FpML from any of these sources, TM uses the same interface to describe the business rules of how this is achieved. Runtime deployments are designed for minimal disruption to existing systems, and as pure Java code operate within workflow engines such as Murex, proprietary messaging systems, J2EE application servers, and batch/bulk load environments.

Supported Versions of FpML

FpML 1.0
FpML 2.0
FpML 3.0
FpML 4.0
FpML 4.1
FpML 4.2