Zoomdata 5.4 Release Notes

The following enhancements and updates were made to Zoomdata in version 5.4. See the following topics:

Email salesteam@logianalytics.com to purchase Composer.

Connector Changes

The following connector changes were made in this release:

  • The Zoomdata PostgreSQL connector now supports PostgreSQL data stores running versions up to 12.1. In prior releases, the maximum was 11.1. See Managing the PostgreSQL Connector.

  • The Zoomdata Apache Solr connector now supports Apache Solr data stores running versions 6.6 to 8.4.1. In prior releases, the maximum supported version was version 8. See Managing the Apache Solr Connector.

  • The Zoomdata Microsoft SQL Server (MSSQL) connector now supports Microsoft SQL Server 2019 versions. The minimum supported version is still 10.5, but the maximum is 15.0.2000. In prior releases, 2008 R2 versions were supported (10.5 - 14.0.1000). See Managing the Microsoft SQL Server Connector.

Property Changes

The following property changes were made to the database pool properties in the zoomdata.properties file:

  • The following properties were removed:

    spring.datasource.max-active
    spring.datasource.max-idle
    spring.datasource.max-wait
    spring.datasource.min-idle
    spring.datasource.test-on-borrow
    spring.datasource.test-on-return
    spring.datasource.time-between-eviction-runs-millis
    spring.datasource.validation-query
  • The following properties were added:

    Property Description
    spring.datasource.hikari.maximum-pool-size=<count> The maximum number of connections in the pool, including both idle and active connections. The default is 20.
    spring.datasource.hikari.minimum-idle=<count> The minimum number of idle connections in the pool. The default is 2.
    spring.datasource.hikari.max-lifetime=<milliseconds> The maximum lifetime (in milliseconds) of a connection in the pool. The default is 1800000 milliseconds (30 minutes).
    spring.datasource.hikari.idle-timeout=<milliseconds> The maximum number of milliseconds that a connection is allowed to sit idle in the pool. the default is 120000 milliseconds (two minutes).
    spring.datasource.hikari.validation-timeout=<milliseconds> The maximum number of milliseconds that a connection will be tested for aliveness. The default is 5000 milliseconds. The lowest acceptable value is 250 milliseconds. The value specified must be less than the connection timeout value specified by the spring.datasource.hikari.connection-timeout property.
    spring.datasource.hikari.connection-timeout=<milliseconds> The maximum number of milliseconds that a client will wait for a connection from the pool. If this time is exceeded without a connection becoming available, an SQL exception will occur. The default value is 60000 milliseconds (one minute). The lowest acceptable value is 250 milliseconds.

API Changes

The filterableInAggregate property of the dashboard and visdefs endpoints is no longer available. The information provided by this property was not tailorable and had no effect. If your API calls still include this property, the API call will succeed, but the filterableInAggregate property is silently ignored.

User Interface Changes

The following changes were made to the user interface in this release:

  • After creating a new data source, the banner on the Sources page no longer provides a button that allows you to create a new dashboard and visual from the new data source. In addition, the icon to the right of a data source name that provided a shortcut to visual creation on the Sources page has been removed. Other methods of creating visuals and dashboards remain the same.

    To create a visual or dashboard in this release of Zoomdata, see Adding New Visuals to a Dashboard and Creating Dashboards.

  • A new arc gauge visual type has been introduced in this release. See Arc Gauges.

What's Fixed?

The following problems were fixed in this release:

  • Performance improvements were made.

  • The number field formatting specified in a data source configuration is now used in raw data tables.

    In addition, time fields in raw data tables are now formatted the same way that they are formatted in other visuals. Normally, in aggregate data visuals where a time field is shown, Zoomdata uses the specified granularity of the visual to determine the format of the time field. However, because aggregated data is not used in raw data tables, Zoomdata now formats time fields in raw data tables based on the granularity specified for the time field in the data source configuration.

  • Users with the Can Administer Users privilege but without the Can Administer Groups privilege can no longer add or remove users from groups. In addition, new administrator users can only be added by existing administrators.

  • Configuration properties were exposed in the query-engine.properties file that increase query engine-to-connector timeout times. This handles scenarios in which connectors respond slowly.

What's Deprecated?

The filterableInAggregate property of the dashboard and visdefs endpoints is no longer available. The information provided by this property was not tailorable and had no effect. If your API calls still include this property, the API call will succeed, but the filterableInAggregate property is silently ignored.