Chatee ahora con Soporte
Chat con el soporte

Active Roles 7.4.3 - 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
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

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 synchronised. IBM 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 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.
Documentos relacionados