(v24) zoomdata.properties Properties

zoomdata.properties Properties

This applies to: Visual Data Discovery

The zoomdata.properties file can be edited in the /etc/zoomdata directory. Each property is described in the table below.

Some situations where the zoomdata.properties file needs to be updated include:

• Add an SSL Certificate

• Disable the SSL Certificate in Symphony Data Discovery

• Set Up the Screenshot Microservice

• Create a Symmetric Key to Encrypt Data Source Passwords

• About Scheduled Data Discovery Dashboard Reports

• Set Up and Use the Data Gateway Service

For information on editing configuration files, see Edit a Data Discovery Configuration File.

Property	Default Value	Description
access.control.allow.origin	*	By default, CORS is set to --- in the Symphony Server. You can set CORS to restrict access: access.control.allow.origin=<user-defined> For more information, see Enable Visual Data Discovery Component Access From Other Sites Using Cross-Origin Resource Sharing (CORS).
logs.dir	<ZD_install_directory> /logs	Path to Symphony logs. The placeholder <ZD_install_directory> is replaced with the actual location where Symphony is installed. Verify that this log directory has all the necessary permissions and that the owner of the directory is set to zoomdata. The /home directory cannot be used for logging. Example: logs.dir=/opt/<composer>/logs)
data-gateway.client-api.enabled	False	Set to true to enable use of the Data Gateway API and Data Gateway Service. See Set Up and Use the Data Gateway Service.
saml.maxAuthAge	86400	Sets the timeout for SAML, in seconds. The default is 24 hours. Example: saml.maxAuthAge=86400
server.compression.enabled	true	Enables gzip compression for http requests. Example: server.compression.enabled=true
server.port	8080	The default server port, which is set to use http. Prior releases used http.port
server.servlet.context-path	/composer	Example: server.servlet.context-path=/composer
server.session-timeout	1800 seconds	Sets when your Symphony session will timeout (in seconds). Example: server.session-timeout=1800 If you alter this value, also alter the value of the zoomdata.server.ws.idle.timeout property to match it.
source.attribute.values.limit	1000	Sets the limit for the number of attribute values that can be displayed in the Filter list. Example: source.attribute.values.limit=1000
spring.servlet.multipart.max-file-size	500Mb	Example: spring.servlet.multipart.max-file-size=500Mb
spring.servlet.multipart.max-request-size	500Mb	Example: spring.servlet.multipart.max-request-size=500Mb
zoomdata.server.ws.idle.timeout	1800000 ms	Idle time that allows the WebSocket to be still valid. If you alter this value, also alter the value of the server.session-timeout property to match it.
http.response.header.content-security-policy	frame-ancestors *;	Add appropriate values to override the default values and support your business needs, such as default-src 'self' , script-src 'self' , and more. Secure your implementation by including values for these resources using appropriate source URLs. Example: frame-ancestors *; default-src 'self'; script-src 'self' 'nonce-composerScript' https://*.storage.example.com; style-src 'self' 'unsafe-inline' https://*.storage.example.com; img-src 'self'; connect-src 'self'; font-src 'self'; base-uri 'self';
Source Metadata Properties
zoomdata.source.refresh.metadata.cache.timeout.minutes	10080 (one week)	Sets the default time-to-live for cache values, in minutes.
zoomdata.source.refresh.values.maxDistinctValues	100000	Sets the number of queried distinct values that can be stored in cache.
Encryption Properties
security.encryption.algorithm		The encryption algorithm used for file encryption.
security.encryption.key.algorithm		The algorithm type of the encryption key used for file encryption.
Keystore Properties
keystore.location	classpath:security/zoomkeystore.jks	Symphony uses symmetric encryption. You can point to a new keystore to strengthen security. Example: keystore.location=classpath:security/zoomkeystore.jks See Create a Symmetric Key to Encrypt Data Source Passwords for further guidance.
keystore.password	zoomkey	Lets you set up a unique password for the keystore. Example: keystore.password=zoomkey
keystore.key.alias	zoomkey	Example: keystore.key.alias=zoomkey
keystore.key.password	zoomkey	Example:keystore.key.password=zoomkey
Server SSL Properties
server.ssl.key-store	<Symphony_install_directory>/conf/keystore	Sets the path for the keystore location. Example: server.ssl.key-store=HOME/conf/keystore
server.ssl.key-store-password	changeit	Stores the keystore password. Example: server.ssl.key-store-password=<YourPassword>
SAML Configuration Properties
saml.artifactBindingDefault	true	Example: saml.artifactBindingDefault=true
saml.useMultiValueList	true	Example: saml.useMultiValueList=true
saml.stringDelimiter	,	Example: saml.stringDelimiter=;
Kerberized PostgreSQL Properties
spring.datasource.url	jdbc:postgresql://<IP_address>:<port>/zoomdata	The URL of the zoomdata database in the PostgreSQL metadata store. Example: spring.datasource.url=jdbc:postgresql://localhost:5432/zoomdata
spring.datasource.username	zoomdata	The user name for the zoomdata database in the PostgreSQL metadata store. Example: spring.datasource.username=zoomdata
spring.datasource.password	---	The password associated with the user name for the zoomdata database in the PostgreSQL metadata store.
keyset.destination.params.jdbc_url	jdbc:postgresql://<IP_address>:<port>/zoomdata-keyset	The URL of the zoomdata-keyset database in the PostgreSQL metadata store. Example: keyset.destination.params.jdbc_url=jdbc:postgresql://10.2.1.4:5432/zoomdata-keyset
keyset.destination.params.user_name	zoomdata	The user name for the zoomdata-keyset database in the PostgreSQL metadata store. Example: keyset.destination.params.user_name=zoomdata
keyset.destination.params.password	---	The password associated with the user name for the zoomdata-keyset database in the PostgreSQL metadata store.
upload.destination.params.jdbc_url	jdbc:postgresql://<IP_address>:<port>/zoomdata-upload	The URL of the zoomdata-upload database in the PostgreSQL metadata store. Example: upload.destination.params.jdbc_url=jdbc:postgresql://10.2.1.4:5432/zoomdata-upload
upload.destination.params.user_name	zoomdata	The user name for the zoomdata-upload database in the PostgreSQL metadata store. Example: upload.destination.params.user_name=zoomdata
upload.destination.params.password	---	The password associated with the user name for the zoomdata-upload database in the PostgreSQL metadata store.
Source Sampling Properties
source.sampling.rows	1000	Example: source.sampling.rows=1000
source.attribute.values.limit	1000	Example: source.attribute.values.limit=1000
Logging Properties
logging.unified.host	127.0.0.1	Sets the host IP address for Fluentd server message logging. For more information, see Set Up Unified Logging Using Fluentd. Example: logging.unified.host=123.4.5.6
logging.unified.level	OFF	Sets the log level for messages logged to the Fluentd server. The following options are available for this property: TRACE, DEBUG, INFO, WARN, ERROR, and OFF. If set to OFF, Fluentd unified logging is disabled. For more information, see Set Up Unified Logging Using Fluentd. Example: logging.unified.level=INFO
logging.unified.port	24224	Sets the port for Fluentd server message logging. For more information, see Set Up Unified Logging Using Fluentd. Example: logging.unified.port=1234
logging.unified.tag	zoomdata-server	Sets the microservice tag name for messages logged to the Fluentd server. This is important because the tag identifies the microservice to which the log messages apply. Valid values are query-engine, zoomdata-server, stream-writer, upload-service, and edc-<connector-name> (where <connector-name> is one of the names listed in Connector Properties and Property Files). For more information, see Set Up Unified Logging Using Fluentd. Example: logging.unified.tag = zoomdata-server
syslog.host	127.0.0.1	Sets the host IP address for Syslog server message logging. Example: syslog.host=127.0.0.1
syslog.log.level	OFF	Sets the syslog log level for messages logged to the Syslog server. The following options are available for this property: TRACE, DEBUG, INFO, WARN, ERROR, and OFF. Example: syslog.log.level=DEBUG
syslog.port	1514	Sets the port for Syslog server message logging. Example: syslog.port=1514
syslog.suffix	local	Specifies a suffix that is appended at the end of the Syslog server log entry that Symphony generates. Example: syslog.suffix=local
Password Policy
auth.password.policy.specialCharacters	!@#$%^&*()-_=+,.:;<>
auth.password.policy.minCharacters	9
auth.password.policy.maxCharacters	255
auth.password.policy.minLowercaseCharacters	1
auth.password.policy.minUppercaseCharacters	1
auth.password.policy.minNumericCharacters	1
auth.password.policy.minSpecialCharacters	1
auth.password.policy.helpMessage	Password must contain at least 9 characters including 1 lowercase, 1 uppercase, 1 number and 1 special (!@#$%^&*()-_=+,.:;<>).	Text is not enclosed in quotation marks.
Data Export Properties
zoomdata.export.data.max.cols	1000 columns	Use this property to define the maximum number of columns that can be exported for two-dimensional visuals (such as a pivot table). Symphony enforces this limit for visual data, but does not enforce it for raw data. The distributed default for this setting is 1000 columns. Valid values can range from 0 through 2147483647 columns.
zoomdata.export.data.max.rows	100000 rows	Use this property to define the maximum number of rows that can be exported for visuals. Symphony enforces this limit for visual data. However, for raw data, Symphony produces an error if the number of rows requested for export exceeds this setting. The distributed default for this setting is 100000 rows. Valid values can range from 0 through 2147483647 rows.
zoomdata.export.visualdata.max.rows	100000 rows	Use this property to define the maximum number of rows that can be exported for visuals. Symphony enforces this limit for visual data. However, for raw data, Symphony produces an error if the number of rows requested for export exceeds this setting. The distributed default for this setting is 100000 rows. Valid values can range from 0 through 2147483647 rows.
Screenshot Microservice Client & Dashboard Scheduling Properties
screenshot.service.name	screenshot-service
screenshot.service.url	http://localhost:8083/
screenshot.service.http.client.connect.timeout.milliseconds	10000 milliseconds	Specifies the number of milliseconds that can elapse before Symphony stops trying to connect to the screenshot microservice client.
screenshot.service.http.client.read.timeout.milliseconds	60000 milliseconds	Specifies the number of milliseconds that can elapse before Symphony stops trying to read from the screenshot microservice client. Note: If you increase the time set by the dashboard.scheduling.screenshot.timeout property, make sure that you increase the value of this property as well. The total time set by screenshot.service.http.client.read.timeout.milliseconds should always be greater than or equal to the time set by the dashboard.scheduling.screenshot.timeout property. Bear in mind that this property is specified in milliseconds, but the dashboard.scheduling.screenshot.timeout property is specified in seconds.
screenshot.service.http.client.write.timeout.milliseconds	60000 milliseconds	Specifies the number of milliseconds that can elapse before Symphony stops trying to write to the screenshot microservice client.
dashboard.scheduling.screenshot.png.height	720 pixels	Identifies the height (in pixels) of the screenshot PNG file that will be sent.
dashboard.scheduling.screenshot.png.width	1280 pixels	Identifies the width (in pixels) of the screenshot PNG file that will be sent.
dashboard.scheduling.screenshot.timeout	60 seconds	Specifies the timeout (in seconds) to take a screenshot for a dashboard email report. Note: The time specified by this property must be less than or equal to the time set by the screenshot.service.http.client.read.timeout.milliseconds property. If you increase the value of this property, make sure that you increase the value of the screenshot.service.http.client.read.timeout.milliseconds property accordingly. Bear in mind that this property is specified in seconds, but the screenshot.service.http.client.read.timeout.milliseconds property is specified in milliseconds.
mail.from		Specifies the email address identifying where the email comes from.
mail.login		Specifies the email login to use to access the mail server.
mail.password		Specifies the password associated with the email login identified in the mail.login property.
In addition, JavaMail API properties (Symphony supports both IMAP and SMTP protocols) should be added to the zoomdata.properties file to identify the mail server and other mail properties required to use that server to send the scheduled dashboard (for example, mail.smtp.auth, mail.smtp.host, mail.smtp.port, mail.imap.host, and mail.imap.port). Complete descriptions of IMAP and SMTP protocol JavaMail properties can be found at these links: IMAP: https://javaee.github.io/javamail/docs/api/com/sun/mail/imap/package-summary.html SMTP: https://javaee.github.io/javamail/docs/api/com/sun/mail/smtp/package-summary.html
Field Settings
zoomdata.detect.type.attribute.max.length	200 characters	Use this property to set the maximum character length of attribute fields. If this limit is exceeded, the field will be recognized as a Text field.