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 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:

  • Availability to share using iFrames
  • Ability to set attribute-level security
  • Micro-query capability for a data source
  • Disable or enable the time bar's animated indicator for live data sources (such as Twitter and Kinesis)
  • Set the maximum number of rows and columns that may be exported to an Excel spreadsheet
With Zoomdata v2.3, the ability to toggle connector variables has been moved to the dedicated Connectors page. Access the article Managing Connector Services for more information.

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
iframes true/false Enable this option to allow users to share code that embeds Zoomdata in an 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

Toggle the sharpening capability 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 this 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 this hard limit, it will be ignored and you will be able to export only 1000 columns.

show-live-data-animation true/false By default, the value is set to true. Disable or enable the animated indicator on the time bar for live data sources (such as Twitter or Kinesis).
show-dashboard-saving-prompt-message true/false By default, this option is enabled. Toggles a message reminder when changes to a dashboard have not been saved.
fusion-disable-composite-join true/false By default, this option is disabled. Specifically related to Zoomdata's data fusion capability, if enabled, composite key joins for fact-to-fact tables will be turned off.

To delete a key-value pair, click the button for the required item.