Next generation architecture for database connectivity
AssigneeSap SE
InventorAlexander Ocher
Life of this patent
Estimating the term…
Abstract
According to some embodiments, a method and an apparatus of importing data using a database management system (“DBMS”) with integrated Extract, Transform and Load (“ETL”) functionality. The method comprises receiving a command to access data. The command is associated with an ETL function. An executable file associated with the ETL function is called and the data associated with the command is received.
Claims17
A method of importing data using a database management system (“DBMS”) with integrated Extract, Transform and Load (“ETL”) functionality, the method comprising:
- receiving a command at a DBMS comprising an integrated ETL function to access data, wherein the command to access data comprises an SQL or SQL-like query and the query comprises a from statement that indicates a job name associated with the ETL function;
- performing a lookup of the command in a data dictionary associated with the DBMS to determine that the command is to access data via the integrated ETL function;
- loading an executable file associated with the command into the DBMS, wherein the command is determined to access data via the integrated ETL function;
- executing, via a processor, the executable file associated with the ETL function in a memory space of the DBMS;
- and
- receiving the data associated with the command.
A non-transitory computer-readable medium comprising instructions that when executed by a processor perform a method of importing data using a database management system (“DBMS”) with integrated Extract, Transform and Load (“ETL”) functionality, the method comprising:
- receiving a command at a DBMS comprising an integrated ETL function to access data, wherein the command to access data comprises an SQL or SQL-like query and the query comprises a from statement that indicates a job name associated with the ETL function;
- performing a lookup of the command in a data dictionary associated with the DBMS to determine that the command is to access data via the integrated ETL function;
- loading an executable file associated with the command into the DBMS, wherein the command is determined to access data via the integrated ETL function;
- executing, via a processor, the executable file associated with the ETL function in a memory space of the DBMS;
- and
- receiving the data associated with the command.
An apparatus comprising:
- a processor;
- and
- a non-transitory computer-readable medium comprising instructions that when executed by the processor perform a method of importing data using a database management system (“DBMS”) with integrated Extract, Transform and Load (“ETL”) functionality, the method comprising:
- receiving a command at a DBMS comprising an integrated ETL function to access data, wherein the command to access data comprises an SQL or SQL-like query and the query comprises a from statement that indicates a job name associated with the ETL function;
- performing a lookup of the command in a data dictionary associated with the DBMS to determine that the command is to access data via the integrated ETL function;
- loading an executable file associated with the command into the DBMS, wherein the command is determined to access data via the integrated ETL function;
- executing, via a processor, the executable file associated with the ETL function in a memory space of the DBMS;
- and
- receiving the data associated with the command.
Dependencies are inferred from the claim text.