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
⚫	servicenow.username
⚫	servicenow.password
⚪	servicenow.aggregates	Should be set to "true" if the Aggregate Web Services plug-in is installed, and "false" if not installed
⚫	datamart.url	JDBC URL for the target database; for example: "jdbc:mysql://localhost:3306/sndm"
⚫	datamart.username
⚫	datamart.password
⚪	datamart.schema	Causes all databases table names to be prefixed with the specified schema name
⚫	datamart.dialect	References a section in the file sqltemplates.xml. Possible values are "mysql", "mssql", "oracle", "oracle2", and "postgres"
⚪	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 value is "true", which causes SNDML to automatically create tables in the target database whenever it detects that the table is missing. If "false", SNDML will instead throw an exception if the target table is missing.