Integration Engine Solutions to Connect Anything to Anything

Log out?

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) tab and click on Add Processor.

XML to SQL Database Conversion Processor

Click on Add Processor

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!