{"id":4514,"date":"2016-05-18T13:57:09","date_gmt":"2016-05-18T13:57:09","guid":{"rendered":"https:\/\/etlsolutions.com\/?page_id=4514"},"modified":"2021-10-06T14:52:01","modified_gmt":"2021-10-06T13:52:01","slug":"transformation-manager-2","status":"publish","type":"page","link":"https:\/\/etlsolutions.com\/transformation-manager-2\/","title":{"rendered":"Transformation Manager data movement software"},"content":{"rendered":"

The heart of our DMS integration service<\/h2>\n

Transformation Manager is a proprietary data movement software suite deployed within our DataHub service<\/a>. It has been proven in complex data movement projects across the world. The software enables our consultants to rapidly build systems that connect any dealer management system (DMS) data with any target, accurately.<\/p>\n

\"etl-image2\"<\/p>\n

How Transformation Manager works<\/h2>\n
\n

Efficient development.<\/h4>\n

Transformation Manager eliminates the complexities of dealing with databases, SQL, XML, spreadsheets or flat files by treating all of them as standard data models. Our consultants need only focus on the data content and transformation logic, speeding up project deployment.<\/p>\n<\/div>\n

\n

Flexible and portable.<\/h4>\n

Adaptability is the hallmark of Transformation Manager. The runtime environment is a set of Java components which can be deployed in any Java-compatible architecture, eliminating the need for costly hardware and software servers. Transformation Manager’s components can be run standalone, or be called from any application, making the software the ideal partner for modern architectures.<\/p>\n<\/div>\n

\n

Optimum approach.<\/h4>\n

The software derives metadata from the elements, attributes and relationships in the source and target models. Transformation Manager then uses rules specified by our Simple Mapping Language (SML), which is specifically designed for implementing data transformation projects. Combined with its sophisticated tooling, Transformation Manager provides the ideal approach for data transformation projects: the common language provided by SML; the domain-specific terminology driven by the metadata; and the rich, mature support of the Java environment.<\/p>\n<\/div>\n

Software architecture<\/h2>\n

Transformation Manager is designed as an open system. All models and transform logic are stored in a text-based metadata repository, which can be easily shared by multiple developers.<\/p>\n

\n

Design tool.<\/h4>\n

The Designer uses a drag-and-drop interface to develop and maintain transformations. Source and target data models are loaded into the tool, then the source and target attributes are mapped using the software’s streamlined interface. If any complex business logic is needed, this code is easily created using our Simple Mapping Language. The tool has over 350 built-in functions, including database lookups, string manipulation and mathematical functions. Transformation Manager can also call any external function using a Java API, so integrating third party or user calls is very straightforward.<\/p>\n<\/div>\n

\n

Test tool.<\/h4>\n

The Migrator enables our consultants to run the software at any time during the design process, using sample data. The tool instantly shows source and target layouts and data content, as well as HTML documentation. Each transform can be tested iteratively to build a system quickly.<\/p>\n<\/div>\n

\n

Why our consultants use Transformation Manager<\/h2>\n