October 5, 2026 · Matt Irvin
Partner feeds still arrive as PGP-encrypted files on an SFTP server. Here is the full Talend pattern: key-based SFTP with host-key checking, BouncyCastle decryption with integrity verification, an idempotent file ledger, remote archiving, and key-rotation monitoring.
Read moreSeptember 21, 2026 · Matt Irvin
A practical pattern for moving clinical data with Talend: parsing HL7 v2 segments into a normalized staging model, calling FHIR R4 REST APIs with pagination and OAuth, pulling NDJSON from $export, and keeping PHI handling defensible.
Read moreMay 19, 2014 · Matt Irvin
This tutorial will demonstrate how to extract sample data from an xml file and read each xml record into a separate output file.
Read moreJanuary 16, 2014 · Matt Irvin
Sometimes in file processing, there are cases where there are multiple schemas within the one file. This tutorial explains how to separate out these files in Talend to keep all the items distinct.
Read moreAugust 22, 2012 · Matt Irvin
This post is an extension of our previous post – Import an Excel file into Access) . Today we are going to show you how to build on this job in order to iterate upon a group of excel files in a specified file directory, enabling you to automate the bulk loading of multiple excel files into a MS Access database table.
Read moreAugust 18, 2012 · Matt Irvin
Sometimes integrating Talend with Excel data files can be particularly challenging, in this post we are going to walk you through the basic steps required to get started on build a job to load a MS Excel file into an Access database.
Read more