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 allows to extract Data from transports Table, and put them in Message element:

Example:

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

The content of the output file is: