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 Azure AD 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 Azure AD 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

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 465: 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

  9. Navigate to Process Orchestration| Process| UCI_UCIGroup_Update.
  10. In the Process properties window, in the General tab, add the condition
    Not UCI_TargetUsers<connector_name>_Custom($UID_UCIRoot$) AndAlso _

  11. Click Commit to database.

  12. Click Compile the Database.
  13. 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.

Synchronization and assignment of PermissionSets to Users with One Identity Manager

This section describes the synchronization and assignment of PermissionSets to Users with One Identity Manager.

To synchronize and assign PermissionSets to Users with One Identity Manager

For more information, see

  1. Creating mapping for PermissionSets using Synchronization Editor
  2. Creating a Process Chain using Designer
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating