Add an SQL Server database connection
You can add a connection to an SQL Server database using ThoughtSpot DataFlow.
Follow these steps:
-
Click Connections in the top navigation bar.
-
In the Connections interface, click Add connection in the top right corner.
-
In the Create Connection interface, select the Connection type.
-
After you select the SQL Server Connection type, the rest of the connection properties appear.
See Connection properties for details, defaults, and examples.
- Connection name
-
Name your connection.
- Connection type
-
Choose the SQL Server connection type.
- SQL server type
-
Specify the SQL server type.
- Authentication type
-
Specifies the type of security protocol to connect to the instance. Based on the type of security, select the authentication type and provide details.
- Host
-
Specify the hostname or the IP address of the SQL Server system. Instance::Specify an instance with all SQL Server databases run by a single SQL Server service. When you select Named instance, Instance replaces the Port option.
- Port
-
Specify the port associated with the SQL Server system.
- User
-
Specify the user id that will be used to connect to the SQL Server system. This user should have necessary privileges to access the data in the databases.
- Password
-
Specify the password for the User. xref:dataflow-sql-server-reference.adoc#dataflow-sql-server-conn-aad-secure-principal-id[
- AAD secure principal id]
-
Specify the Azure Active Directory secure principal id.
- AAD secure principal secret
-
Specify the Azure Active Directory secure principal secret.
- Azure AD User
-
Select when you choose "Azure SQL database" under SQL server type.
- JDBC options
-
Specify the options associated with the JDBC URL.
-
Click Create connection.
