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
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
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
Microsoft Azure - Transfer Files Using AzCopy
Microsoft Azure Blob Storage has a specific utility for transferring files: the AzCopy executable.  This article shows how AzCopy is integrated in Stambia ...
Fri, 11 Feb, 2022 at 1:09 PM
Microsoft SQL Server - Specifying A Catalog Name
QUESTION When configuring the Runtime to use a MS SQL Server log database, how to specify the Catalog name? SOLUTION Stambia DI uses JDBC connections. ...
Sun, 20 Feb, 2022 at 11:32 PM