Configure authentication through Active Directory
ThoughtSpot enables you to set up integration with LDAP using Active Directory. After successful setup, you can authenticate users against a secure LDAP server.
|This article describes how to set up integration with LDAP using Active Directory. Starting with ThoughtSpot version 6.0.5, ThoughtSpot also integrates with OpenLDAP for user authentication. LDAP provides security and makes user management more centralized. To enable user authentication through OpenLDAP, contact ThoughtSpot Support.|
Before you configure ThoughtSpot for Active Directory, collect the following information:
Required to connect to Active Directory.
Default domain under which users who want to be authenticated against Active Directory reside. When a user logs in with a username, the default domain is added to the username before sending it to the LDAP server. If users reside in multiple sub-domains, you can still designate one of them as the default. Authentication against multiple domains is not supported.
Users who don’t belong to the default domain must explicitly qualify their username when they log in.
LDAP search base. The scope of searching user information, like email and Display name, within AD.
If you want to use SSL, you must obtain the SSL certificate from an issuing authority.
If AD servers are behind a load balancer, you must procure the SSL certificate to identify ThoughtSpot to the load balancer. The communication after the load balancer is non-secure. ThoughtSpot does not support a scenario where multiple AD servers provide their own SSL certificates.
Automatically add LDAP or AD users in ThoughtSpot? (yes/no)
If you choose 'yes', new users are automatically created within ThoughtSpot when successfully authenticated against AD. ThoughtSpot doesn’t cache passwords for AD-authenticated users.
If you choose 'no', users have to be manually created with a dummy password as a placeholder in ThoughtSpot before they can log in.
The username you specify when creating the LDAP-authenticated user manually in ThoughtSpot has to be domain qualified, for example:
In order to log in to ThoughtSpot, the user has to exist in ThoughtSpot independent of whether that user is authenticated against AD or against ThoughtSpot’s internal authentication.
Also use ThoughtSpot internal authentication? (yes/no)
If you choose 'yes', ThoughtSpot will first attempt to authenticate the user against AD. If that attempt fails, it will then attempt to authenticate the user as an internal/local ThoughtSpot user. If either of these succeed, then the user is successfully logged in. This is useful in scenarios where some users are not in AD and are created only in ThoughtSpot.
Configure LDAP using tscli
You do not have to create a user called
tsadmin on your LDAP server.
Internal authentication can be used for
To configure AD based authentication, follow these steps:
Log in to the Linux shell using SSH.
Run the command to configure AD authentication:
$ tscli ldap configure
Answer the prompts using the information you collected under Before you begin section. For example:
Choose the LDAP protocol:  Active Directory Option number: 1 Configuring Active Directory URL to connect to Active Directory. (Example: ldap://ad.yourdomain.local:389): ldaps://ad.yourdomain.local:636 Default domain (Example: ldap.thoughtspot.com): yourdomain.local Use SSL (LDAPS) (y/n): n LDAP search base (Example: cn=Users): cn=Users,ou=orgunit,dc=youdomain,dc=local Automatically add LDAP users in ThoughtSpot (y/n): y Also use ThoughtSpot internal authentication (y/n): y
If you are using SSL, add the SSL certificate for AD.
If you want to remove the AD configuration, issue the following command:
$ tscli ldap purge-configuration
As you develop your expertise in authentication and security, we recommend the following ThoughtSpot U course: - Active Directory
See other training resources at ThoughtSpot U.