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, Inter-application data exchange

Automate the management of inter-application data exchanges

Request documentation Contact-us

Inter-application data exchange (IDE) management in single and/or multi-platform environments

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.

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

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