Chat now with support
Chat with Support

Starling Connect Hosted - One Identity Manager Administration Guide

About this guide One Identity Starling Connect overview One Identity Starling Supported cloud applications Working with connectors Connector versions Salesforce Facebook Workplace SAP Cloud Platform JIRA Server RSA Archer SuccessFactors AWS IAM ServiceNow Dropbox Crowd Atlassian JIRA Confluence Trello Box Pipedrive SuccessFactors HR NutShell Insightly Egnyte SugarCRM Oracle IDCS Statuspage Zendesk Sell Workbooks DocuSign Citrix ShareFile Zendesk Microsoft Entra ID Google Workspace Concur Tableau GoToMeeting Coupa AWS Cognito Okta DataDog Hideez Opsgenie Informatica Cloud Services AppDynamics Marketo Workday HR OneLogin PingOne Aha! SAP Litmos HackerRank Slack ActiveCampaign Webex Apigee Databricks Hive PagerDuty Dayforce Smartsheet Pingboard SAP Cloud for Customer Azure Infrastructure Oracle Fusion Cloud Majesco LuccaHR OpenText JFrog Artifactory xMatters Discourse Testrail ChipSoft PingOne Platform Azure DevOps UKG PRO Atlassian Cloud Appendix: Creating a service account in Google Workspace Appendix: Setting a trial account on Salesforce Registering the application, providing necessary permissions, retrieving Client Id and Client Secret from the Microsoft Entra ID tenant Generating a private key for service account in GoToMeeting Configuring AWS IAM connector to support entitlements for User and Group Configuring Box connector to support additional email IDs for users One Identity Manager E2E integration needs for Hideez connector Configuring custom attributes for ServiceNow v.1.0 Configuring custom attributes for Coupa v.1.0 Configuring custom attributes in connectors Disabling attributes Configuring a connector that uses the consent feature Synchronization and integration of Roles object type with One Identity Manager Synchronization and integration of Workspaces object type with One Identity Manager Synchronization and integration of Products object type with One Identity Manager User centric membership Creating multi-valued custom fields in One Identity Manager Synchronization and assignment of PermissionSets to Users with One Identity Manager Connectors that support password attribute in User object Connectors that do not support special characters in the object ID Creating an app for using SCIM on Slack Enterprise Grid Organization Creating a Webex integration application, providing necessary scopes, retrieving Client Id and Client Secret Retrieving the API key from Facebook Workplace Outbound IP addresses Values for customer-specific configuration parameters in Workday HR connector Initiate an OAuth connection to SuccessFactors Creating custom editable/upsertable attributes in Successfactors employee central Custom Foundation Objects in Successfactors HR connector Configuring additional datetime offset in connectors How to Create custom attribute for Users in SuccessFactors portal SAP Cloud for Customer - Steps to add custom fields at One Identity Manager attributes Creating a Service Principal for the Azure Infrastructure Connector Workday permissions needed to integrate via the Starling Connector Configuring integration application in DocuSign Creating integration Connect Client in Coupa Retrieving Azure DevOps Personal Access Token (PAT) Setup integration system and field override service in Workday Retrieving Atlassian Cloud API Key and Directory ID Retrieving Tableau Personal Access Token (PAT)

Configuring User centric membership for AccountGroups

This section describes the procedure to configure User centric membership for Groups in Synchronization Editor.

