Overview

For each of these schemas, the server models entities which reside below environments in the PingOne hierarchy, such as Users.

Key Features

• The server models PingOne entities as relational tables/views or stored procedures, allowing you to write SQL to query PingOne data.
• Live connectivity to these objects means any changes to your account are immediately reflected when using the server.

Tables

Tables expose PingOne entities that can be modified like Users or Applications.

Views

Views are read-only tables that expose PingOne entities like UserSessions.

Stored Procedures

Stored Procedures are actions that are invoked via SQL queries. They perform tasks beyond standard CRUD operations, for example: RevokeUserScopeConsents.