Microsoft Technology Licensing, LLC

Michael Urinovsky

Eran Shamir

Jacob Barac

Yaakov Averbuch

Ido Barkan

Itshak Shami

Ilya Venger

Roni Yahav

Transformation of source data from a source field of a source table to a target field of a target table using data transformation archetypes. A set of data transformation archetypes may be defined that each comprises transformation code for transforming the source data. A data transformation archetype may be identified by a data transformation toolkit engine for application to the source data based on the target field of the target table. In this way, a characteristic or relationship of the target field (e.g., as described by a target schema and/or target semantic) may be used to identify the data transformation archetype for use in transforming source data mapped to the target field. Accordingly, a more efficient and less error-prone Export, Transform, and Load (ETL) tool may be provided that provides automation of the transformation without requiring a user to dictate the transformation operations manually.

Data transformation toolkit

Growing community of inventors

Netanya, Israel

Michael Urinovsky