xDI - How To - Components and Technologies

How to order records when loading a table
If you want to load a target table in an order, either ascending or descending, you can achieve this functionality by following the steps outlined below.  ...
Fri, 30 May, 2025 at 2:45 PM
[Excel] Define data types on Excel data source
By default, loading data from Excel only handles strings. To handle date, number, etc. in a mapping with an Excel spreadsheet as source, the following f...
Mon, 27 Jun, 2022 at 1:56 PM
Configuring HTTP Access Logs in xDI
Need It may be useful to generate access logs for web services exposed by xDI. The access logs format is typically including information such as client IP ...
Tue, 19 Nov, 2024 at 5:03 PM
Connecting to an SFTP server with a metadata SSH key
Hello,  Please follow the documentation below whenever you need to add an SSH key to authenticate an SFTP connection :  CREATING AND CONFIGURING AN ...
Fri, 5 May, 2023 at 2:59 PM
File - Adding End Character CR+LF
The aim of this article is to explain how to add the CR+LF characters (end of line) at the end of a file, generated by Stambia. First, the File metadata...
Fri, 11 Feb, 2022 at 1:20 PM
File - Automatically Delete Useless Files
This article explains how to create a process, which will delete unnecessary files, so as not to overload the folders. This example shows how to delete xml...
Fri, 11 Feb, 2022 at 1:22 PM
File - Retrieve The Line Number in a Flat File
You may have a flat file and want to get, for each line of this file, the line number. Steps to get the line number To get the line number of each l...
Fri, 11 Feb, 2022 at 1:21 PM
File - Unload Data to Multiple Files
Below example shows how to group output records in multiple files based on a value from the source data. We have a table with customers and we want t...
Fri, 11 Feb, 2022 at 1:20 PM
FTP - Download Files From SFTP Server
This article shows how to use "Get files with SCP" action in order to download files from SFTP server. Step 1: Create a "SSH server"...
Fri, 11 Feb, 2022 at 1:11 PM
HOW TO EXPOSE A WEBSERVICE WITH JSON STRCUTURE IN INPUT/OUTPUT
It is a common practice to have a Web Service that accepts input data in JSON format, makes the necessary transformations/verifications and returns output i...
Wed, 8 Feb, 2023 at 3:00 PM