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	⚫
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.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.dialect	⚫	References a section in the file sqltemplates.xml. Possible values are "mysql", "mssql", "oracle", "oracle2", and "postgres"
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.