Learning BI and Data Analytics Tools

Creating Tableau Projects and child projects with Tableau API and Python Prerequisites: Python on the machine tableauserverclient module API enabled on Tableau server. Permissions to update for the user Projects.csv file . list all groups in a csv file. attached format . 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 Projects = open('filepath/projects.csv') prjt = csv.reader(Projects) projectstobe = list(prjt) sourceprojects =[] createdprjts = [] parentproj_id='' pr_perm = TSC.ProjectItem.ContentPermissions.ManagedByOwner pat = 'personalaccesstoken' server = TSC.Server('http://myserver.tableau.com', use_server_version=True) tokenName = 'mytokenname' ta = TSC.PersonalAccessToke...

 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() ...

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. Single-site: Click Settings> General.   For Multisite: In the site menu, click Manage All Sites and then click Settings> General. Scroll down the page to Active Directory Synchronization, and then select Synchronize Active Directory groups on a regular schedule. Select the frequency and time of synchronization. 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. Single-site: Click Status. For Multisite: In the site menu, click Manage All Sites and then click Status. Click the Background Tasks for Non Extracts link. Set the Task filter to include Queue Active Directory Gro...

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...

Server Management Add-on   Licensing Server Management Add-on is licensed on a per Deployment basis, which may be User-Based or Core-Based. A Deployment includes a licensed production Tableau Server installation and two licensed non-production Tableau Server installations that support the production installation. The Server Management Add-on can only be activated on a licensed Tableau Server Deployment Tools : Server Management has multiple tools like Resource Monitoring Tools(RMT) and Content Migration Tool (CMT). Resource Monitoring tool  Monitors the health of the server and identifies slow loads by analyzing logs and help in performance tuning. Proactive method to describe the issues. An agent runs on each of the nodes in your Tableau cluster to monitor their performance and activity.this Agent has to be installed on every machine that runs Tableau server processes. The Resource Monitoring Tool provides a web user interface for all of its ...

When Domain database password is changed from the database side, it needs to be updated in the nodemeta.xml file to start the Informatica services successfully. To update the domain database password, do the following: Backup nodemata.xml from INFA_HOME/isp/config. Go to the INFA_HOME/isp/bin directory and run following command: infasetup.sh updategatewaynode -dp new password     (for UNIX)infasetup.bat updategatewaynode -dp new password    (for WINDOWS)        3. Start the Informatica services. After Informatica Services are started and Informatica Administrator is up, the password for the PowerCenter Repository Service can be updated by editing the database properties of the repository in Admin console.

How to take Informatica Repository Backup  and restore it. Informatica Repository backup can be taken in 2 ways Admin Console pmrep command Using Admin Console Login to admin console. Select Repository service Select Backup contents under Actions menu to take backup of repository contents. Provide repository service username, password. provide a name for the backup that will create a backup file with .rep extension. the backup will be generally stored to infa_shared backup folder. Using pmrep command pmrep connect -r <repository_name> -d <domain_name> -n <user_name> -x <password> pmrep backup -o <output_file_name> [-d <description>] [-f (overwrite existing output file)] [-b (skip workflow and session logs)]  [-j (skip deploy group history)] [-q (skip MX data)] [-v (skip task statistics)] Restore Backup: Using pmrep command To restore a repository backup, it is to be ensured that the repository database ...