Dedicated SQL services for cross-system SQL access to an application-server-managed database

US11941142B2 · kind B2 · utility

Assignee

• SAP SE · DE

Inventors

• Arne Harren · Walldorf, DE
• Marco Haupt · Biblis, DE
• Helmut Prestel · Bad Schönborn, DE
• Rolf Hammer · Walldorf, DE
• Christiane Kettschau · Leimen, DE
• Kai Baumgarten · Walldorf, DE
• Diego Sebastian Will · Heidelberg, DE
• Minh-Khanh Do · Heidelberg, DE
• Timm Falter · Sinsheim, DE
• Frank-Martin Haas · Wiesloch, DE
• Kilian Kilger · Walldorf, DE

Key dates

• Filing date: Jul 30, 2021
• Grant date: Mar 26, 2024
• Expiry date: May 17, 2042

Classification

• Technology area (CPC H): Electricity
• CPC primary: H04L63/0823
• WIPO field: Computer technology
• WIPO sector: Electrical engineering

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.