Zoomdata Version

Configuring Key and Value Settings

Zoomdata administrators may use the supervisor credential to manage certain settings (or server level variables) in Zoomdata. Essentially, as the supervisor, you can toggle certain variables and determine whether they are available to admins and users. This capability is handled from the Advanced menu, in the Key-Value Store .

Figure 1

As shown in Figure 1, variables that can be toggled include:

  • Access to specific data source connectors
  • Availability to share using iFrames
  • Ability to set attribute-level security
  • Micro-query capability for a data source

In addition, the supervisor can:

  • Set the maximum number of rows and columns that may be exported to an Excel spreadsheet
  • Disable or enable the time bar's animated indicator for live data sources (such as Twitter and Kinesis)

To add a new key-value pair, log in as supervisor and click the Advanced tab. The Server Level Variables page listing all the key-value pairs will be displayed.

To add a key-value pair, click Add and specify the key and its value in the corresponding fields. Click Save .

Below is the list of key-value pairs supported in Zoomdata.

Key Value Description
connector-<Internal name of the datasource (SubStorage type) in upper case> true/false

You can enable (or disable) the connector types that will be available (or hidden) on the Data Sources page for the users to create new data sources.
By default 4 beta connectors (Aurora, Hive on EMR, Hive on Tez, and MemSQL) are disabled. Set the value to True to enable a beta connector.
You can also disable the existing connectors by adding the corresponding key-value pair and setting the value for the connector to False .

iframes true/false Enable this option to embed Zoomdata as iFrame.
security-attribute-level true/false By default this option is enabled. Therefore, you can configure the fields from specific data source to be available or hidden for a user group. This functionality is available from the Manual configuration tab on the Groups page .
microquery-SOURCE_TYPE true/false

Enable to disable sharpening for the specified source type.

For example, microquery-ORACLE=false will disable sharpening for all Oracle sources

pivot-xls-max-rows [number]

Specify the number of rows to be exported to the .xls file.

There is a hard limit for number of rows to be exported - 100.000. If you specify a number greater than hard limit, it will be ignored and you will be able to export only 100.000 rows.

pivot-xls-max-columns [number]

Specify the number of columns to be exported to the .xls file.

There is a hard limit for number of columns to be exported - 1000. If you specify a number greater than hard limit, it will be ignored and you will be able to export only 1000 columns.

show-live-data-animation true/false Disable or enable the animated indicator on the time bar for live data sources (such as Twitter or Kinesis). By default, the value is set to true.

To delete a key-value pair, click the button for the required item. However, note that key-value pairs set by Zoomdata cannot be deleted. Those particular values will not have the Delete option.