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 |
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.
|