Add a MemSQL database connection

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.