Integration Engine Solutions to Connect Anything to Anything

Log out?

Database Polling (SQL) Listener

Easily Accept Data from a Relational Database with the Listener (Adapter) Types Provided in the eiConsole.

There are Listeners (Adapters) provided in the eiConsole that will allow you to accept data from a relational database, poll from a table, execute a query or execute a stored procedure. As with all of the components in the eiConsole, the user is presented with a graphical Interface and easy-to-configure screens.

The adapter type we will focus on is the Database Polling (SQL) Listener or Adapter.

Database Polling SQL Listener Configuration Options in PilotFish Software

Listener (Adapter) Configuration Drop-Down List

The user is presented with 9 tabs: Basic, Advanced, Transaction Logging, Inactivity, Throttling, Connection, Scheduling, JDBC Props, and Debug. In the Basic tab, you describe how often you would like to poll the relational database. A pull-down menu presents you with choices – seconds, minutes, hours, and weeks.

Basic Database Polling (SQL) Listener Configuration Options

You will be asked to select an input file. This input file is an XML file that describes the queries you would like to execute against the relational database. The input file can be created or selected from an existing file on disk. Once specified, you can choose to edit this file in the eiConsole’s internal editor or in another editor associated with the XML extension.

SQL Polling Listener Basic Configuration Options

Database Polling Listener Basic Configuration Options

Advanced Database Polling (SQL) Listener Configuration Options

The Advanced tab allows you to set a timeout for the queries. If a Listener times out after a given time period, it will fail. You can specify the information on how many records were picked up in a given query (Batch Sensitive?). You can also choose to trigger this Listener only when it is triggered by an external source (Initialize on Trigger Only).

SQL Polling Listener Advanced Options in PilotFish Integration Engine

Database Polling Listener Advanced Configuration Options (top half of screen)

Database Polling SQL Listener Advanced Options in PilotFish Integration Engine

Database Polling Listener Advanced Configuration Options (bottom half of screen)

Transaction Logging Database Polling (SQL) Listener Configuration Options

The Transaction Logging tab allows you to specify:

SQL Polling Transaction Logging Options in PilotFish Middleware

Database Polling Listener Transaction Logging Configuration Options

Inactivity Database Polling (SQL) Listener Configuration Options

The Inactivity tab allows you to specify:

SQL Database Polling Inactivity Configuration Options

Database Polling Listener Inactivity Configuration Options

Throttling Database Polling (SQL) Listener Configuration Options

The Throttling tab allows you to specify:

Database Polling (SQL) Listener Throttling Mode Selections

Database Polling (SQL) Listener Throttling Mode

Throttling Configuration Options for Database Polling (SQL) Adapter or Listener in PilotFish Integration Engine

Database Polling Listener Throttling Configuration Options

Connection Database Polling (SQL) Listener Configuration Options

The Connection tab allows you to specify the JDBC connection to the database. The User Name is the user name that you would typically use to connect to the database. The Password is the password for the user. Type is the type of connection that you will be connecting to. In a J2EE environment, you can use a Data Source. As a result, you will specify the name as it appears in the application container. In most other cases you will create a JDBC Connection, which will allow you to specify the JDBC Driver name and URL.

SQL Polling Listener Connection Configuration Options in PilotFish Software

Database Polling Listener Connection Configuration Options

Once the database connections are configured you can check the settings using the Test Connection button. If there is an error, you will receive an error message.

Database Polling Connection Error Example in PilotFish Interface Engine

Database Polling Listener Failed Connection Test Example

Scheduling Database Polling (SQL) Listener Configuration Options

The Scheduling tab allows you to create a schedule for how often the chosen Listener should be run. You can easily modify the start time or end time.

To modify the scheduled start or end time, choose the three dots next to the corresponding line. You will receive a dialogue box that looks like this:

SQL Polling Scheduling Options in PilotFish

Database Polling Listener Scheduling Options

JDBC Props Database Polling (SQL) Listener Configuration Options

The JDBC Props tab allows you to set up a JDBC property to be set on the JDBC connection.

JDBC Properties for Listener Configuration in PilotFish

JDBC Properties for Database Polling Listener Configuration

Database Polling (SQL) Listener Debug Configuration Options

The Debug tab allows you to choose what information will be logged for debugging purposes.

SQL Polling Debug Options in PilotFish Interface Engine

Database Polling Listener Debug Configuration Options

Database Polling (SQL) Listener Transaction Isolation Configuration Options

The Transaction Isolation tab allows you to specify:

SQL Polling Transaction Isolation Options in PilotFish Middleware

Database Polling Listener Transaction Isolation Configuration Options

This is a unique website which will require a more modern browser to work! Please upgrade today!