Configuring System Properties

The following parameters can be configured in the settings.properties file, located within the SETTINGS folder within the installation location (e.g. C:\Program Files\[1Integrate_Directory]\SETTINGS).

     Note: On Windows, folder paths within the settings.properties file must be specified using a forward slash. Spaces in folder names are allowed (e.g. C:/Program Files/1Spatial/1Integrate).

Required

Property

Type

Description

repository.driver

string

The database type. Defaults to a H2 database, but Oracle, SQLserver or PostGresql are also supported.

Define using the values: h2, oracle, sqlserver or postgresql.

      Note: Do not use the default H2 database in production environments. See the other database options for recommended repository servers.

repository.url

string

The URL for the database in which to store 1Integrate metadata and entities (Rules, Actions, Sessions and so on), and files that are uploaded to the server used by the data store (such as MapInfo Tab files).

By default, his will be populated by the H2 database details.

For other supported databases the format is:

  • For Oracle: jdbc:oracle:thin:@[HOSTNAME]:[PORT]/[Service]Orjdbc:oracle:thin:@[HOSTNAME]:[PORT]:[SID]

  • For MS SQL: jdbc:sqlserver://[serverName[\\instanceName][:portNumber]];databaseName=1Integrate

    For MS SQL with Windows Authentication: repository.url=jdbc:sqlserver://[serverName[\\instanceName][:portNumber]];integratedSecurity=true;databaseName=1Integrate

          Note: You must define either a serverName or instanceName. See Microsoft documentation for further guidance.

  • For PostgreSQL:

          Note: You will only need to specify a port if you are not using the default.

    • To use the public schema to store the repository:

      jdbc:postgresql://[HOSTNAME]:[PORT(if non-default)]/[DATABASE]

    • To use a specified schema to store the repository:

      jdbc:postgresql://[HOSTNAME]:[PORT(if non-default)]/[DATABASE]?currentSchema=[REPOSITORYSCHEMA]

repository.username

string

Username to connect to the repository schema, in which to store 1Integrate metadata and entities (e.g. Rules, Actions, Sessions) as well as files that are uploaded to the server used by the data store (e.g. MapInfo Tab files).

repository.password

string

Password for the user described by repository.username.

ls_license

string

The location and name of the provided product licence file.

temp.directory

string

This is a temporary folder location for files that are eventually stored in the database.

cache.directory

string

The location of the cache directory.

When a Session is run, a folder is created called "1Integratecache", within which the cache is stored.

      Note: This stores the data cache from data read by 1Integrate . This may require large amounts of disk space depending on the size of data being read into Sessions and the number of concurrent Sessions.

      Note: Multiple engines need to share the same cache location to allow a paused Session to be picked up and continued/rewound without restarting it.

For Linux, if left blank this will default to /tmp.

For Windows, if left blank this will default to C:\Users\[user]\AppData\Local\Temp.

      Note: It is recommended that you change the default cache.directory to a different location to avoid your cache being unexpectedly cleared by the system.

interface.http.port

integer

The port to use for the interface.

      Note: If possible, use the default port number specified in the file. If there is a clash with another application that already uses this port number, increment the value by 1 until an unused port number is found.

engine.http.port

integer

The port to use for the engine.

      Note: If possible, use the default port number specified in the file. If there is a clash with another application that already uses this port number, increment the value by 1 until an unused port number is found.