×

Template-driven approach to extract, transform, and/or load

  • US 7,681,185 B2
  • Filed: 10/12/2005
  • Issued: 03/16/2010
  • Est. Priority Date: 10/12/2005
  • Status: Active Grant
First Claim
Patent Images

1. A computer-implemented method for building executable ETL (Extract, Transform, and Load) packages, the method comprising:

  • enabling a selector to select a template, the template comprising a data-independent, coordinated sequence of tasks;

    receiving the selected template;

    enabling a selection of data parameters, the data parameters comprising;

    a source table in which data is stored in a source database;

    a target table to store data in a data warehouse; and

    a mapping between the source table and the target table;

    receiving the selection of data parameters;

    inferring additional data parameters required for execution of the template, the inferring based on the selection of received data parameters;

    instantiating the data parameters to tasks of the template based on the received source table, target table, and mapping between the source table and the target table, and the inferred additional data parameters;

    generating an executable ETL package based on the template and the data parameters; and

    executing the executable ETL package.

View all claims
  • 2 Assignments
Timeline View
Assignment View
    ×
    ×