Overview

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

Key Features

• The add-in 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 add-in.

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.