1. Using the File Adapter with Oracle Integration Generation 2
  2. Add the File Adapter Connection to an Integration (For Basic Routing Integrations)
  3. For Basic Routing Trigger Connections
  4. Format Definition Page

Format Definition Page

Enter the File Adapter format definition parameters.

Note:

If you upload an XSD file without a target namespace, a surrogate namespace is added to the XSD file that all messages then use:
http://xmlns.oracle.com/cloud/adapter/nxsd/surrogate

Creating a New Schema File

Element Description

Select a New Delimited Data File

Selects the delimited comma-separated value (CSV) file from which to create the schema file. This field appears if you selected to create a new schema on the Basic Info page of the wizard.

  • Enter the Record Name

Enter the record name. This becomes the parent element in the created schema file for the record names selected as column headers from the CSV file.

  • Enter the Recordset Name

Enter the recordset name. This becomes the root element of the created schema file.

  • Select the Field Delimiter

Select the field delimiter used in the delimited file. The following values are supported:

  • Single space

  • Comma

  • Semicolon

  • Tab

  • Character Set

Selects the encoding format for the sample data file.

  • Optionally Enclosed By

In the sample data file, the text within the selected delimiter is ignored.

  • Use the First Row as the Column Headers

Select to use the first row of the CSV file as the column headers.

  • Detach

Select to edit the CSV file in a separate window.

Using an Existing Schema File

Element Description

Select an Existing Schema from the File System

Select the existing schema file to use. This field appears if you selected an existing schema from the file system on the Basic Info page of this wizard.

  • Selected File Name

Displays the selected schema file.

  • Select the Schema Element

Select the schema element. This field is displayed after the schema file is selected. The element name is treated as the root element in the uploaded schema file.