We have an Okta SSO integration working where it sends first_name, email, user_name and sso_source. Okta also sends Manager and Department. I'm assuming that Manager and Department are not regular fields like the fields in the transform map. Maybe they are being sent as Attributes? I want to process each user's department and department ID as they come in with the user_name by inserting a unique department ID and Department name into the cmn_department table if it doesn't exist so that the Department will display on the user profile. The requirement is to only insert new departments as they don't exist. Since the transform map that is created for this import doesn't have the attribute fields how can this be done?
UPDATE: This integration is using the Okta owned ServiceNow UD connector. Does anyone have confirmation that this integration is Direct to the Group & User tables and does not interact at all with the import table and transform map? If this is the case, then to enable the Department coming from Okta, it seems that the Departments have to be pre loaded into the ServiceNow cmn_department table for it to get added in this integration. Does anyone have any information on this?
