Table of Contents

Search

  1. Preface
  2. Connectors and connections
  3. Connection configuration
  4. Connection properties
  5. Swagger file generation for REST V2 connections

Data Integration Connections

Data Integration Connections

Flat file connection properties

Flat file connection properties

The following table describes the flat file connection properties:
Connection Property
Description
Runtime Environment
Runtime environment that contains the Secure Agent to use to access the flat files.
Do not select a runtime environment with Secure Agents that run on NTT. A flat file connection cannot use a Secure Agent that runs on NTT.
Directory
Directory where the flat file is stored. Must be accessible by all Secure Agents in the selected runtime environment.
Enter the full directory or click
Browse
to locate and select the directory.
Maximum length is 100 characters. Directory names can contain alphanumeric characters, spaces, and the following special characters:
/ \ : _ ~
The directory is the service URL for this connection type.
On Windows, the
Browse for Directory
dialog box does not display mapped drives. You can browse My Network Places to locate the directory or enter the directory name in the following format:
\\<server_name>\<directory_path>
. If network directories do not display, you can configure a login for the Secure Agent service.
Do not include the name of the flat file. You specify the file name when you create the task.
Browse button
Use to locate and select the directory where flat files are stored.
Date Format
Date format for date fields in the flat file. Default date format is:
MM/dd/yyyy HH:mm:ss
Code Page
The code page of the system that hosts the flat file. Select one of the following code pages:
  • MS Windows Latin 1. Select for ISO 8859-1 Western European data.
  • UTF-8. Select for Unicode data.
  • Shift-JIS. Select for double-byte character data.
  • ISO 8859-15 Latin 9 (Western European).
  • ISO 8859-2 Eastern European.
  • ISO 8859-3 Southeast European.
  • ISO 8859-5 Cyrillic.
  • ISO 8859-9 Latin 5 (Turkish).
  • IBM EBCDIC International Latin-1.
  • Japanese EUC (with \ <-> Yen mapping
  • IBM EBCDIC Japanese
  • IBM EBCDIC Japanese CP939
  • PC Japanese SJIS-78 syntax (IBM-942)
  • PC Japanese SJIS-90 (IBM-943)
  • MS Windows Traditional Chinese, superset of Big 5
  • Taiwan Big-5 (w/o euro update)
  • Chinese EUC
  • ISO 8859-8 Hebrew
  • PC Hebrew (old)
  • PC Hebrew (w/o euro update)
  • EBCDIC Hebrew (updated with new sheqel, control characters)
  • IBM EBCDIC US English IBM037
When you use a flat file connection with the Shift-JIS code page and a UTF data object, be sure to install fonts that fully support Unicode.