Database Definition (DOE400)

The Database Definition screen is used to configure the connection string and other information used by the stored procedures. It includes ION specific information based on the Usage Type. Each of the fields and the settings to apply are outlined below.

Field descriptions

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

Managing stored procedures for ION