Wiki source code of BDDToXML
Last modified by Assala Chmiti on 2022/06/13 13:18
Show last authors
| author | version | line-number | content |
|---|---|---|---|
| 1 | {{box cssClass="floatinginfobox" title="**Contents**"}} | ||
| 2 | {{toc/}} | ||
| 3 | {{/box}} | ||
| 4 | |||
| 5 | = Definition = | ||
| 6 | |||
| 7 | BddToXml is to get Data from a database Table. | ||
| 8 | |||
| 9 | |||
| 10 | = Icon = | ||
| 11 | |||
| 12 | [[image:2021-03-25 11_46_25-iXPath _ Scenario.png]] | ||
| 13 | |||
| 14 | |||
| 15 | = Configuration = | ||
| 16 | |||
| 17 | [[image:2021-03-25 11_48_38-iXPath _ Scenario.png]] | ||
| 18 | |||
| 19 | |||
| 20 | The following elements are Mandatory for this connector: | ||
| 21 | |||
| 22 | |||
| 23 | **~ Connexion**: the URL to your database, example, URL of SQL server : **jdbc:sqlserver:~/~/[serverName[\instanceName][:portNumber]][;property=value[;property=value]]** | ||
| 24 | |||
| 25 | **Output FileName**: the name of the output file that contain the result of the SQL Query. | ||
| 26 | |||
| 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: | ||
| 28 | |||
| 29 | |||
| 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 | |||
| 49 | The content of the output file that respects the SQL query is: | ||
| 50 | |||
| 51 | |||
| 52 | [[image:1645718712700-347.png||height="237" width="697"]] | ||
| 53 | |||
| 54 | |||
| 55 |