Edit on GitHub
Okta link
Okta is an identity management service.
Featureslink
Feature Name | Supported | Notes |
---|---|---|
Capture deletes | ||
Custom data | check | All fields in the USER_CUSTOM_PROFILE table. |
Data blocking | check | Column level |
Column hashing | check | |
Re-sync | check | Table level. A table re-sync includes all the associated child tables. |
History | ||
API configurable | check | API configuration |
Priority-first sync | ||
Fivetran data models | ||
Private networking |
Setup guidelink
Follow our step-by-step Okta setup guide to connect Okta with your destination using Fivetran connectors.
Schema informationlink
This schema applies to all Okta connectors.
To zoom, open the ERD in a new window.API key permissionslink
Okta administrators manage all aspects of the end-user experience. Okta has many admin types, each with a unique set of permissions and restrictions. The following table outlines the different data tables and the API key permissions you need to sync them.
Table | API Key Permissions |
---|---|
DEVICE | Read-Only Admin, App Admin, Org Admin, Super Admin, Help desk Admin, API Access Management Admin |
DEVICE_USER | Read-Only Admin, App Admin, Org Admin, Super Admin, Help desk Admin, API Access Management Admin |
USER_TYPE | Read-Only Admin, Group Admin, Org Admin, Super Admin, Help desk Admin, API Access Management Admin, Group Membership Admin |
USER_CREDENTIALS_EMAIL | Read-Only Admin, App Admin, Group Admin, Org Admin, Super Admin, Help desk Admin, Report Admin, API Access Management Admin, Group Membership Admin |
USERS | Read-Only Admin, App Admin, Group Admin, Org Admin, Super Admin, Help desk Admin, Report Admin, API Access Management Admin, Group Membership Admin |
USER_ROLE | Super Admin |
RESOURCE | Super Admin |
RESOURCE_SET | Super Admin |
CUSTOM_ROLE | Super Admin |
CUSTOM_ROLE_PERMISSION | Super Admin |
GROUPS | Read-Only Admin, App Admin, Group Admin, Org Admin, Super Admin, Help desk Admin, API Access Management Admin, Group Membership Admin |
GROUP_MEMBER | Read-Only Admin, App Admin, Group Admin, Org Admin, Super Admin, Help desk Admin, API Access Management Admin, Group Membership Admin |
RULE | Read-Only Admin, App Admin, Group Admin, Org Admin, Super Admin, Help desk Admin, API Access Management Admin, Group Membership Admin |
ASSIGN_USER_TO_GROUP_ID | Read-Only Admin, App Admin, Group Admin, Org Admin, Super Admin, Help desk Admin, API Access Management Admin, Group Membership Admin |
GROUP_EXCLUDED_FROM_RULE | Read-Only Admin, App Admin, Group Admin, Org Admin, Super Admin, Help desk Admin, API Access Management Admin, Group Membership Admin |
GROUP_LOGO_LINK | Read-Only Admin, App Admin, Group Admin, Org Admin, Super Admin, Help desk Admin, API Access Management Admin, Group Membership Admin |
USER_EXCLUDED_FROM_RULE | Read-Only Admin, App Admin, Group Admin, Org Admin, Super Admin, Help desk Admin, API Access Management Admin, Group Membership Admin |
APPLICATION | Read-Only Admin, App Admin, Org Admin, Super Admin, API Access Management Admin |
APPLICATION_GROUP | Read-Only Admin, App Admin, Org Admin, Super Admin, API Access Management Admin |
APPLICATION_USER | Read-Only Admin, App Admin, Org Admin, Super Admin, API Access Management Admin |
GROUP_ROLE | Super Admin |
APPLICATION breakout child tables | Read-Only Admin, App Admin, Org Admin, Super Admin, API Access Management Admin |
SYSTEM_LOG | Super Admin, Org Admin, App Admin, Read-Only Admin, Mobile Admin, Report Admin, API Access Management Admin |
SYSTEM_LOG breakout child tables | Super Admin, Org Admin, App Admin, Read-Only Admin, Mobile Admin, Report Admin, API Access Management Admin |
PROFILE_MAPPING | Super Admin, App Admin |
POLICY | Super Admin, Org Admin, Read-Only Admin, API Access Management Admin |