Chat now with support
Chat with Support

Active Roles 8.1.5 - Synchronization Service Administration Guide

Synchronization Service overview Deploying Synchronization Service Deploying Synchronization Service for use with AWS Managed Microsoft AD Getting started Connections to external data systems
External data systems supported with built-in connectors
Working with Active Directory Working with an AD LDS (ADAM) instance Working with Skype for Business Server Working with Oracle Database Working with Oracle Database user accounts Working with Exchange Server Working with Active Roles Working with One Identity Manager Working with a delimited text file Working with Microsoft SQL Server Working with Micro Focus NetIQ Directory Working with Salesforce Working with ServiceNow Working with Oracle Unified Directory Working with an LDAP directory service Working with an OpenLDAP directory service Working with IBM DB2 Working with IBM AS/400 Working with IBM RACF Working with MySQL database Working with an OLE DB-compliant relational database Working with SharePoint Working with Microsoft 365 Working with Microsoft Azure Active Directory Configuring data synchronization with the SCIM Connector Configuring data synchronization with the Generic SCIM Connector
Using connectors installed remotely Creating a connection Renaming a connection Deleting a connection Modifying synchronization scope for a connection Using connection handlers Specifying password synchronization settings for a connection
Synchronizing identity data Mapping objects Automated password synchronization Synchronization history Scenarios of use Developing PowerShell scripts for attribute synchronization rules Using PowerShell script to transform passwords

Example of mapping for dataset information

The IBM RACF connector can be used to synchronize IBM RACF dataset information. The LDAPX exit must be installed and configured for this functionality to be supported.

The examples in this topic shows how IBM RACF dataset information can be synchronized. IBM RACF dataset names contain asterisk (*) characters and as such cannot be synchronized to Active Directory which does not allow asterisk characters in names. As such, the example shows a synchronization to a Microsoft SQL database. It is assumed that Microsoft SQL Server and Microsoft SQL Server Manager have been installed and configured.

Creating SQL database and table

Using Microsoft SQL Server Manager, create a database called IBM RACF_Datasets. Within that database, create a table called Datasets with the following columns:

Column Name

Data Type

Audit

 nchar(100)

Create_Group

nchar(10)

Owner

nchar(10)

UACC

nchar(10)

UID (database key)

nchar(100)

Create a connection to this database and table with the ARSS Microsoft SQL Server Connector.

Povisioning datasets

To synchronize the SQL table to IBM RACF follow the steps provided here.

To synchronize the SQL table to IBM RACF

  1. Navigate to the Workflows tab.

  2. Click Add sync workflow.

  3. Enter IBM RACF Datasets and click OK.

  4. Click IBM RACF Datasets workflow.

  5. Click Add synchronization step.

  6. Click Creation and then Next.

  7. From the Source connected system section and click Specify.

  8. Select your Microsoft SQL Server Connector and click Finish.

    The SQL source object type is currently set to sql-Object. Do not change this value.

  9. Click Next.

  10. In the Target connected system field, click Specify and then locate your IBM RACF connector and click Finish.
  11. The object type in the Target object system field is populated automatically by Synchronization Service to racfUser. Change this to racfDataset.

  12. Click Next.

  13. In the Specify provisioning rules section, click Forward Sync Rule.
  14. In the Source attribute field, click Attribute locate UID and click OK.
  15. In the Target attribute field, click Attribute, locate racfDataset and click OK.

  16. Repeat these steps so that the following five items are mapped:

    SQL Attribute

    IBM RACF Attribute

    Owner

    racfOwner

    UACC

    racfUacc

    Create_Group

    racfCreateGroup

    Audit

    racfAudit

    UID

    racfDataset

  17. Click OK.

  18. Click Finish to complete the synchronization.

Updating datasets

To synchronize the SQL table to IBM RACF

  1. Navigate to the Sync Workflows tab, select IBM RACF Datasets and click OK.

  2. Click Add synchronization step.

  3. Click Update and then click Next.

  4. From the Source connected system section and click Specify.

  5. Select your Microsoft SQL Server Connector and click Finish.

    The SQL source object type is currently set to sql-Object. Do not change this value.

  6. Click Next.

  7. In the Target connected system field, click Specify and then locate your IBM RACF connector and click Finish.
  8. The object type in the Target object system field is populated automatically by Synchronization Service to racfUser. Change this to racfDataset.

  9. Click Next.

  10. In the Specify provisioning rules section, click Forward Sync Rule.

  11. In the Source attribute field, click Attribute locate UID and click OK.

  12. In the Target attribute field, click Attribute, locate racfDataset and click OK.

  13. Repeat these steps so that the following five items are mapped:

    SQL Attribute

    IBM RACF Attribute

    Owner

    racfOwner

    UACC

    racfUacc

    Create_Group

    racfCreateGroup

    Audit

    racfAudit

    UID

    racfDataset

  14. Click OK.

  15. Click Finish to complete the synchronization.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating