Converting data objects from single- to multi-source database environment
First Claim
1. A computer-implemented method comprising:
- causing an engine to receive a single-source universe database comprising a plurality of details;
causing the engine to analyze the single-source universe database to create a XML configuration file identifying a detail to be changed;
causing the engine to register a new multi-source connection with a repository; and
causing the engine to reference the XML configuration file to create a multi-source universe database including the multi-source connection and a changed detail by re-generating a business layer including a new object definition compatible with the multi-source universe database, the business layer further comprising a file formed by adding a generated derived table query including a join updated with a new column name and a new table name, to a re-generated data foundation.
2 Assignments
0 Petitions
Accused Products
Abstract
Embodiments relate to converting data object(s) from a single-source database environment into a multi-source database environment. An engine is configured to receive a single-source database universe from a repository. The engine analyzes that universe to identify details thereof for conversion, including but not limited to connections, tables, views, alias tables, etc. A new multi-source connection is registered, and then the multi-source universe is re-generated through a universe conversion algorithm, an automatic function mapping algorithm, and a query generation algorithm. Embodiments avoid labor intensive manual re-creation of the universe, and may be implemented as an automatic conversion wizard also updating dependent report queries per new multi-source query patterns. Particular embodiments converting a single-source database environment available from SAP AG, may utilize a Software Design Kit (SDK) to create a migration plug-in as part of an Information Design Tool (IDT).
38 Citations
12 Claims
-
1. A computer-implemented method comprising:
-
causing an engine to receive a single-source universe database comprising a plurality of details; causing the engine to analyze the single-source universe database to create a XML configuration file identifying a detail to be changed; causing the engine to register a new multi-source connection with a repository; and causing the engine to reference the XML configuration file to create a multi-source universe database including the multi-source connection and a changed detail by re-generating a business layer including a new object definition compatible with the multi-source universe database, the business layer further comprising a file formed by adding a generated derived table query including a join updated with a new column name and a new table name, to a re-generated data foundation. - View Dependent Claims (2, 3, 4)
-
-
5. A non-transitory computer readable storage medium embodying a computer program for performing a method, said method comprising:
-
causing an engine to receive a single-source universe database comprising a plurality of details; causing the engine to analyze the single-source universe database to create a XML configuration file identifying a detail to be changed; causing the engine to register a new multi-source connection with a repository; and causing the engine to reference the XML configuration file to create a multi-source universe database including the multi-source connection and a changed detail by re-generating a business layer including a new object definition compatible with the multi-source universe database, the business layer further comprising a file formed by adding a generated derived table query including a join updated with a new column name and a new table name, to a re-generated data foundation. - View Dependent Claims (6, 7, 8)
-
-
9. A computer system comprising:
-
one or more hardware processors; a software program, executable on said computer system, the software program configured to; cause an engine to receive a single-source universe database comprising a plurality of details; cause the engine to analyze the single-source universe database to create a XML configuration file identifying a detail to be changed; cause the engine to register a new multi-source connection with a repository; and cause the engine to reference the XML configuration file to create a multi-source universe database including the multi-source connection and a changed detail by re-generating a business layer including a new object definition compatible with the multi-source universe database, the business layer further comprising a file formed by adding a generated derived table query including a join updated with a new column name and a new table name, to a re-generated data foundation. - View Dependent Claims (10, 11, 12)
-
Specification