US 11,941,142 B2
Dedicated SQL services for cross-system SQL access to an application-server-managed database
Arne Harren, Walldorf (DE); Marco Haupt, Biblis (DE); Helmut Prestel, Bad Schoenborn (DE); Rolf Hammer, Karlsruhe (DE); Christiane Kettschau, Leimen (DE); Kai Baumgarten, Rauenberg (DE); Diego Sebastian Will, Heidelberg (DE); Minh-Khanh Do, Heidelberg (DE); Timm Falter, Sinsheim-Hilsbach (DE); Frank-Martin Haas, Wiesloch (DE); and Kilian Kilger, Dossenheim (DE)
Assigned to SAP SE, Walldorf (DE)
Filed by SAP SE, Walldorf (DE)
Filed on Jul. 30, 2021, as Appl. No. 17/389,548.
Prior Publication US 2023/0030785 A1, Feb. 2, 2023
Int. Cl. G06F 16/25 (2019.01); G06F 21/62 (2013.01); H04L 9/40 (2022.01)
CPC G06F 21/6227 (2013.01) [G06F 16/256 (2019.01); G06F 16/258 (2019.01); H04L 63/0815 (2013.01); H04L 63/0823 (2013.01)] 20 Claims
OG exemplary drawing
 
1. A method of accessing data from a database in an application-server-managed database system (ASMDS) by routing structured-query-language (SQL) statements through an application server, the method comprising:
receiving, by the application server, a certificate from an Open Database Connectivity (ODBC) driver;
receiving, from the ODBC driver, an SQL statement by a SQL endpoint in the application server;
handling the SQL statement in connection with a design-time configured SQL handler comprising:
a service definition listing objects to be exposed; and
a service binding comprising configuration data to expose said objects;
wherein a SQL service artifact associated with the service binding is generated upon activation of the service binding;
parsing the SQL statement and extracting schema names referenced in the SQL statement;
in response to validating the certificate and determining that data access is permitted, retrieving centralized data corresponding to the SQL statement from a centralized database; and
exposing the service binding to a user as a schema containing the centralized data.