To configure User centric membership for AccountGroups

  1. Create the new schema class UCIGroup(AccountGroups), with UCIGroup Schema type, using the details provided in the table:
    Table 462: New Schema class UCIGroup(AccountGroups) for AccountGroups
    Field Value
    Schema Type UCIGroup
    Display Name UCIGroup(AccountGroups)
    Class Name UCIGroup_AccountGroups
    Description UCIGroup_AccountGroups
    System Objects --> Condition ResourceType = AccountGroups

    NOTE: Synchronization Editor is used to create a new schema class. For more information, see Creating a new schema class using Synchronization Editor.

  2. Create the new schema class UCIUserInGroup(AccountGroups), with Schema typeUCIUserInGroup, using the details provided in the table:
    Table 463: New schema class UCIUserInGroup(AccountGroups) for AccountGroups
    Field Value
    Schema Type UCIUserInGroup
    Display Name UCIUserInGroup(AccountGroups)
    Class Name UCIUserInGroup_AccountGroups
    Description UCIUserInGroup_AccountGroups
    System Objects --> Condition UID_UCIGroup <> 'leave it as empty'

    System filter

    		 UID_UCIGroup in (select UID_UCIGroup from UCIGroup where ResourceType = 'AccountGroups')
  3. Click Commit to database in the Synchronization Editor.

    The new schema classes are created and the changes are saved.

  4. Navigate to Target system and click Update schema to perform a schema update (if AccountGroups is not exposed).
  5. Create mappings for AccountGroups.

    To create mappings for AccountGroups:

    1. In the Navigation pane, select Mappings | User.
    2. Click + to create a new mapping.
    3. In the New mapping window:
      1. In the General section, enter the values in fields as shown in the table

        Table 464: Create new mapping for AccountGroups - General section
        Field Value
        Mapping name AccountGroups
        Mapping direction Both directions

        NOTE: Select the option Maps objects referenced by multiple references.

      2. In the Relation section, enter the values in fields as shown in the table
        Table 465: Create new mapping for AccountGroups - Relation section
        Field Value
        One Identity Manager schema class UCIGroup(AccountGroups)
        Target system schema class AccountGroups (all)
      3. Click Ok and click Next.
    4. In the Mapping Wizard:
      1. In the Select task section, select the template Create rules based on template, click Next and click Finish.
      2. In the Select source mapping section, select Group and click Next.
      3. In the Analysis result section, select a new rule ConanicalName <-> vrtcononicalName from the suggestion list.

        The new mapping rule ConanicalName <-> vrtcononicalName is displayed in the Property mapping rules section in the Schema property in One Identity Manager list.

  6. Create Initial Synchronization workflow for AccountGroups.

    To create Initial Synchronization workflow for AccountGroup

    1. In the Navigation pane, select Workflow| Initial Synchronization.
    2. In the Initial Synchronization page, in the Workflow section, click + to add a new step.
    3. In the Create Synchronization step window, in the General tab, select the values as shown in the table below:
      Table 466: Create synchronization step
      Field Value
      Name UserGroups
      Mapping UserGroups
      Synchronization direction One Identity Manager
      Revision filtering Use revision filter
      Exception handling Use workflow default
    4. In the Processing tab, select the values in the same way that they are set in the Processing tab for the User workflow and click Ok.
    5. Click Commit to database and click Ok.

      The AccountGroups workflow is displayed in the Workflow section.

  7. Create Provisioning workflow for AccountGroups.

    To create Provisioning workflows for AccountGroups.

    1. In the Navigation pane, select Workflow| Provisioning.
    2. In the Provisioning page, in the Workflow section, click + and click Ok.
    3. In the Create Synchronization step window, in the General tab, select the values as shown in the table below:
      Table 467: Create synchronization step
      Field Value
      Name AccountGroups
      Mapping AccountGroups
      Synchronization direction Target system
      Revision filtering Use workflow default
      Exception handling Use workflow default
    4. In the Processing tab, select the values in the same way that they are set in the Processing tab for the User workflow and clcik Ok.
    5. Click Commit to database and click Ok.

      The AccountGroups workflow is displayed in the Workflow section.

  8. Create <vrtMembers> property for AccountGroups

    Add vrtMembersAccountGroups parameter with M:N type schema type with the below configuration.

    To add the virtual parameters:

    1. Select Mappings| User.
    2. Select + in the User pane to create a property.
    3. In the Create property window, from the Property type list, select Members of M:N schema types .
    4. Enter the following values in the fields mentioned in the table, and select the options listed below:
      Table 468: Virtual parameters
      Field/ Option Value
      Name vrtMembersAccountGroup
      Display name AccountGroupMembers

      Select the following options:

      • Ignore case
      • Try to mark the objects for deletion (outstanding)
    5. In the M:N schema types section at the bottom of the window, select select UCIUserInGroup(AccountGroups), UID_UCIUser, and UID_UCIGroup.
    6. In the Members UCIGroup section, select ObjectGUID .

      NOTE: Select UCIUserInGroup(AccountGroups) schema type for vrtMembersAccountGroups parameter.

    7. Click Ok.
  9. Create mapping for accountGroups~value as shown below with mapping direction.

    To create mappings:

    1. Select Mappings| User.
    2. Select vrtMembersGroup in the User pane.
    3. Create mappings for AccountGroups under User object.

      NOTE: You can create a mapping by dragging the property vrtMembersAccountGroups in the UCIUser pane and dropping it to the property accountGroups~value in the SCIMUser pane.

    4. Click Commit to database to save the changes.

