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.
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.
To synchronize the SQL table to IBM RACF follow the steps provided here.
To synchronize the SQL table to IBM RACF
-
Navigate to the Workflows tab.
-
Click Add sync workflow.
-
Enter IBM RACF Datasets and click OK.
-
Click IBM RACF Datasets workflow.
- Click Add synchronization step.
-
Click Creation and then Next.
-
From the Source connected system section and click Specify.
-
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.
-
Click Next.
- In the Target connected system field, click Specify and then locate your IBM RACF connector and click Finish.
- The object type in the Target object system field is populated automatically by to racfUser. Change this to racfDataset.
-
Click Next.
- In the Specify provisioning rules section, click Forward Sync Rule.
- In the Source attribute field, click Attribute locate UID and click OK.
- In the Target attribute field, click Attribute, locate racfDataset and click OK.
-
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 |
-
Click OK.
-
Click Finish to complete the synchronization.
To synchronize the SQL table to IBM RACF
-
Navigate to the Sync Workflows tab, select IBM RACF Datasets and click OK.
-
Click Add synchronization step.
-
Click Update and then click Next.
-
From the Source connected system section and click Specify.
-
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.
-
Click Next.
- In the Target connected system field, click Specify and then locate your IBM RACF connector and click Finish.
- The object type in the Target object system field is populated automatically by to racfUser. Change this to racfDataset.
-
Click Next.
-
In the Specify provisioning rules section, click Forward Sync Rule.
-
In the Source attribute field, click Attribute locate UID and click OK.
-
In the Target attribute field, click Attribute, locate racfDataset and click OK.
-
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 |
-
Click OK.
-
Click Finish to complete the synchronization.