GENERATING ETL PACKAGES FROM TEMPLATE
First Claim
1. A method for generating a set of code comprising a package, comprising:
- generating a template for a package configured to be used with an SQL server, the template having a source component, data transformation component and a destination component, at least one of the components including one or more properties designated as configurable by a user;
generating an instance from the template, the instance including values for the one or more configurable properties; and
creating a package from the instance, the package configured to retrieve data from one or more sources identified by the source component and store the data in one or more destinations identified by the destination component, the package including a mapping between the one or more sources and the one or more destinations.
2 Assignments
0 Petitions
Accused Products
Abstract
Packages for server data extraction, transformation and loading (ETL) are generated and managed through package templates. The templates include configurable and static parameters and are created from user input. Package instances having template property values are created from the templates and then transformed into a package used to implement ETL functionality. In some embodiments, a package template may include one or more components for retrieving data from a source, transformation of the retrieved data before it is stored, and storage of the data at a destination. Packages can be modified based by importing the package, changing an instance associated with the modified package, and generating a package from the modified instance.
-
Citations
20 Claims
-
1. A method for generating a set of code comprising a package, comprising:
-
generating a template for a package configured to be used with an SQL server, the template having a source component, data transformation component and a destination component, at least one of the components including one or more properties designated as configurable by a user; generating an instance from the template, the instance including values for the one or more configurable properties; and creating a package from the instance, the package configured to retrieve data from one or more sources identified by the source component and store the data in one or more destinations identified by the destination component, the package including a mapping between the one or more sources and the one or more destinations. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12)
-
-
13. One or more processor readable storage devices having processor readable code embodied on said processor readable storage devices, said processor readable code for programming one or more processors to perform a method comprising:
-
creating a first package from a template instance, the template instance containing, a source component configured to retrieve source data, a data transformation component configured to process the retrieved data, and a destination component configured to store destination data at an SQL server, the first package including at least one source component property, destination component property, and a mapping associated with the source data and destination data; accessing an instance associated with the first package; changing one or more component properties of the accessed instance; and creating a modified package based on the changed instance. - View Dependent Claims (14, 15, 16, 17)
-
-
18. A method for generating a package for processing data, comprising:
-
generating a template for a package configured to be used with an SQL server, the template having a source component, data transformation component and a destination component, the source component including one or more configurable source properties, the destination component containing one or more configurable destination properties and one or more mapping properties; generating an template instance from the template, the instance including values for the one or more configurable source properties which indicate a data source, values for one or more configurable destination properties which indicate a data destination, and values for one or more configurable mapping properties which indicate how the source data is mapped to the destination data; creating a parameter file from the instance, the parameter file indicating changes to be made to a template based on the template instance; and creating a package from the template and the parameter file, the package configured to retrieve data from one or more sources identified by the source component properties, transform the retrieved data, and store the transformed data in one or more destinations within an SQL server as identified by the destination component properties. - View Dependent Claims (19, 20)
-
Specification