Zoomdata Version

Managing SQL Server Connectors

Zoomdata's SQL Server connector lets you access the data available in this SQL query engine for visualization and exploration within the Zoomdata Client. Zoomdata supports SQL Server 2012 and later versions.

Versions prior to Zoomdata 2.6.5 required a JDBC driver to be configured before connecting to your data source. As of Zoomdata 2.6.5, it is no longer necessary to provide a separate JDBC driver. If needed for prior releases, 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.6 for instructions. For more information and steps, Adding a JDBC Driver .

The table below lists information on the features that are supported by SQL Server:

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

As of Zoomdata 2.6.5, the SQL Server connector supports derived fields.

Managing your sql server connections

When establishing a connection to SQL Server, you need to provide the following.

  • Specify the connection name and JDBC URL. The JDBC URL for SQL Server database being connected, must be: jdbc:sqlserver//MYSQLSERVERHOST:PORT
    If authentication is required, provide the username and password.

Chart Settings for SQL Server

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 is listed under My Data Sources.

Was this topic helpful?