From Database (legacy)

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 – MS SQL

Leave A Comment?