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.
⚪	servicenow.limit	Default is 200. Sets the maximum number of records read per Web Services (getRecords) call (except where overridden for a specific table).
⚪	servicenow.tablename.limit	Default is datamart.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.