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.
The IBM RACF connector can be used to run any command in the Time Sharing Option (TSO) environment on the target IBM mainframe. The LDAPX exit must be installed and configured for this functionality to be supported.
The TSO command is run using an Active Roles synchronization step to create an object of type ldapxtsocmd on the target IBM RACF system and supplying the name of the TSO command or script to be run in the attribute racfprogrammername. When the step is run, the IBM RACF connector intercepts the create command and instead sends an LDAP search command with the required parameters via the LDAP protocol.
The LDAPX exit intercepts this request, extracts the TSO command information and runs the command. The LDAP response is constructed, containing the results obtained from running the command. The IBM RACF connector receives this LDAP response, extracts the results and saves them in a text file that can be examined later.
No object is created during the synchronization step so it can be run indefinitely, each time executing the TSO command stored in the racfprogrammername attribute from the same or any other synchronization step.
The following example shows a method of issuing a TSO command using synchronisation from Active Directory (AD).
-
Using Active Directory Users and Computers, create a container in AD that can be filtered on by the ARSS. For example, create an organisational unit container called TSO Commands.
-
Create a dummy computer object within this container with name TSOCMD and description field set to the string STATUS. The TSO command STATUS will return the current system status.
-
Create a workflow called Run TSO Command.
-
Within this workflow, create a synchronization step item as follows:
-
Synchronization step type: Create
-
Source object: Active Directory, specified container as created above, name starts with TSOCMD.
-
Target connector: IBM RACF
-
Object type: ldapxtsocmd
-
Mapping: from AD Description attribute to IBM RACF racfprogrammername attribute
-
Save the step.
-
Run the synchronization step. There should be one item to be created with the following properties:
-
Perform the synchronization step.
-
The LDAP command will be sent and interpreted by the LDAPX exit to run the TSO command.
-
Once complete, the synchronization step will show as being successful.
-
The output from running the command can be found in the following text file:
<ARSS installation folder>\SyncService\TSOCommandOutput\YYDDMM.txt, where, YYMMDD represents the date when the command was run.
-
The text file will contain the output returned from IBM RACF having run the STATUS command.
-
Multiple commands run on the same day will have their output appended to the same daily text file.