Connection Profile

Connection Profile

The Connection Profile is a properties file that contains credentials for connecting to ServiceNow and to the SQL Database and other settings that control the behavior of the loader.

The file is specified with the -p command line option.

java -jar sndm-3.n.n-mysql.jar -p profile -y yamlfile

For releases prior to release 3.5, the Connection Profile looks like this:

servicenow.instance=dev00000
servicenow.username=admin
servicenow.password=secret

datamart.url=jdbc:mysql://localhost/sndm
datamart.schema=sndm
datamart.username=admin
datamart.password=secret

Beginning with release 3.5, the Connection Profile looks like this:

app.instance=dev00000
app.username=admin
app.password=secret
app.agent=main

reader.instance=dev00000
reader.username=admin
reader.password=secret

database.url=jdbc:mysql://localhost/sndm
database.schema=sndm
database.username=admin
database.password=secret

Beginning with 3.5, the loader uses a separate ServiceNow connection for communicating with the scoped app. If you are using 3.5 but you are not using a scoped app (i.e. if you are using the YAML interface) then properties with an app prefix are ignored.

The 3.5 Java code contains a property mapping function, which allows use of an old style property file. Details can be found in the file /src/main/resources/property_names.xml

For detailed information on available properties, please refer to one of these pages

• Connection Profile 3.4
• Connection Profile 3.5