xDI - How To - Designer

Execution Conditions based on Database values
Note : this article uses an example from the standard Tutorial Demo Database.  In this example, we have a "Hotel" database and another databas...
Thu, 5 Mar, 2020 at 11:54 AM
Change Data Capture (CDC) Overview
To use CDC with Stambia, you need to download a dedicated component (since S20) or CDC templates (in the Stambia versions older than S20). When activate...
Thu, 19 Mar, 2020 at 1:59 PM
Rejecting data not existing in another table
When loading data into a target table, it is a common requirement to reject data which does not match data in another table.  This article shows two exa...
Thu, 13 Aug, 2020 at 11:18 AM
Use a variable defined with the Variable Manager in SQL Operation
In a process, you may want to use a variable, which was defined with the Variable Manager, in a SQL Operation. First step : use the Variable Manager to ...
Thu, 21 Jul, 2022 at 3:59 PM
Using the Execute Delivery action
Passing parameters to the child session You can add parameters to the ExecuteDelivery action.  In the child process, the parameter can be used with the...
Tue, 12 Apr, 2022 at 11:34 AM
Special characters in SQL Parameters action
All entities must be encoded in XML in the SQL To Parameters action code. You may want to use special characters in your code. Thus you need to replace ...
Thu, 17 Jun, 2021 at 4:40 PM
Adding a driver to the default module
After upgrading the Designer to a S20.x.x version or simply installing the Designer (version 20.x.x), you will use Modules to communicate with technologies ...
Fri, 9 Oct, 2020 at 12:17 PM
Table's name in a join clause when table is not present in a mapping
This article gives an overview of how to make a joint between two tables, when the join clause includes a Select request on a third table which is not prese...
Fri, 9 Oct, 2020 at 12:11 PM
How to use Statistics variables from a mapping in a process
This article explains how to use Statistics delivered by the execution of a mapping in the process that contains this mapping. Process overview : ...
Fri, 9 Oct, 2020 at 12:02 PM
Debug Option with HTTP REST API Metadata
Since Stambia DI Rutime 20.1.0 and higher, there is a dedicated HTTP Rest API metadata. When using this metadata in a mapping, we can use the INTEGRATIO...
Thu, 17 Jun, 2021 at 4:41 PM