Guide

Your first flow: SFTP → EDIFACT → SQL Server

In this guide you collect an EDIFACT message from an SFTP server, convert it to XML, map it and write it to SQL Server.

01

Create a workspace

Open Flows, choose New workspace and name it, for example ORDERS_IN.
02

Add the SFTP connector

Click Add, pick SFTP and fill in host, port, user and key. Save the credentials in the vault. Set the remote folder and the file pattern (*.edi).
03

Schedule the pickup

In Automation, set the receive interval — every 5 minutes is a good start.
04

Add the EDIFACT connector

Connect SFTP → EDIFACT. Choose the directory (for example D96B) and turn on validation.
05

Map to your table

Add an XML Map after EDIFACT. Load a sample message and drag the fields you need onto the target structure.
06
Write to SQL Server

Add SQL Server, choose the shared connection and the table or stored procedure, then map the columns.
```
INSERT / UPSERT → dbo.SalesOrders
Key: OrderNumber
```
07

Route errors

Connect the error path of each step to a Notify or Email Send connector.
08

Test and switch on

Drop a sample file on the server, follow it in Transactions, then enable the schedule.

Want us to build it with you?

Book a session and bring your own files.