datapump.properties

The datapump.properties file must be in a CLASSPATH directory or specified on the command line using the -p filename option.

Property	Required	Default	Description
servicenow.url	Yes	none	URL of the ServiceNow instance
servicenow.username	Yes	none
servicenow.password	Yes	none
pumper.sql.url	Yes	none	JDBC URL for the destination database.
pumper.sql.username	Yes	none	Username used to connect to the destination database. This user must have CREATE TABLE role.
pumper.sql.password	Yes	none
pumper.sql.dialect	Yes	none	References a section in the sqltemplates.xml file. Possible values are oracle1, oracle2 or mysql1.
pumper.sql.autocreate	No	true	Indicates whether or not the application should automatically create tables as necessary in the destination database.
servicenow.chunksize	No	100	Records will be read from ServiceNow 100 rows at a time unless this property is overridden. The maximum permitted value is 250.
servicenow.tablename.chunksize	No	none	Allows the chunksize to be overridden for a specific table. The maximum permitted value is 250. Performance can be improved by using a larger chunksize for tables with short records. Example: servicenow.cmdb_rel_ci.chunksize=250
servicenow.getkeys.size	No	10000	If Use Keys is true (i.e. getRecords is preceded by getKeys to determine the sys_ids of records to be retrieved) then this is the maximum number of keys be be retrieved in each call to getKeys . If there are more keys than this number, then the application will make repeated calls to getKeys until all keys have been retrieved. If this value is less than 1 then the application will attempt to retrieve all keys in single SOAP request.
pumper.check_readable	No	true	The Web Services API does not enable the application to distinguish between a ServiceNow table that is empty versus one that is inaccessible for security reasons. If this property is true, then the application will check at startup to verify that at least one record can be read from each table. If a table appears to be empty (i.e. no records can be read) then an exception will be thrown.
pumper.check_at_end	No	true	This property is only applicable if Use Keys is set to false for a particular Load operation. In this case the application uses __first_row and __last_row to window the getRecords Web Services calls. If check_at_end is true then the reading will stop as soon as an empty result set is returned. If check_at_end is false then reading will stop as soon as a result set returns fewer than the table chunk size
pumper.signal_file	Yes	none	Used to cleanly terminate the application while it is running. This is the name of a local file. If specified, the file (if it exists) will be removed when application starts and the application will continuously check for the existence of the file. If the application detects the existence of the file it will throw an Interrupted Exception and terminate. This property is required due to a bug in the current version of the code.