Skip to content

Configuration

Giles Lewis edited this page Oct 29, 2016 · 22 revisions

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
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.
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.
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 [here](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.limit Default is 200. Sets the number of records read per Web Services getRecords call (except where overridden for a specific table).
datamart.tablename.limit Default is datamart.limit. Sets the number of records read per Web Services getRecords call for a specific table.
Clone this wiki locally