Use an external file-based document to define the data model of the external source or target with which you want to exchange data.
The available file-based external document types are:

Document type

Description

XML

Use an XML document to exchange data in XML format without the need to code. With a document of type XML, you can read data from or write data to an XML file.

JSON

Use a JSON document to exchange data with an application that uses data-object notation. With a document of type JSON, you can read data from or write data to a JSON file.

Text

Use a Text document to read data from or write data to a file with field and line separators. For example, a CSV file.

Fixed text

Use a Fixed text document to read data from or write data to a file with defined start positions and lengths for fields.

EDI

Use an EDI document to read data from or write data to a file if you use EDIFACT or ANSI X12 for your EDI.

Microsoft Excel

Use a Microsoft Excel document to read data from or write data to a Microsoft Excel file (XLSX).

Microsoft Word

Use a Microsoft Word document to write data to Microsoft Word document (DOCX) using a template.


Application Consultant Application Consultant Start Start Which type of document  do you want to create? Which type of document  do you want to create? Set up XML document

Set up XML document

Use an XML document to exchange data in XML format without the need to code.

With a document of type XML, you can read data from or write data to an XML file.

Set up JSON document

Set up JSON document

Use a JSON document to exchange data with an application that uses data-object notation. 

With a document of type JSON, you can read data from or write data to a JSON file.

Set up Text document

Set up Text document

Use a Text document to read data from or write data to a file with field and line separators. For example, a CSV file.

Set up Fixed text document

Set up Fixed text document

Use a Fixed text document to read data from or write data to a file with defined start positions and lengths for fields.

Set up EDI document

Set up EDI document

Use an EDI document to read data from or write data to a file if you use EDIFACT or ANSI X12 for your EDI. The data in the file is structured in line with these standards.

You can use an EDI type to indicate which EDI standard is used for the EDI document. For example, EDIFACT or ANSI X12.
For each EDI type, you can set up qualifiers for an EDI segment.

Set up Microsoft Excel document

Set up Microsoft Excel document

Use a Microsoft Excel document to read data from or write data to a Microsoft Excel file (XLSX).

Set up Microsoft Word document

Set up Microsoft Word document

In Connectivity studio, use a Microsoft Word document to write data to a Microsoft Word document (DOCX) using a Microsoft Word template (DOTX).
With a Microsoft Word document, you can, for example, add data to text, include contract text, support multi-language output, or include product attributes or specifications. In this way, you can, for example, generate invoices or contracts with the style texts as defined in the template.

End End

Activities

Name Responsible Description

Set up XML document

Application Consultant

Use an XML document to exchange data in XML format without the need to code.

With a document of type XML, you can read data from or write data to an XML file.

Set up JSON document

Application Consultant

Use a JSON document to exchange data with an application that uses data-object notation. 

With a document of type JSON, you can read data from or write data to a JSON file.

Set up Text document

Application Consultant

Use a Text document to read data from or write data to a file with field and line separators. For example, a CSV file.

Set up Fixed text document

Application Consultant

Use a Fixed text document to read data from or write data to a file with defined start positions and lengths for fields.

Set up EDI document

Application Consultant

Use an EDI document to read data from or write data to a file if you use EDIFACT or ANSI X12 for your EDI. The data in the file is structured in line with these standards.
You can use an EDI type to indicate which EDI standard is used for the EDI document. For example, EDIFACT or ANSI X12.
For each EDI type, you can set up qualifiers for an EDI segment.

Set up Microsoft Excel document

Application Consultant

Use a Microsoft Excel document to read data from or write data to a Microsoft Excel file (XLSX).

Set up Microsoft Word document

Application Consultant

In Connectivity studio, use a Microsoft Word document to write data to a Microsoft Word document (DOCX) using a Microsoft Word template (DOTX).
With a Microsoft Word document, you can, for example, add data to text, include contract text, support multi-language output, or include product attributes or specifications. In this way, you can, for example, generate invoices or contracts with the style texts as defined in the template.

Set up XML document

Set up JSON document

Set up Text document

Set up Fixed text document

Set up EDI document

Set up Microsoft Excel document

Set up Microsoft Word document

Manage document record setup - External documents

Manage document record field setup - External documents

Validate connectivity setup

See also

Provide feedback