Set up external documents - File based

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.

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.

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.

See also

Improve integration performance

Provide feedback