지금 지원 담당자와 채팅
지원 담당자와 채팅

Active Roles 7.4.1 - 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 Exchange Server Working with Active Roles Working with One Identity Manager Working with a delimited text file Working with Microsoft SQL Server Sample queries to modify SQL Server data Working with an OLE DB-compliant relational database Working with SharePoint Working with Microsoft Office 365 Working with Microsoft Azure Active Directory
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 Appendix C: Working with RACF connector

Appendix C: Working with RACF connector

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

The following example shows how RACF dataset information can be synchronised. RACF dataset names contain asterisk characters and as such cannot be synchronised to AD 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.

Create SQL Database and Table

Using Microsoft SQL Server Manager, create a database called 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 RACF Datasets and click OK.

  4. Click on the 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 RACF connector and click Finish.

  3. The object type in the Target object system field is populated automatically by One Identity Quick Connect 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 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 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 RACF connector and click Finish.

  8. The object type in the Target object system field is populated automatically by One Identity Quick Connect 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 RACF Attribute
    Owner racfOwner
    UACC racfUacc
    Create_Group racfCreateGroup

    Audit

    racfAudit

    UID

    racfDataset
  14. Click OK.
  15. Click Finish to complete the synchronization.
관련 문서