Creating a new column in UCIUser table and CSMUser table using Extension Tool

This section describes the steps that you must perform in Schema Extension tool to configure User centric membership. You must create a new column in the tables:

Creating a new column in UCIUser table

To create a new column in UCIUser table

  1. Launch Schema Extension.
  2. Select Extend Table.
  3. Select UCIUser.

  4. Create a column named CCC_XDateSubItem of type Date in the UCIUser table.

    To create a column in the UCIUser table

    1. In the Configure columns window, click +.
    2. In the Create new column window, enter the details as required and click Next.
    3. In the Date type column, select Date and click Next.
    4. Select the required permissions and click Next
      • Read and write permissions
      • Read only permissions
    5. Select the option No change label and click Next.

      System changes are displayed in the Systems modifications window and you can export them to a file if required.

    6. Click Next and save the changes to the database and compile the database changes.
    7. Click Finish after compilation.

Creating a new column in CSMUser table

To create a new column in CSMUser table

  1. Launch Schema Extension.
  2. Select Extend Table.
  3. Select CSMUser.

    NOTE:

    • Now, repeat step 4 from the procedure To configure User centric membership using Schema Extension for UCIUser. Replace all instances of UCIUser with CSMUser.
    • To see the changes in Synchronization Editor Mapping properties of User object, navigate to Synchronization Editor -> Select SCIM project (which you created) -> One Identity Manager Connection -> Update Schema in General Window -> Commit to database.

NOTE: After you perform the above steps in Schema Extension, see Configuring User centric membership using Designer

Creating custom process using Designer

This section describes the steps that you must perform in Designer to configure User centric membership. You must a custom process UCI_UserInGroup_Custom on the UCIUserInGroup table

