You can add a connection to a MemSQL database using ThoughtSpot DataFlow.

Follow these steps:

1. Click Connections in the top navigation bar.

2. In the Connections interface, click Add connection in the top right corner.

3. In the Create Connection interface, select the Connection type.

4. After you select the MemSQL Connection type, the rest of the connection properties appear.

   • Connection name
     Name your connection.
     
   • Connection type
     Choose the MemSQL connection type.
     
   • Platform type
     Specify the environment to execute the connection.
     
   • Host name
     Specify the hostname or the IP address of the MemSQL system
     
   • Port
     Specify the port associated to the MemSQL system
   • User
     Specify the user id that will be used to connect to the MemSQL system. This user should have necessary privileges to access the data in the databases.
   • 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.
   • Default realm
     A Kerberos realm is the domain over which a Kerberos authentication server has the authority to authenticate a user, host or service.
   • 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)
   • Principle
     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)
   • 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.
   • JDBC options
     Specify the options associated with the JDBC URL.

   See Connection properties for details, defaults, and examples.

5. Click Create connection.