公开(公告)号：US20230030785A1

公开(公告)日：2023-02-02

申请号：US17389548

申请日：2021-07-30

Applicant: SAP SE

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

IPC: G06F21/62 ,  G06F16/21 ,  G06F16/25 ,  H04L29/06

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.

公开(公告)号：US11941142B2

公开(公告)日：2024-03-26

申请号：US17389548

申请日：2021-07-30

Applicant: SAP SE

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

IPC: G06F16/25 ,  G06F21/62 ,  H04L9/40

CPC classification number: G06F21/6227 ,  G06F16/256 ,  G06F16/258 ,  H04L63/0815 ,  H04L63/0823

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.