Zoomdata Version

Managing MySQL Connectors

The MySQL connector allows users to visualize data stored in MySQL databases. Zoomdata supports MySQL versions 5.6 and later.

The MySQL connector requires a JDBC driver to be configured before you can connect to your data source. You can download the driver from the vendor's site. If you are upgrading, keep in mind you need to configure the JDBC driver - see Upgrading Zoomdata Server to v2.5 for instructions. For more information and steps, see Adding a JDBC Driver .

The table below lists information on the features that are supported by MySQL.

Supports Distinct Count? Yes
Supports Live Mode/ Playback? Yes
Supports Group-by Time? Yes
Supports Multi Group-by Charts? Yes
Supports Histogram? No
Supports Box Plot? No
Custom SQL Capable? Yes
Supports Last Value? No
Supports Partition? No

 

Managing your mysql connectors

When setting up a connection to MySQL, you must provide the following.

  • Specify the JDBC URL. The JDBC URL format for MySQL database being connected must be as follows: jdbc:mysql://MYSQLHOST:port/mydatabase .
    If authentication has been set up, provide the User Name and Password.

Chart Settings for MySQL

On the Charts page, you can:

  1. Edit Global Default Settings .
  2. Select the Standard and, if available, Custom chart styles to be used with the data source.
  3. Set default parameters (group, sub-group, colors, sorting, and so on) for each chart style.

Select Finish to save your changes. Once your data connection has been established, it will be listed under  My Data Sources.

Was this topic helpful?