Add a Cassandra database connection
You can add a connection to a Cassandra 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 Cassandra Connection type, the rest of the connection properties appear.
Depending on your choice of authentication mechanism, you may use different properties.See Connection properties for details, defaults, and examples.
- Connection name
-
Name your connection.
- Connection type
-
Choose the Cassandra connection type.
- Host
-
Specify the hostname or the IP address of the Cassandra system.
- Port
-
Specify the port associated to the Cassandra system.
- User
-
Specify the user to connect to Cassandra. This user must have data access privileges.
- Password
-
Specify the password for the User.
- 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.
- KDC host
-
Specify KDC Host Name where as KDC (Kerberos Key Distribution Center) is a service than runs on a domain controller server role. For Kerberos authentication only.
- User keytab
-
To authenticate via a key-tab you must have supporting key-tab file which is generated by Kerberos Admin and also requires the user principal associated with Key-tab (Configured while enabling Kerberos). For Kerberos authentication only.
- Default realm
-
A Kerberos realm is the domain over which a Kerberos authentication server has the authority to authenticate a user, host or service. For Kerberos authentication only.
- Kerberos service KDC
-
Specify the Kerberos KDC of the service. For Kerberos authentication only.
- Kerberos service realm
-
Specify the Kerberos realm of the service. For Kerberos authentication only.
- Kerberos SPN
-
Specify the service principal name (SPN) for the Kerberos Domain Controller. For Kerberos authentication only.
- LDAP user
-
Specify the default LDAP user used to connect to and communicate with the server, it must be set if the LDAP server do not allow anonymous bind. For LDAP authentication only.
- LDAP password
-
Specify the password for the LDAP User. For LDAP authentication only.
- LDAP server
-
Specify the host name or IP address of the LDAP server. For LDAP authentication only.
- LDAP port
-
Specify the port number that is associated to the LDAP server. For LDAP authentication only.
- Search filter
-
Specify the search filter for looking up usernames in LDAP. For LDAP authentication only.
- Search base
-
Specify the search base for the LDAP server, used to look up users. For LDAP authentication only.
- Trust store path
-
Specify the TLS/SSL client certificate store for SSL Client Authentication (2-way SSL). For SSL authentication only.
- Trust store password
-
Specify the password for the TLS/SSL client certificate. For SSL authentication only.
- Certificate type
-
Specify the type of key store containing the TLS/SSL client certificate. For SSL authentication only.
- Certificate subject
-
Specify the subject of the TLS/SSL client certificate. For SSL authentication only.
- JDBC options
-
Specify the options associated with the JDBC URL.
- Row scan depth
-
The maximum number of rows to scan to look for the columns available in a table. Set this property to gain more control over how the provider applies data types to collections.
-
Click Create connection.
