Infor application properties

On the Connection tab of the application connection point you can select the Infor Application type. These properties are available:

Property Description
Database Driver: Select one of the supported database drivers. See the supported database drivers table shown after this table.
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 will be 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 driver type. See the supported database driver table 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.

The supported database driver types and the URL formats are shown in this table:

Supported Database Drivers URL format
SQL Server (jTDS) Select this option to connect to a Microsoft SQL server database using the jTDS driver. Until ION 11.1.10 this label was called "SQL Server". When using SQL Server authentication on a default instance:

jdbc:jtds:sqlserver://hostname:port schemaname

When using Windows authentication:

jdbc:jtds:sqlserver://hostname:port/schemaname;domain=WindowsDomain

When using a named instance two formats are possible; the first format is more consistent with the URL format of the default SQL instance:

jdbc:jtds:sqlserver://hostname/schemaname;instance=NamedInstance

jdbc:jtds:sqlserver://hostname;instance=NamedInstance;databaseName=schemaname

SQL Server (Microsoft) This option is introduced in ION 11.1.10. Select this option to connect to a Microsoft SQL server database using the Microsoft JDBC Driver 4.0 driver. We recommend that you use this option while connecting to a Microsoft SQL Server setup in a cluster mode.

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

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
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

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

Note:  When 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.

To use your own database type, see "Using a custom database driver" in the Infor ION Development Guide.