The Database Definition program is used to configure the connection string and other information used by the stored procedures. It includes Infor OS-specific information based on the Usage Type. Each of the fields and the settings to apply are outlined below.
Database ID
The database ID is a system-wide identifier for the database connection information. It is used by the CSSQL object to get the connection string and table information for the ION database.
Description
This is a free-form entry to describe the database connection. It can be used to indicate test versus live database environments.
Type
Specify the database type: Microsoft SQL Server or PostgreSQL.
Server
This is the IP or network address for the system hosting the SQL Server environment. This setting is not used by the Infor OS connection, but is kept for backward compatibility with prior Database Definitions.
DB Name
This is the name of the database instance within the SQL or PostgreSQL server environment. This setting is not used by the Infor OS connection, but is kept for backward compatibility with prior Database Definitions.
Usage Type
The usage type is used to indicate the database definition for Infor OS. I-Inbox/Outbox for Infor OS is the only usage type supported at this time.
Connection String
The connection string can be any valid method for connecting to the SQL Server database via the PxPlus [ODB] method. At minimum, a DSN and Database section must exist in the connection string. The DSN can provide the required information, whereas the Database is required for stored procedure maintenance.
Refer to the list of connection string settings used.
Driver
Usually set to SQL Server but can be a different driver name if required from the operating system
Database
The database name to connect to / use when updating the stored procedures
Server
The server name / IP address of the SQL Server environment
Integrated Security
This instructs the connection to use the domain authentication for the process instead of username and password. Using this will allow the FACTs server or the credentials in which the process is running to authenticate to the SQL Server.
Username
Plain text user name used to connect to the server. This should not be used if Integrated Security is used.
Password
The password used to connect to the SQL server when supplying a username and password combination. The password will be replaced with asterisks when displayed to the user.
Inbox Header / Entry
The table names used to store the ION information for incoming messages to the system of record (SOR). The defaults are COR_INBOX_ENTRY and COR_INBOX_HEADERS. These table names are substituted when updating the stored procedures which will be covered later in this document.
Outbox Header / Entry
This is the table names used to store the ION information for outgoing messages from the system of record (SOR). The defaults are COR_OUTBOX_ENTRY and COR_OUTBOX_HEADERS. These table names are substituted when updating the stored procedures which will be covered later in this document.
See also