Skip to main content

Synchronize Active Directory groups

Synchronize ActiveDirectory groups

If you have imported Active directory groups into Tableau Server, You have to periodically sync them to get the users reflected to Tableau Server.


  1. Single-site: Click Settings> General.   For Multisite: In the site menu, click Manage All Sites and then click Settings> General.
  2. Scroll down the page to Active Directory Synchronization, and then select Synchronize Active Directory groups on a regular schedule.
  3. Select the frequency and time of synchronization.
  4. Click Save.




You can view the results of synchronization jobs in the Background Tasks for Non Extracts administrative view. Queue Active Directory Groups Sync is the task that queues and indicates the number of Sync Active Directory Group tasks to be run.


  1. Single-site: Click Status. For Multisite: In the site menu, click Manage All Sites and then click Status.
  2. Click the Background Tasks for Non Extracts link.
  3. Set the Task filter to include Queue Active Directory Groups Sync and Sync Active Directory Group.
  4. You can quickly navigate to this administrative view by clicking the View synchronization activity link in the Settings page for the server.


you can set the minimum site role for group users to be applied during Active Directory synchronization using Groups -Details Page.


  1. In a site, click Groups.
  2. On the Groups page, select a group.
  3. Click Actions > Minimum Site Role.
  4. Select the minimum site role, and then click Change Site 


Note: If you are removing a user from AD , The user will not be removed in Tableau. You have to manually delete the user from Tableau by reassigning the user content 

Tableau Backgrounder process is used for the AD Sync and in a serial operation.A parallel processing helps for better performance. To enable parallel backgrounder processing for group synchronization, open TSM CLI and enter the following commands:


tsm configuration set -k backgrounder.enable_parallel_adsync -v true
tsm pending-changes apply





Comments

Popular posts from this blog

Gateway port to use 80 to 443 on Tableau Server

Change Gateway port from 80 to 443 or 8080       To change the Gateway port from 80 to 443 then use below commands First , list your nodes with the command. tsm topology list-node  Then execute the command to set port  tsm topology set-ports --node-name node1 --port-name gateway:primary --port-value 443 The above command will ask for a restart.  Check ports using  tsm topology list-ports  If some error occurs in applying changes: try disabling (enable later) external ssl first- tsm security external-ssl disable You might need to run init command again with new port- tsm reset tabcmd initialuser --server localhost:443 --username 'ADMINUSER' --password 'adminpwd'

Creating Groups using Tableau API and Python Script

 Creating Tableau Groups using Python and API Prerequisites: Python on the machine tableauserverclient module API enabled on Tableau server. Permissions to update for the user Groups.csv file . list all groups in a csv file Changes to be made in the script for below lines in the script groups = open('<Filepath>/groups.csv') pat='getyourpersonaltoken' server = TSC.Server('http://myserver.tableau.com',use_server_version=True) tokenName = 'mytokenname' Script: import tableauserverclient as TSC import csv groups = open('<Filepath>/groups.csv') grp = csv.reader(groups) sourcegroups=[] createdgrps=[] pat='getyourpersonaltoken' server = TSC.Server('http://myserver.tableau.com',use_server_version=True) tokenName = 'mytokenname' ta = TSC.PersonalAccessTokenAuth(token_name=tokenName, personal_access_token=pat) with server.auth.sign_in_with_personal_access_token(ta):    groupslist, pagination_item  = server.groups.get() ...

Tableau dirty Backup

Steps for performing a dirty restore 1. Install Tableau Server 2019.1.0 on the Dev machine 2. Stop Tableau Server 3. Copy the following folders from the current production: D:\Tableau Server\data\tabsvc\pgsql D:\Tableau Server\data\tabsvc\dataengine 4. Update the pg_hba.conf D:\Tableau Server\data\tabsvc\config\pgsql_0.<version>/pg_hba.conf Change "md5" to "trust" for the user "tblwgadmin" like this: host    all         tblwgadmin         <address>/32          md5 to : host    all         tblwgadmin        <address>/32         trust 5. Regenerate the internal token: tsm security regenerate-internal-tokens [options] [global options] tsm pending-changes apply 6. Re-index tsm maintenance reindex-search 7. Make a proper backup: tsm maintenance backup -f myBackup At this point, we w...