Tables

The driver models the data in PingOne as a list of tables in a relational database that can be queried using standard SQL statements.

CData ODBC Driver for PingOne Tables


Name	Description
AdminRoles	The built-in and custom administrator roles in the environment.
ApplicationAdminRoleAssignments	The administrator role assignments of the application.
ApplicationAttributeMappings	The attribute mappings configured for the application.
ApplicationAuthenticationPolicyAssignments	The authentication (sign-on) policy assignments of the application.
GroupAdminRoleAssignments	The administrator role assignments of the group.
Groups	The groups in the environment.
OIDCApplications	The OIDC-protocol applications in the environment.
ParentGroupAssociations	The parent groups associations of the group.
Populations	The populations in the environment.
ResourceAttributeMappings	The attribute mappings configured for the application.
Resources	The resources in the environment.
ResourceScopes	The scopes of the resource.
SAMLApplications	The SAML-protocol applications in the environment.
UserAdminRoleAssignments	The administrator role assignments of the user.
UserGroupAssociations	The user-group associations (group memberships) of the user.
UserOAuthScopeConsents	The OAuth scope consents of the user.
Users	The users in the environment.
UserSessions	The sessions of the user.
WSFederationApplications	The WSFederation-protocol applications in the environment.