SQL Database Listener
Easily Accept Data From a Relational Database with the 2 Adapter Types Provided in the eiConsole
There are 2 Adapter (Listener) types provided in the eiConsole that will allow you to accept data from a relational database; polling from a table, executing a query or executing a stored procedure. As with all the components of the eiConsole the user is presented with a graphical interface with easy to configure screens.
The first adapter type is the SQL Database Adapter (Listener).
Database Polling Listener Configuration Panel
The user is presented with 4 tabs: Basic, Advanced, Connection, and Scheduling. 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.
You will also 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.
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. The Type is the type of connection that you will be connecting to. In a J2EE environment, you can use a DataSource. 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.
Once the database connections are configured you can check the settings (use the test connection button). If there is an error you will receive an error message.
The Scheduling tab allows you to set up a schedule for how often the chosen Listener should be run. You can easily modify the start or end time.
The Advanced tab allows us to set a timeout for the queries. If a Listener times out, after a given time period it will fail. You can specify information about how many records were picked up in a given query (is Batch Sensitive). You can also choose to trigger this Listener only when it is triggered from an external source (Initialize on trigger only).