Chat now with support
Chat with Support

Active Roles On Demand Hosted - Synchronization Service Administration Guide

Synchronization Service Overview Deploying Synchronization Service Getting started Connections to external data systems
External data systems supported out of the box
Working with Active Directory Working with an AD LDS (ADAM) instance Working with Skype for Business Server Working with Oracle 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 IBM DB2 Working with IBM AS/400 Working with an OpenLDAP directory service Working with IBM RACF connector Working with MySQL database Working with an OLE DB-compliant relational database Working with SharePoint Working with Microsoft Office 365 Working with Microsoft Azure Active Directory Working with SCIM
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 Appendix A: Developing PowerShell scripts for attribute synchronization rules Appendix B: Using a PowerShell script to transform passwords

Create 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.

Provisioning 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 Workflow tab.

  2. Click Add sync workflow.

  3. Enter IBM RACF Datasets and click OK.

  4. Click on the IBM RACF Datasets workflow.

  5. Click on Add synchronization.

  6. Click Creation and then Next.

  7. From the Source connected system section, 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.

  1. Click Next.

  2. In the Target connected system field, click Specify and then locate your IBM RACF connector and click Finish.

  3. The object type in the Target object system field is populated automatically by Synchronization service to racfUser. Change this to racfDataset.

  4. Click Next.

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

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

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

  8. 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
  9. Click OK.
  10. Click Finish to complete the synchronization.

Updating datasets

To synchronize Microsoft SQL attribute(s) to IBM RACF follow the steps provided here.

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.

Deprovisioning datasets

To deprovision the datasets follow the steps provided here.

To deprovision datasets

  1. Navigate to the Workflows tab and select IBM RACF Datasets.

  2. Click Add synchronization step.

  3. Click Deprovision and then click Next.

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

  5. Select your SQL Server Connector and click Finish.

  6. Select Source object is deleted or is out of synchronization scope option in the Deprovision target objects if section.

  7. Optionally, configure the Source object meets the following criteria.

  8. Click Next.

  9. In the Target connected system field, click Specify and then locate your IBM RACF connector and click Finish.

  10. The object type in the Target object system field is populated automatically by Synchronization service to racfDataset.

  11. Click Next.

  12. Select Delete target object.
  13. Click Finish to complete the synchronization.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating