xDI - How To - Designer

Managing a transaction with SQL orders
General behaviour When executing orders on a relational database, it is possible to include them in a transaction. Thus, if an error occurs during the tran...
Thu, 17 Jun, 2021 at 4:41 PM
License validation behavior
General information about license validation When starting, the Designer validates its license key by connecting to the license URL.  By default, the lice...
Mon, 29 Nov, 2021 at 5:38 PM
Export Models and Dependencies
The support team enjoys these! Once they have the Export of your mapping/process, they can see how it is configured, they can even build it to see how it ge...
Fri, 11 Feb, 2022 at 3:37 PM
Rebuild Cache
This is usually asked by the support team when trying to resolve Cache or Metadata reference issues. Close all the open editors (mappings, processes, met...
Fri, 11 Feb, 2022 at 3:38 PM
How To Pivot Or Unpivot A Table
Using a Query object If you are working on a database that is capable of pivoting or unpivoting tables, you can simply write a query that makes th...
Wed, 16 Feb, 2022 at 11:50 AM
Clean Project
This is usually asked by the support team when having build errors. Close all the open editors (mappings, processes, metadata...) Click the "Project...
Tue, 29 Mar, 2022 at 3:13 PM
How to Split a load into batches
When a source table has a big volume of data,  it can be useful to split the load to the target into several parallel batches.  This can be done...
Fri, 3 Jun, 2022 at 8:57 AM
[SVN] Revert revision changes
If you need to revert or rollback to a previous revision, editing an earlier version might not work (you might not be able to make a commit afterwards). He...
Thu, 20 Oct, 2022 at 10:24 AM
Work With Mappings - Conditional Joins
When working with mappings, a Join is used to combine rows from two or more source datastores. Sometimes, it can be challenging to load/integrate multip...
Tue, 28 Mar, 2023 at 2:55 PM
Work with Processes - Read file with SQLOperation
For many reasons, a read file action may be needed to iterate on a list of values and use the result as Bind values in the target action.  A use case...
Thu, 4 May, 2023 at 10:30 AM