Would you like to be called free of charge by one of our advisors?

Our advisors are available from Monday to Friday at 9am to 12am and at 2pm to 6pm

Thank you, our adivisors will calling you.

GoAnywhere MFT – EDI

Automate the management of inter-application data exchanges

Request documentation Contact-us

Inter-application data exchange (IDE) management

With GoAnywhere MFT, data can be translated to/from a variety of popular formats without having to write cumbersome scripts or programs. The comprehensive ETL features in GoAnywhere MFT allow data values to be mapped, formatted and modified between source and target files (in single and/or multi-platform environments.

Functions

Pictogramme - Rapports d'audit

Source formats

• Excel
• Delimited text (CSV, etc.)
• Flat files and fixed width files
• XML
• JSON

Target formats

• Excel
• Delimited text (CSV, etc.)
• Flat files and fixed width files
• XML
• JSON

Key features

  • Parameter setting without programming
  • Automation of processing operations
  • Modification of data between source and target

What is EDI? What is X12 EDI?

EDI is a flat file format used by business-to-business (B2B) trading partners in industries like banking and finance, technology, retail, healthcare, and higher education. X12 is a form of EDI data. X12 is supported by the ASC X12 standard and is used by leading businesses worldwide to exchange sensitive EDI documents with clients, trading partners, and other organizations.

EDI X12 Transaction Sets

Have your trading partners requested you use a certain transaction set to exchange files? Each transaction set corresponds with a number and type of document. With GoAnywhere, users can rely on a single, solid managed file transfer solution with built-in EDI X12 capabilities to do all of this. GoAnywhere supports users’ abilities to read, write, map, move, transfer, and process X12 and XML files safely, securely, and easily between databases.

 

Centralize Your EDI X12 File Translation

GoAnywhere MFT includes out-of-the-box integrations with popular web and cloud applications. For those with EDI X12 requirements, GoAnywhere offers more than 6,800 X12 data transaction sets, and it’s easy to get started. If you have GoAnywhere already, you simply need to purchase a starter pack and choose the six templates you’d like access to. Additional transaction sets are also available to help keep your X12 EDI needs centralized in one industry-leading managed file transfer solution.

Delimited Text Translation GoAnywhere MFT can read and write common data exchange formats like delimited text files. Most column delimiters are supported including commas (e.g. CSV files), tabs, colons, semicolons, tilde and vertical pipes.

Reading Delimited Text

The data read in from delimited text files can be used to insert into database tables, translated into other file formats like Excel, fixed-width, XML, and more. GoAnywhere MFT can read a delimited text file using a variety of user-specified options:

• Include/exclude column headings

• Field delimiters (commas, tabs, pipes, etc.)

• Record delimiters (CR, LF, CR/LF, LF/CR)

• Formatting options for dates and numbers

• Text qualifiers

• Null substitute values

• Pass in variables (at runtime) to override attributes

Writing Delimited Text

GoAnywhere MFT can create delimited text files using data extracted from databases or other files including Excel, fixed-width, and XML. The following user-specified options are available when generating a delimited text file:

• Include/exclude column headings

• Field delimiters (commas, tabs, pipes, etc.)

• Record delimiters (CR, LF, CR/LF, LF/CR)

• Formatting options for dates and numbers

• Text qualifiers

• Null substitute values

• Append to the end of existing text files

• Replace existing text files

• Pass in variables (at runtime) to override attributes

JSON Translation Java Script Object Notation (JSON) is a format used to describe data and is widely used in applications, web services, Electronic Data Interchange (EDI), and much more. GoAnywhere MFT can create JSON files using information stored in a database or pulled from other files like CSV or Excel spreadsheets. Additionally, data can be extracted from JSON files and loaded into databases or converted into other file formats. GoAnywhere MFT supports JSON objects, arrays, and fields as well as multi-level or nested elements that represent relationships.

Reading JSON

The data read from JSON documents can be imported into one or more database tables. JSON data can also be translated into other formats including Excel, delimited text and fixed-width. The following user-specified options are available when reading JSON files in GoAnywhere MFT:

• Parse multi-level JSON documents

• Specify field names and types

• Data trim options

• Formatting options for dates and numbers

• Null substitute values

• Skip invalid records

• Pass in variables (at runtime) to override attributes

Writing JSON

JSON documents can be created from data which is retrieved from one or more database tables.  Additionally, JSON documents can be created from data which is translated from other file formats including Excel, delimited text and fixed-width text.

GoAnywhere MFT can create JSON documents using a variety of user-specified options:

• Create multi-level JSON documents

• Create objects, arrays, and fields

• Formatting options for dates and numbers

• Null substitute values Data trim options

• Indention option for tidy output

• Pass in variables (at runtime) to override attributes

After a JSON document is generated, GoAnywhere MFT can post it to a RESTful Web Service or transfer it to other remote servers.

XML Translation XML is a popular format used to describe data and is widely used in applications, web services, Electronic Data Interchange (EDI), and much more. GoAnywhere MFT can create XML files using information stored in a database or pulled from other files like CSV or Excel spreadsheets. Additionally, data can be extracted from XML files and loaded into databases or converted into other file formats. GoAnywhere MFT supports simple XML elements and attributes as well as multi-level or nested elements that represent relationships.

Reading XML

The data read from XML documents can be imported into one or more database tables. XML data can also be translated into other formats including Excel, delimited text and fixed-width. The following user-specified options are available when reading XML files in GoAnywhere MFT:

• Parse multi-level XML documents

• Schema or DTD validation

• Header/Detail support

• Specify field names and types

• Data trim options

• Formatting options for dates and numbers

• Null substitute values

• Skip invalid records

• Pass in variables (at runtime) to override attributes

Writing XML

XML documents can be created from data which is retrieved from one or more database tables.  Additionally, XML documents can be created from data which is translated from other file formats including Excel, delimited text and fixed-width text. GoAnywhere MFT can create XML documents using a variety of user-specified options:

• Create multi-level XML documents

• Header/Detail support

• Custom XML tag names and attribute names

• Formatting options for dates and numbers

• Null substitute values

• Data trim options

• Indention option for tidy output

• Schema or DTD validation

• Pass in variables (at runtime) to override attributes

After an XML document is generated, GoAnywhere MFT can compress or encrypt the file and store it on the network or distribute the document to a remote server.

Product Datasheets

We remain at your disposal for more information

Request documentation Contact-us