Add a Vertica database connection
You can add a connection to a Vertica 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 Vertica 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 Vertica connection type.
- Host name
-
Specify the hostname or the IP address of the Vertica system
- Port
-
Specify the port associated to the Vertica system
- User
-
Specify the user id that will be used to connect to the Vertica system. This user should have necessary privileges to access the data in the databases.
- Password
-
Specify the password for the User
- Database
-
Collection of information that is organized so that it can be easily accessed, managed, and updated.
- SSL encryption
-
To ensure the data is encrypted use additional security feature such as SSL.
- Trust store
-
Specify the TLS/SSL client certificate store for SSL Client Authentication (2-way SSL)
- Trust store password
-
Specify the password for the TLS/SSL client certificate.
-
Click Create connection.
