Definition

BddToXml is to get Data from a database Table.

Icon

Configuration

The following elements are Mandatory for this connector:

     Connexion: the URL to your database, example, URL of SQL server : jdbc:sqlserver://[serverName[\instanceName][:portNumber]][;property=value[;property=value]]

     Output FileName: the name of the output file that contain the result of the SQL Query.

     The Format: the xml file that contains the query. This example below allows to extract Data from MESSAGE Table where the column Sender equals to IXPATH, and put it in a Message element:

Example:

In this case the MESSAGE Table contains the following elemnets in the Database.

The content of the output file that respects the SQL query is: