JDBC Driver for Okta

Build 24.0.9060

Realms

Realms.

View Specific Information

Required Scopes

To query this view, Scope must include okta.realms.read, and you must be subscribed to Okta Identity Governance.

Select

The driver uses the Okta API to process WHERE clause conditions built with the following columns and operators.
  • Id supports the '=' operator
  • Created supports the '>', '>=', '=', '<=', and '<' operators
  • LastUpdated supports the '>', '>=', '=', '<=', and '<' operators
  • IsDefault supports the '=' operator
  • Name supports the '=' and 'LIKE (starts with)' operators
  • RealmType supports the '=' and 'LIKE (starts with)' operators

All other filters are processed client-side within the driver.

For example, the following query is processed server-side:

SELECT * FROM Realms WHERE Id = 'vvrcFogtKCrK9aYq3fgV'

Columns

Name Type Description
Id [KEY] String Id of the realm
Created Datetime When the item was created
LastUpdated Datetime When the item was last updated
IsDefault Boolean Whether the realm is the default
Name String Name of a realm
RealmType String Used to store partner users. This must be set to Partner to access Okta's external partner portal.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060