xDI - How To - Components and Technologies

[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
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
LDAP - Extracting Data
This article shows how to extract data from an LDAP server to a CSV file.  Stambia can do this kind of extraction with the "TOOL Ldap Extractor (searc...
Fri, 11 Feb, 2022 at 1:01 PM
LDAP - Loading Data From a Database
In this article, we are going to demonstrate how to load data from a Database to an LDAP server, using the "TOOL Ldap Integrator" which is availab...
Fri, 11 Feb, 2022 at 1:01 PM