Data transformation is one of the most vital facets of data management. Prior to integrating data sources, conducting analytics, or utilizing data in most operational applications, data must be transformed from its native state to one suitable for the target system—even if it’s just a data mart.
As one of the integral components of the data preparation process, transformation is a requisite for common applications such as business intelligence or gleaning insight from a diversity of sources. Conventional methods of transformation are manual and induce considerable delays getting data to end users who need them most.
Anzo Smart Data Manager (ASDM) avoids these lapses and manual processes by automating several facets of transformation, enabling organizations to reap its benefits without its detriments while decreasing cost and time to action.
The automation capabilities for transformation rendered by ASDM are realized through its means of mapping and generating Extract, Transform and Load (ETL) jobs. Both of these characteristics are attributed to an evolving semantic model that is the basis of ASDM’s approach. All mapping from source to target systems—including terms and requirements from business models, conceptual models, and apposite industry models for regulations—are incorporated into this model.
Such mapping is reusable, which substantially accelerates this step for additional deployments. ASDM automatically generates ETL jobs without code on most popular ETL tools, letting organizations leverage existing infrastructure. By comparison, conventional transformation methods require IT or data scientists to define mapping requirements, code ETL jobs and manually test them each time requirements or sources change—accounting for inordinate time consumption.
The self-service capabilities of ASDM empower the business user in multiple ways. It enables users to tailor mapping to business functions with terms and regulations understood by the business and IT. This characteristic decreases reliance on IT while increasing business ownership and control of data, facilitating desired expeditiousness in integrating additional sources. ASDM also buttresses governance by providing ready availability of provenance and traceability of data, which serves as a critical check on business autonomy to support self-service.
Automated Transformation Value
The benefits of ASDM’s automated approach to transformation include saving time and cost while efficiently using enterprise resources. More importantly, it grants greater control over the data to business users to support business functions. By reducing reliance on IT, ASDM is another critical step in extending data culture throughout the entire enterprise.
Want to learn more? Download our Market Vision Brief on the Anzo Smart Data Manager.