xDI Designer for Flat Files

Semarchy xDI allows to work with Flat files to produce fully customized Integration Processes.

The fields of DELIMITED or POSITIONAL files can be reversed in Metadata and then used in Mappings and Processes to design and adapt the business rules to meet the user’s requirements.

Supported features

You can find bellow an overview of what xDI Designer can do with Flat files

Name

Description

Reverse

The fields of DELIMITED or POSITIONAL files can be reversed in a dedicated Metadata

Transformation

The file’s data can be transformed on the fly at read with the use of scripting

Record validation

The record can be checked at read to verify if they are correctly formatted.

The validation can be done on:

  • Fields size

  • Fields type

  • Record’s number of fields

The user has then the option to:

  • Trace the errors to log files

  • Choose what to do with wrong records / fields

    • Abort the execution

    • Set it to an empty value

    • Set it to null

    • Ignore the error

    • Reject the record