Configure the settings for the legacy From Database source component.

Note: you can use the Tables tab to create the tables for your From Database component

The From Database component allows you to read from a database.

• Click the Edit Channel button
• Enter your settings and click Save Changes

Database API

• Select the database to use from the listbox

Data source

• Enter the name of the data source
  The name of this data source depends on the database API that you have selected:

  Database API	Expected data source
  MySQL	If the database is locally hosted, the data source name is the name of the database schema. For remote databases, use the form schema@host or schema@host:port, where host is the IP address or hostname of the server.
  OCI-Oracle	One of the following: The Oracle service name, which is the name in the tnsnames.ora file; The Oracle connection string; The Oracle Instant Client connection string (for example, <host>:<port>/<servicename>)
  Any ODBC-based database API	The name of the ODBC system data source (System DSN)

Database username

• Enter the username (if required)

Database password

• Enter the password (if required)

Full generator VMD path

• Select the VMD file to map from the database to HL7

Poll time

• Enter the number of milliseconds to wait before querying the database for messages that need to be sent (minimum is 1000 milliseconds)

Order messages by column

• Check the box to sort the messages by a specified column
• Enter the column name and select Ascending or Descending from the listbox

Reconnect to DB?

• Select the database reconnection option from the listbox
•  If you select yes with limit you must specify the number of reconnection attempts

Reconnection interval

•  into the number of milliseconds between reconnection attempts

Database timeout

• Specify the Microsoft SQL Server database timeout value in seconds
  Note: This field only appears if you selected ODBC – Microsoft SQL Server