Patent ID: 11941142
Assignee: SAP SE
Field: Computer technology (Electrical engineering)
Classification: CPC G  H | IPC G  H

Claim 14:
15. A system for accessing data in an Application-Server-Managed Database System (ASMDS)comprising:
an application server to receive a certificate from an Open Database Connectivity (ODBC) driver;
an database managed by the application server;
and ODBC-connected application used to connect to the ASMDS; and
one or more non-transitory computer-readable media storing computer executable instructions that, when executed by a processor, perform a method of accessing the data from the application-server-managed database in the ASMDS by routing SQL statements through the application server, the method comprising:
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.