Specification to ABAP code converter
A method of generating procedural language code for extracting data from a data warehouse comprising the steps of accepting a declarative specification and generating procedural language code to execute the declarative specification.
1. A method of generating procedural language code for extracting data from an operational system, the method comprising:
accepting a declarative specification; and
generating procedural language code from the declarative specification to execute a data extraction, transformation and loading process defined by the declarative specification.
2. The method of claim 1 , wherein the procedural language code is ABAP language code and the operational system is an SAP R/3 system.
3. The method of claim 2 , further comprising optimizing the declarative specification prior to generating the ABAP program code.
4. The method of claim 1 , wherein the declarative specification is a visual specification.
5. The method of claim 1 , wherein the declarative specification includes at least one of a scalar function, a vector function, parameterized declarative extraction specifications, custom ABAP code or a lookup operation.
6. The method of claim 1 , wherein the generating includes generating ABAP code to read and load R/3 tables, files and IDOC intermediate documents.
7. The method of claim 1 , wherein generating comprises:
reading a single declarative specification for extraction of SAP R/3 and non-SAP R/3 data including relational databases and files; and
executing the specification as a set of ABAP programs, SQL queries and in-memory transformation modules to extract, transform and load data from multiple sources.
8. The method of claim 1 , wherein the generating procedural language code forms part of generating ABAP code with parameter expressions to be evaluated at run time.
9. The method of claim 1 , further comprising:
integrating an IDOC intermediate document with relational tables; and
generating ABAP code to extract data from integrated intermediate documents and relational tables.
10. The method of claim 9 , further comprising processing individual tables as relational tables.
11. The method of claim 10 , wherein the processing forms part of generating ABAP code.
12. A non-transitory computer readable medium including executable instructions to generate procedural language code for extracting data from an operational system, comprising executable instructions to:
accept a declarative specification; and
generate procedural language code from the declarative specification to execute a data extraction, transformation and loading process defined by the declarative specification.
13. The computer readable medium of claim 12 , wherein the procedural language code is ABAP language code and the operational system is an SAP R/3 system.
14. The computer readable medium of claim 13 including executable instructions to: optimize the declarative specification prior to generating the ABAP program code.
15. The computer readable medium of claim 12 , wherein the declarative specification is a visual specification.
16. The computer readable medium of claim 12 , wherein the declarative specification includes at least one of a scalar function, a vector function, parameterized declarative extraction specifications, custom ABAP code or a lookup operation.
17. The computer readable medium of claim 12 , wherein the generating includes generating ABAP code to read and load R/3 tables, files and IDOC intermediate documents.
18. The computer readable medium of claim 12 , wherein the generating comprises:
reading a single declarative specification for extraction of SAP R/3 and non-SAP R/3 data including relational databases and files; and
executing the specification as a set of ABAP programs, SQL queries and in-memory transformation modules to extract, transform and load data from multiple sources.
19. The computer readable medium of claim 12 , wherein the generating procedural language code forms part of generating ABAP code with parameter expressions to be evaluated at run time.
20. The computer readable medium of claim 12 including executable instructions to:
integrate an IDOC intermediate document with relational tables; and
generate ABAP code to extract data from integrated intermediate documents and relational tables.