{"id":60,"date":"2016-05-18T08:50:04","date_gmt":"2016-05-18T08:50:04","guid":{"rendered":"https:\/\/etlsolutions.com\/?page_id=60"},"modified":"2021-10-07T09:57:17","modified_gmt":"2021-10-07T08:57:17","slug":"transformation-manager","status":"publish","type":"page","link":"https:\/\/etlsolutions.com\/transformation-manager\/","title":{"rendered":"Transformation Manager data movement software"},"content":{"rendered":"<h2>Proprietary software that&#8217;s at the heart of our data services<\/h2>\n<p>Transformation Manager is the data movement software deployed within <a href=\"http:\/\/www.etlsolutions.com\/data-hub-3\/\">our DataHub integration service<\/a>. It is also used to create one-off data migrations for our clients. Flexible and extensible, Transformation Manager is used by our consultants to connect, transform and consolidate data from any source to any target system.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"1310\" height=\"428\" class=\"alignleft size-full wp-image-4756\" src=\"https:\/\/etlsolutions.com\/wp-content\/uploads\/2016\/05\/application.jpg\" alt=\"application\" srcset=\"https:\/\/etlsolutions.com\/wp-content\/uploads\/2016\/05\/application.jpg 1310w, https:\/\/etlsolutions.com\/wp-content\/uploads\/2016\/05\/application-250x82.jpg 250w, https:\/\/etlsolutions.com\/wp-content\/uploads\/2016\/05\/application-768x251.jpg 768w, https:\/\/etlsolutions.com\/wp-content\/uploads\/2016\/05\/application-700x229.jpg 700w, https:\/\/etlsolutions.com\/wp-content\/uploads\/2016\/05\/application-120x39.jpg 120w\" sizes=\"(max-width: 1310px) 100vw, 1310px\" \/><\/p>\n<h2>How Transformation Manager works<\/h2>\n<div id=\"point\">\n<h4>An efficient approach.<\/h4>\n<p>Transformation Manager is a metadata-driven code generator. It combines a graphical user interface with a statement-driven mapping language. This combination produces lightweight code that\u2019s robust enough for any data integration challenge.<\/p>\n<\/div>\n<div id=\"point\">\n<h4>A rich Java environment.<\/h4>\n<p>Transformation Manager derives metadata from the elements, attributes and relationships in the source and target models. The software then uses rules specified by our Simple Mapping Language to generate code written in Java. This code can then be easily implemented in any data movement situation.<\/p>\n<\/div>\n<div id=\"point\">\n<h4>Flexible options.<\/h4>\n<p>Deployed for you as part of our DataHub service, or implemented by our consultants for your one-off migration\u2026 Transformation Manager works any way you need it to.<\/p>\n<\/div>\n<h2>Software architecture<\/h2>\n<p>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 team members. The flexibility of Transformation Manager enables our consultants to apply any source control software against this repository to manage transformations. All Transformation Manager\u2019s proprietary tools share the repository, creating a streamlined process.<\/p>\n<div id=\"point\">\n<h4>Design tool.<\/h4>\n<p>The Designer is a tool that develops, debugs and maintains transformation projects. The tool has a clear, streamlined interface with a host of useful features.<\/p>\n<\/div>\n<div id=\"point\">\n<h4>Test tool.<\/h4>\n<p>The Migrator is a user-friendly interface for setting up and running projects. It\u2019s perfect for using sample data to view and check the results of a migration.<\/p>\n<\/div>\n<div id=\"highlight\">\n<h2>Why we created Transformation Manager<\/h2>\n<ul>\n<li><strong>Reduced risk.\u00a0<\/strong>Integrated test and debugging environments, together with a complete regression test framework, minimise the risk of errors in a transformation.<\/li>\n<li><strong>Light footprint.\u00a0<\/strong>There\u2019s no need to make changes to our clients&#8217; software architecture. Transformation Manager\u2019s small deployment footprint enables transformations to slot right into existing data flows.<\/li>\n<li><strong>Improved efficiency. <\/strong>The software enables our consultants to reuse existing models and transforms, cutting down development time. We use Simple Mapping Language to work transparently across our clients&#8217; organisations.<\/li>\n<li><strong>Lower costs. <\/strong>Transformation Manager&#8217;s features mean that we can complete projects faster, correct errors early and reduce timescales. And with Transformation Manager, our clients avoid any expensive server hosting.<\/li>\n<\/ul>\n<\/div>\n<div id=\"downloads\">\n<ul>\n<li><a href=\"https:\/\/www.etlsolutions.com\/category\/data-case-studies\/\">Read a case study<\/a><\/li>\n<li><a href=\"https:\/\/etlsolutions.com\/wp-content\/uploads\/2021\/10\/Transformation-Manager-Brochure.pdf\" target=\"_blank\" rel=\"noopener\">Transformation Manager brochure<\/a><\/li>\n<\/ul>\n<\/div>\n","protected":false},"excerpt":{"rendered":"Proprietary software that&#8217;s at the heart of our data services Transformation Manager is the data movement software deployed within our DataHub integration service. It is also used to create one-off data migrations for our clients. Flexible and extensible, Transformation Manager is used by our consultants to connect, transform and consolidate data from any source to&#8230; <a class=\"view-article\" href=\"https:\/\/etlsolutions.com\/transformation-manager\/\">View Article<\/a>","protected":false},"author":1,"featured_media":6298,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_mo_disable_npp":"","footnotes":""},"acf":[],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/etlsolutions.com\/wp-json\/wp\/v2\/pages\/60"}],"collection":[{"href":"https:\/\/etlsolutions.com\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/etlsolutions.com\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/etlsolutions.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/etlsolutions.com\/wp-json\/wp\/v2\/comments?post=60"}],"version-history":[{"count":24,"href":"https:\/\/etlsolutions.com\/wp-json\/wp\/v2\/pages\/60\/revisions"}],"predecessor-version":[{"id":7269,"href":"https:\/\/etlsolutions.com\/wp-json\/wp\/v2\/pages\/60\/revisions\/7269"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/etlsolutions.com\/wp-json\/wp\/v2\/media\/6298"}],"wp:attachment":[{"href":"https:\/\/etlsolutions.com\/wp-json\/wp\/v2\/media?parent=60"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}