SSIS Components for Okta

Build 24.0.9060

ProfileMappings

Profile mappings.

View Specific Information

Required Scopes

To query this view, Scope must include okta.profileMappings.read. Additionally, Okta Support must be contacted to enable the Profile Mappings API on your account.

Select

The component uses the Okta API to process WHERE clause conditions built with the following columns and operators.
  • Id supports the '=' operator
  • SourceId supports the '=' operator
  • TargetId supports the '=' operator

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

For example, the following queries are processed server-side:

SELECT * FROM ProfileMappings WHERE Id = 'cB6u7X8mptebWkffatKA'

SELECT * FROM ProfileMappings WHERE SourceId='otysbePhQ3yqt4cVv0g3' AND TargetId='0oa1qmn4LZQQEH0wZ0g4'

Columns

Name Type Description
Id [KEY] String Id of the profile mapping
SourceId String Source id
SourceName String Source name
SourceType String Source type
TargetId String Target id
TargetName String Target name
TargetType String Target type
Properties String Profile mapping properties

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