The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.
The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.
Patent No.:
Date of Patent:
Aug. 27, 2024
Filed:
May. 30, 2023
Microsoft Technology Licensing, Llc, Redmond, WA (US);
Yaakov Averbuch, Netanya, IL;
Eran Shamir, Zichron, IL;
Jacob Barac, Haifa, IL;
Michael Urinovsky, Netanya, IL;
Ido Barkan, Pardes Hanna-Karkur, IL;
Itshak Shami, Tel Aviv, IL;
Ilya Venger, Haifa, IL;
Roni Yahav, Rehovot, IL;
Microsoft Technology Licensing, LLC, Redmond, WA (US);
Abstract
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.