To configure User centric membership using Designer

  1. Launch Designer.

  2. Create a custom process UCI_UserInGroup_Custom on the UCIUserInGroup table.

    To create a custom process

    1. In the Navigation pane, select Process Orchestration |Custom process| Navigation| Process Editor| Create a new process.
      The Process properties window is displayed.
    2. In the General tab of the Process properties window, enter the following values:
      Table 469: Values for creating custom process for Group

      Process properties

      Value

      Name

      UCI_UserInGroup_Custom

      Table

      UCIUserInGroup

  3. Add Insert and Delete events for the process.
    To add Insert and Delete events for the process

    1. In the Events tab, at the bottom of the page, click +.
      The Edit event window is displayed.
    2. In the Edit event window, click + next to the Object Event field.
      The Edit object event window is displayed.
    3. In the Edit object event, select Delete and then select Insert from the list. Click OK.
      Delete and Insert are displayed in the Events window.

  4. Create another process Patch DPRMembershipaction, which can run as sub process of UCI_UserInGroup_Custom.

    NOTE: To create a sub process, right click in the process window and clcik New.

  5. In the Process step properties window, select the values as follows:

    1. In the General tab,
      1. in the Name field, enter the value Patch DPRMembershipaction.
      2. in the Process task field, enter the value SQLComponent - Execute SQL.
    2. In the Generation tab, set server function value to SQL processing server.
    3. Navigate to the Parameters tab at the bottom of the window, and set the parameter SQLStmt to the following value using the Edit parameters window:
      Dim f As ISqlFormatter = Connection.SqlFormatter
      Value = "update DPRMemberShipAction set ObjectKeyBase = ObjectKeyMember, ObjectKeyMember = ObjectKeyBase where " & _
      f.Comparison("ObjectKeyMN",
      $XObjectKey$,ValType.String,CompareOperator.Equal)

  6. Create a link between process UCI_UserInGroup_Custom to Patch DPRMembershipaction.

    NOTE: You can drag and drop from the parent process to the child process to create a link between the two processes.

  7. Create another sub process for Patch DPRMembershipaction.

    In the Process step properties window, select the values as follows:

    1. In the General tab,

      1. in the Name field, enter the value Set CCC_XDateSubItem.
      2. in the Process task field, enter the value HandleObjectComponent - Update.
      3. in the Priority field, set the priority.
    2. In the Generation tab, set server function value to SQL processing server.
    3. Navigate to the Parameters tab at the bottom of the window, and
      1. set the parameter the following parameters to the values given below using the Edit parameters window:
        Object type: Value = "UCIUser"
        WhereClause:
        Dim f As ISqlFormatter = Connection.SqlFormatter

        Value = f.UidComparison("UID_UCIUser", $UID_UCIUser$)
      2. enable any of the val_Property* by double-clicking it, and then rename the property name to val_CCC_XDateSubItem and set Value = Now() using the Edit paramaters window.
  8. Create a link between the processes Patch DPRMembershipaction and Set CCC_XDateSubItem.

    NOTE: You can drag and drop to create a link between the two processes.

    1. Create a custom script to avoid running UCI_UCIGroup_update job chain for <connector_name> connector.

      To create a custom script, in the Navigation pane, select Script Library |Custom script|Create a new script using the following details:

      Name: UCI_TargetUsers<connector_name>_Custom

      Add below function with code

      Public Function UCI_TargetUsers<connector_name>_Custom (UID_UCIRoot As String) As Boolean

      Dim f As ISqlFormatter = Connection.SqlFormatter

      Dim UCIRoot<connector_name>Display = Connection.GetSingleProperty("UCIRoot", "DisplayName", f.UidComparison("UID_UCIRoot", UID_UCIRoot, CompareOperator.Equal))

      If UCIRoot<connector_name>Display.ToString().ToLower().Contains("<connector_name>") Then

      Return True

      End If

      Return False

      End Function

  10. Navigate to Process Orchestration| Process| UCI_UCIGroup_Update.

  11. In the Process properties window, in the General tab, add the condition
    Not UCI_TargetUsers<connector_name>_Custom($UID_UCIRoot$) AndAlso _

  12. Click Commit to database.

  13. Click Compile the Database.
  14. In the Compilation settings window, select script including all dependencies and click Next.

 

Creating multi-valued custom fields in One Identity Manager

This section describes the procedure to create multi-valued custom fields in One Identity Manager.

To create multi-valued custom fields in One Identity Manager

  1. Create a custom column in the respective User tables in the database.

    1. Create a custom column in CSMUser table.

      To create a custom column in CSMUser table

      1. Open SchemaExtension. exe.
      2. In the Select Method window, select Extend table and click Next.
      3. In the Extend table window, select CSMUser table and click Next.
      4. In the Configure columns window, click Create New column (+).
      5. In the Create new column window, enter a name for the column. For example: RolesID.
      6. Enter a display name for the column to be displayed in Manager.exe.
      7. In the Configure columns window, select the data type as string from the Data type list and click Next.
      8. In the Access permissions window, add appropriate permissions and click Next.
      9. Click Finish after the compilation is done.

      10. Repeat the steps for all custom columns that you have to create. For example: RolesName, WorkspaceID, and WorkspaceName.

    2. Create a custom column in UCIUser table.

      To create a custom column in UCIUser table

      1. Repeat the steps that you performed for creating a custom column in CSMUser table.

      2. Ensure that you use the same column name and other details used when you created a custom column in CSMUser table.

  2. Change the created custom column to multi-value in both the tables.

    1. Change the created column in CSMUser table to multi-value.

      To change the created column in CSMUser table to multi-value

      1. Open Designer.exe.

      2. Select One Identity Manager Schema in the left pane.

      3. Click Show Table Definition.

      4. Select CSMUser.

      5. Select the created custom column.

      6. Select the More tab.

      7. Select multi-value column and click Finish.

      8. Select Commit to database.

      9. Select Compile Database.

    2. Change the created column in UCIUser table to multi-value.

      To change the created column in UCIUser table to multi-value, repeat the steps that you performed for CSMUser table.

  3. Create custom mappings and add directions accordingly.

    1. Add mappings for each custom field created.

    2. Add the mapping directions accordingly.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating