EXTRACT, TRANSFORM AND LOAD (ETL) SYSTEM AND METHOD

• Main Authors: SAMANTA, SUDIPTA, CHOUDHURY, PRAVANJAN, L, ABHILASH L, MEHRA, KRISHNA KUMAR, KUMAR, PRASUN
• Format: Patent
• Language: English
• Published: 16.07.2015
• Subjects: CALCULATING; COMPUTING; COUNTING; ELECTRIC DIGITAL DATA PROCESSING; PHYSICS

[0069] An ETL system for extracting transactional data from a plurality of source machines is provided. The ETL system includes a data query module configured to provide an interface to enable a data analyst to define an input query to extract transactional data. The transactional data is present on a plurality of source machines. The plurality of source machines form a multi-tenant system and each source machine is identified by a unique tenant identifier. The system also includes a query parsing module coupled to the data query module and configured to deconstruct the input query to create a tree structure. The tree structure comprises a plurality of distinct queries. The system further includes a data extraction module coupled to the query parsing module and configured to extract transactional data based on the plurality of distinct queries and copy the transactional data to a destination system wherein the transactional data comprises a plurality of data types. Inventor(s).: Docket No.: CPT003 SOURCE SOURCE SOURCE MACHINE MACHINE --- MACHINE 14-A 14-B 14-N EXTRACT TRANSFORM AND LOAD SYSTEM 12 SOURCE REGISTRY DATA QUERY QUERY PARSING DESTINATION MODULE MODULE MACHINE 24 26 18-A MONITORING DATA EXTRACTION DESTINATION -- MODULE MACHINE 30 28 18-B DESTINATION 18-N