The connector models entities in the PingOne API as views and stored procedures. These are defined in schema files, which are simple, text-based configuration files.

The connector exposes two kinds of schemas:

Information Schema

The Information schema exposes entities which reside above environments in the PingOne hierarchy, such as Organizations. There is only one Information schema.

See Information Data Model for the available entities.

Environment Schemas

The connector exposes a schema for each environment in the organization of the authenticated user. In these schemas you can find entities which reside below environments in the PingOne hierarchy such as Users.

See Environment Data Model for the available entities.

CUD operations

For tables in both the Information Schema and Environment schemas, the following apply when it comes to CUD operations:

• Columns that are ReadOnly cannot be included in either INSERT or UPDATE statements. Doing that will result in an error.
• For both UPDATE and DELETE statements, primary (and sometimes foreign) key columns must be specified in the criteria of the statement in order to update/delete the record successfully. Typically this is just the Id column.