Integration Engine Solutions to Connect Anything to Anything

Log out?

Database (SQL) Processor

The Database (SQL) Processor in the eiConsole translates incoming XML data into SQL statements which are used to populate/update a specified database.

XML to SQL Database Conversion Processor

Processor (Adapter) Configuration Drop-Down List


Select the Database (SQL) and click on Add.

XML to SQL Database Conversion Processor

Click on Add


Basic Database (SQL) Processor Configuration Options

On the Basic tab, you will be asked to select an Input file. This input file is an XML file that describes the queries we would like to execute against the relational database. The input file can be created or selected from an existing file on the disk. Choose the three dots on the right of the Input file to show the window below. Once specified, you can choose to edit this file in the eiConsole’s internal editor or in another editor associated with the XML extension.

XML to SQL Database Conversion Processor

Database (SQL) Processor Basic Configuration Options


Connection Database (SQL) Processor Configuration Options

On the Connection tab, you can specify the JDBC connection to the database.

Once the database connections are configured, we can check the settings (use the Test Connection button).

XML to SQL Database Conversion Processor

Database (SQL) Processor Connection Configuration Options


Advanced Database (SQL) Processor Configuration Options

On the Advanced tab you can set:

Database (SQL) Processor Advanced Configuration Options


JDBC Properties Database (SQL) Processor Configuration Options

The JDBC Properties tab can be used to specify name/value pairs to the JDBC driver. The availability and behavior of these properties vary between drivers, so referring to the documentation for a particular driver is necessary to utilize specific properties.

XML to SQL Database Conversion Processor

Database (SQL) Processor JDBC Properties Configuration Options


Polling Database (SQL) Processor Configuration Options

The Polling tab can be used to specify:

XML to SQL Database Conversion Processor

Database (SQL) Processor Polling Configuration Options


Debug Database (SQL) Processor Configuration Options

The Debug tab can be used to specify:

XML to SQL Database Conversion Processor

Database (SQL) Processor Debug Configuration Options


Compatibility Database (SQL) Processor Configuration Options

The Compatibility tab can be used to specify:

XML to SQL Database Conversion Processor

Database (SQL) Processor Compatibility Configuration Options


Transaction Isolation Database (SQL) Processor Configuration Options

The Transaction Isolation tab allows you to specify:

XML to SQL Database Conversion Processor

Database (SQL) Processor Transaction Isolation Configuration Options

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