Wiki source code of BDDToXML
Last modified by Assala Chmiti on 2022/06/13 13:18
Hide last authors
| author | version | line-number | content |
|---|---|---|---|
 |
1.1 | 1 | {{box cssClass="floatinginfobox" title="**Contents**"}} |
| 2 | {{toc/}} | ||
| 3 | {{/box}} | ||
| 4 | |||
 |
8.1 | 5 | = Definition = |
| |
1.1 | 6 | |
| |
31.2 | 7 | BddToXml is to get Data from a database Table. |
| |
1.1 | 8 | |
| 9 | |||
| |
10.1 | 10 | = Icon = |
| |
8.1 | 11 | |
| |
29.2 | 12 | [[image:2021-03-25 11_46_25-iXPath _ Scenario.png]] |
| |
8.1 | 13 | |
| |
19.2 | 14 | |
| |
25.1 | 15 | = Configuration = |
| |
1.1 | 16 | |
| |
29.2 | 17 | [[image:2021-03-25 11_48_38-iXPath _ Scenario.png]] |
| |
19.2 | 18 | |
| 19 | |||
| |
29.2 | 20 | The following elements are Mandatory for this connector: |
| |
19.2 | 21 | |
| 22 | |||
| |
36.1 | 23 | **~ Connexion**: the URL to your database, example, URL of SQL server : **jdbc:sqlserver:~/~/[serverName[\instanceName][:portNumber]][;property=value[;property=value]]** |
| |
19.2 | 24 | |
| |
36.1 | 25 | **Output FileName**: the name of the output file that contain the result of the SQL Query. |
| |
19.2 | 26 | |
| |
37.1 | 27 | **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: |
| |
31.2 | 28 | |
| 29 | |||
| |
36.1 | 30 | [[image:1645718073309-490.png||height="220" width="580"]] |
| 31 | |||
| 32 | |||
| 33 | __//**Example**//__: | ||
| 34 | |||
| 35 | In this case the MESSAGE Table contains the following elemnets in the Database. | ||
| 36 | |||
| 37 | |||
| 38 | (% border="2" %) | ||
| 39 | |(% style="width:313px" %)((( | ||
| 40 | ===== __//**MESSAGE Table**//__ ===== | ||
| 41 | )))|(% style="width:208px" %)TrkID|(% style="width:219px" %)Sender|(% style="width:197px" %)Receiver|(% style="width:211px" %)InterchangeNumber | ||
| 42 | |(% style="width:313px" %)((( | ||
| 43 | ====== 1st row ====== | ||
| 44 | )))|(% style="width:208px" %)125896|(% style="width:219px" %)Weexa|(% style="width:197px" %)ixpath|(% style="width:211px" %)586 | ||
| 45 | |(% style="width:313px" %)((( | ||
| 46 | ====== 2nd row ====== | ||
| 47 | )))|(% style="width:208px" %)123658|(% style="width:219px" %)IXPATH|(% style="width:197px" %)Weexa|(% style="width:211px" %)685 | ||
| 48 | |||
| |
37.1 | 49 | The content of the output file that respects the SQL query is: |
| |
36.1 | 50 | |
| 51 | |||
| 52 | [[image:1645718712700-347.png||height="237" width="697"]] | ||
| 53 | |||
| 54 | |||
| |
19.2 | 55 |