2. Scenario - BDDToXML

Page / - last modified by Assala Chmiti on 2022/06/13 13:18

BDDToXML

last modified by Assala Chmiti

on 2022/06/13 13:18

Table of Contents

Definition

Icon

Configuration

Contents

Definition

Icon

Configuration

MESSAGE Table

1st row

2nd row

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.

MESSAGE Table	TrkID	Sender	Receiver	InterchangeNumber
1st row	125896	Weexa	ixpath	586
2nd row	123658	IXPATH	Weexa	685

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