Method for Transforming Setup Data in Business Applications
First Claim
1. A method of automating the transformation of setup data for business applications, the method comprising:
- storing metadata for a business object in a relational database schema in a business application, the metadata comprising a data map between data about the business object in a source database instance and corresponding data about the business object in a target database instance; and
generating automatically, based on the metadata, scripts to extract data from the source database instance to a set of intermediate tables, transform the data in the set of intermediate tables, and load the transformed data to the target database instance.
0 Assignments
0 Petitions
Accused Products
Abstract
The disclosure describes a method for automating the transformation data for business applications. The method involves a transformation engine using a data map between a set of physical entities corresponding to business objects in a source database instance and a corresponding set of physical entities in a target database instance. The data transformation engine using the data map generates automatically scripts to extract data from the source database instance to a set of intermediate tables, transform the data in the set of intermediate tables, and load the transformed data to the target database instance. The data map may be generated based on one or more of foreign key information and constraint information. The method also considers the dependencies of various business objects on each other and the sequence in which the business objects should be transformed.
33 Citations
18 Claims
-
1. A method of automating the transformation of setup data for business applications, the method comprising:
-
storing metadata for a business object in a relational database schema in a business application, the metadata comprising a data map between data about the business object in a source database instance and corresponding data about the business object in a target database instance; and generating automatically, based on the metadata, scripts to extract data from the source database instance to a set of intermediate tables, transform the data in the set of intermediate tables, and load the transformed data to the target database instance. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9)
-
-
10. A computer-readable medium having a computer program stored in the medium, the computer program comprising instructions for:
-
storing metadata for a relational database schema in a business application, the metadata comprising a data map between a set of physical entities corresponding to business objects in a source database instance and a corresponding set of physical entities in a target database instance; and generating automatically, based on the metadata, scripts to extract data from the source database instance to a set of intermediate tables, transform the data in the set of intermediate tables, and load the transformed data to the target database instance. - View Dependent Claims (11, 12, 13, 14, 15, 16, 17, 18)
-
Specification