Infor application properties

Note: This section is only applicable for the connection points of type Enterprise Connector.

On the Connection tab of the application connection point you can select the Infor Application type. This table shows the available properties:

Property Description
Database Driver Select one of the supported database types. See the supported database table below
Database Select one of these configurations for the database address:
  • Basic - specify properties for the database. The properties to be specified depend on the selected Database Type. The URL to connect to the database is built automatically.
  • Advanced - specify the URL to connect to the database. Use this if you must use advanced settings that are not shown when selecting Basic.
Hostname Specify the host name of the server that hosts the database. This field is only enabled if the Basic check box is selected.
Port Number Specify the number of the port that must be used to connect to the database. This field is only enabled if the Basic check box is selected.
Schema Name Specify the name of the database schema to be used. This field is only enabled if the Basic check box is selected and the Database Type is SQL Server, Oracle DB2 or DB2/400.
SID Specify the name of the Oracle schema ID to be used. This field is only enabled if the Basic check box is selected and the Database Type is Oracle
URL Specify the URL of the database that contains the Inbox and Outbox tables. The URL is dependent of the database type. See the supported database table below for details.

If you selected the Basic configuration for the database address, the URL is read-only.

User Name Specify the user name to connect to the database. Note: when using SQL Server with Windows authentication, specify a valid Windows domain username instead of a SQL Server user name.
Password: Specify the password to connect to the database.
Application can receive messages with compression type

Specify how application can receive messages. There are two options:

  • None - no compression is used.

  • Deflate - compressed based on the deflate algorithm, as described in RFC 1951. A combination of the LZ77 algorithm and Huffman coding, wrapped inside the zlib data format, RFC 1950.
Delete Processed Messages Whether processed messages must be deleted immediately from the Outbox after processing them.

This table shows the supported database types and the URL formats:

Supported Database Drivers URL format
Oracle jdbc:oracle:thin:@//[hostname]:[port]/[oracle_sid]
DB2 jdbc:db2:// [hostname]:[port]/[schemaname]
DB2/400 jdbc:as400://[hostname];naming=system;libraries=[schemaname];prompt=false
MS_SQLServer The URL is specified in this format: jdbc:sqlserver://[hostname[\instanceName][:port]][;property=value[;property=value]]

For example, when using SQL Server authentication on a default instance with the MultiSubnetFailover property of a cluster setup: jdbc:sqlserver://[hostname]:1433;databaseName=[schemaName];MultiSubnetFailover=true

For a complete connection URL specification of this driver, see the Microsoft documentation at https://msdn.microsoft.com/en-us/library/ms378428(v=sql.110).aspx.

Postgres (PPAS) jdbc:postgresql://[HostName]:[PortNumber]/[SchemaName]?stringtype=unspecified

For a complete connection URL specification of this driver, see the Postgres documentation at:

https://jdbc.postgresql.org/documentation/93/connect.html

To use this driver in ION, the “?stringtype=unspecified” parameter is required.

If you create an Infor application connection point with DB2 as the database type, the user account used in the connection properties must equal the user account which created the Inbox/Outbox tables in the database.

You can reuse this I/O box for multiple Logical IDs. See Configuring Connection points for a Multi-Logical ID I/O box.