Use an external file-based document to define the data model of the external source or target with which you want to exchange data.
| 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. |
| 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. |
