Skip to main content
The Self-Service Analytics MemSQL connector lets you access the data available in MemSQL databases using the Self-Service Analytics client. The Self-Service Analytics MemSQL connector supports MemSQL versions 7.1 - 7.6. Before you can establish a connection from Self-Service Analytics to MemSQL storage, a connector server needs to be installed and configured. See Manage Connectors and Connector Servers for general instructions and Connect to MemSQL for details specific to the MemSQL connector. After setting up the connector, create data sources that specify the necessary connection information and identify the data you want to use. See Create and Manage Data Sources for more information. After you set up your data sources, create dashboards, self service reports, and visuals from the data in these data sources.

​
Feature Support

Connector support for specific features is shown in the following table. Key: Y - Supported; N - Not Supported; N/A - not applicable

​
Connect to MemSQL

The MemSQL connector requires a JDBC driver to be configured before you can connect to your data source.
  1. Download and install the latest JDBC driver from https://dev.mysql.com/downloads/connector/j/. Instructions are provided on that website.
  2. After installing the driver, edit the MemSQL properties file and change the driver path and class name properties, as shown below and as described in Add a JDBC Driver:
  3. Save the properties file and restart the connector. See Add a JDBC Driver.