How to sync AD groups automatically ?

How to sync AD groups automatically ?

book

Article ID: KB0078969

calendar_today

Updated On:

Products Versions
Spotfire Statistica 13.0 and later versions

Description

The instructions below will help in automating the sync between Windows AD groups and Enterprise groups detailed here 

PREREQUISITES
User With permissions to create analysis configuration in Enterprise Manager (AADM) , User Admin (UADM) or System Administrator (SADM)
User Permissions to schedule analysis in WebStatistica (Member of SWS_BATCHABLE or SWS_ADMIN)
If adding users to SDMS, user should be part of System Administrators in SDMS. In context of WebStatistica, the domain user that the service is running as, should be part of SDMS System Administrators and should have permissions to read the script in Enterprise Manager. 

Issue/Introduction

This article details how AD groups can be configured to sync automatically

Resolution

1. Download the GroupSync.svb from the attachment and open this file in Statistica (while logged in as Enterprise user with permissions detailed above). For Statistica 13.5, download the script - GroupSync_13.5.svb. For later versions, this script will be included in [Statistica Install directory]\SupportScripts\ directory

2. Create a System View folder in Statistica Enterprise to deploy the script, if one doesn't exist already. In Statistica, click on Enterprise tab and then select Deploy to Enterprise >> Macro

     User-added image

3.  Select 'Deploy New Object' and OK. 

      User-added image

4. Select None for the data configuration and Click on OK.  Enter a name for the Script or click on OK to accept the default name. Select a folder to deploy the script and define the access permissions for the script.

User-added image
Click OK on the dialog that indicates that the object was successfully deployed

5. Option 1: Run the script interactively on-demand (Only partially automatic ) 
     Click on Run in the Enterprise Manager Analysis configuration that was deployed.
             User-added image

    This will generate a spreadsheet with details of which users were added, deleted from Enterprise group, added to SDMS group to sync with the Windows AD group.

      User-added image

NOTE: The script will only add users to SDMS Document administrators group. If a specific user needs to be made part of System administrator group for SDMS, this should be done manually.

Option 2: Schedule the script to run on a schedule via WebStatistica (a.k.a Statistica Server) Completely automated
   Schedule the analysis that we deployed in Enterprise at Step 4 as detailed here .  The scheduled task will run as per schedule chosen and the results of the scheduled task can be viewed by the user that scheduled the job in Statistica Server by selecting Tools>>My Batch jobs >>Results

User-added image

Attachments

How to sync AD groups automatically ? get_app
How to sync AD groups automatically ? get_app