Invention Grant
- Patent Title: Dedicated SQL services for cross-system SQL access to an application-server-managed database
-
Application No.: US17389548Application Date: 2021-07-30
-
Publication No.: US11941142B2Publication Date: 2024-03-26
- Inventor: Arne Harren , Marco Haupt , Helmut Prestel , Rolf Hammer , Christiane Kettschau , Kai Baumgarten , Diego Sebastian Will , Minh-Khanh Do , Timm Falter , Frank-Martin Haas , Kilian Kilger
- Applicant: SAP SE
- Applicant Address: DE Walldorf
- Assignee: SAP SE
- Current Assignee: SAP SE
- Current Assignee Address: DE Walldorf
- Agency: Buckley, Maschoff & Talwalkar LLC
- Main IPC: G06F16/25
- IPC: G06F16/25 ; G06F21/62 ; H04L9/40

Abstract:
Methods for using SQL statements to access an application-server-managed database are disclosed herein. In some embodiments, a user sends, either directly or indirectly (i.e., remotely) a SQL statement from an ODBC application or server, respectively, to an application server that preprocesses SQL statements for accessing data from a centralized database. The application server may have a SQL endpoint, and access to the SQL endpoint may be determined by a user's logon credentials, a user's presentation of a SAML token, or a user's presentation of a valid certificate. The application server may then parse the SQL statement and determine the user's authorization to access certain objects in the centralized database based on a SQL handler design-time configuration. A result from the statement may be sent back to the user either directly or indirectly and exposed.
Public/Granted literature
- US20230030785A1 DEDICATED SQL SERVICES FOR CROSS-SYSTEM SQL ACCESS TO AN APPLICATION-SERVER-MANAGED DATABASE Public/Granted day:2023-02-02
Information query