Configuration

The name of the properties file should be specified on the command line with the -p option.

⚫️ indicates a required property.

⚪️	Property	Description
⚫️	servicenow.url	URL of the ServiceNow instance; for example: https://dev00000.service-now.com/
⚫️	servicenow.username
⚫️	servicenow.password
⚫️	datamart.url	JDBC URL for the target database; for example: jdbc:mysql://localhost:3306/sndm
⚫️	datamart.username
⚫️	datamart.password
⚪️	datamart.schema	All target database table names will prefixed with this schema name. Note: For MySQL leave this property blank and specify the schema in the URL as jdbc:mysql://hostname/schema
⚫️	datamart.dialect	References a section in the file sqltemplates.xml. Supported values are "mysql", "mssql", "oracle", "oracle2", "postgres" and "sqlite".
⚪️	datamart.schema.servicenow.url	Used to specify an an alternate ServiceNow instance for table definitions as described in [Using a non admin account].
⚪️	datamart.schema.servicenow.username	See above
⚪️	datamart.schema.servicenow.password	See above
⚪️	datamart.autocreate	The default is "true", which causes the application to automatically create tables in the target database whenever it detects that the table is missing. If "false", the application will instead throw an exception if the target table is missing.
⚪️	datamart.check_readable	The default is "true", which causes the application to abort with an "unable to read table" error if no records can be read from a table. If "true", then before attempting a query, the application tests whether a table is readable by attempting to read a single record. The table will be unreadable if it is empty or if access controls do not permit read access. If "false", this check will be bypassed, and the program will simply process zero records for any unreadable table.
⚪️	datamart.templates	Specifies the name of a file which contains an alternate version of the sqltemplates.xml file. If not specified the application will use the embedded version of sqltemplates.xml. To use this property (1) make a copy of the file /src/main/resources/xmltemplates.xml, (2) apply your edits to your copy, and (3) set this property to the file path of your copy.
⚪️	servicenow.limit	Default is 200. Sets the maximum number of records read per Web Services (getRecords) call (except where overridden for a specific table). Note: You must also set the property glide.remote_glide_record.max_count in your ServiceNow instance.
⚪️	servicenow.tablename.limit	Default is servicenow.limit. Sets the maximum number of records read per Web Services (getRecords) call for a specific table.
⚪️	servicenow.getkeys_limit	Sets the maximum number of keys (sys_ids) read per Web Services (getKeys) call. If 0 or not specified, then all keys are retrieved in a single call. This may result in a timeout error for large tables with more than 200,000 rows.
⚪️	servicenow.aggregates	Default is "false". Set to "true" if the Aggregate Web Services plug-in is installed, thereby allowing the application to verify that the number of retrieved keys matches the expected value.
⚪️	servicenow.compression	Default is "true". Set to "false" to disable GZIP compression of HTTP responses.
⚪️	servicenow.timeout	Used to set an HTTP response timeout in milliseconds.