The Database Definition (DOE400) screen is used to configure the connection string and other information used by the stored procedures. It has been updated to include ION 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
At this time, only Microsoft SQL Server is supported and must be selected.
Server
This is either the IP or network address for the system hosting the SQL Server environment. This setting is not used by the ION connection, but is kept for backward compatibility with prior Database Definitions.
DB Name
This is the name of the database instance within the SQL Server environment. This setting is not used by the ION connection, but is kept for backward compatibility with prior Database Definitions.
Usage Type
The usage type of ION is used to indicate the database definition if for ION. This 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.
The following is a list of the connection string settings used by SQL Server in this discussion.
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
This is 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
This is 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