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 Invoke Connections

For Basic Routing Invoke Connections

The following pages describe how to configure a File Adapter invoke connection in a basic routing integration.

Basic Information Page

You can enter a name and description on the Basic Info page of each trigger and invoke adapter in your integration.

Element Description

What do you want to call your endpoint?
Provide a meaningful name so that others can understand the responsibilities of this connection. You can include English alphabetic characters, numbers, underscores, and dashes in the name. You cannot include the following:

  • Blank spaces (for example, My Inbound Connection)

  • Special characters (for example,  #;83& or righ(t)now4)

  • Multibyte characters

What does this endpoint do?

Enter an optional description of the connection’s responsibilities. For example: This connection receives an inbound request to synchronize account information with the cloud application.

Do you want to specify the structure for the contents of the file?

Select Yes to define a schema format for the transfer files. Select No if a schema is not required and you want to send opaque files (for example, a GIF or PNG file).

Which of the following choices would be used to describe the structure of the file contents?
Create a new schema with a CSV file or select an existing schema from your local system.

  • Sample delimited document (e.g. CSV)

  • XML schema (XSD) document

  • Sample XML document (Single on No Namespace)

  • Sample JSON document

Invoke Configure File Write Page

Enter the File Adapter invoke file write configuration properties for your integration.

Note:

You can override the values for the output location and file name pattern in the mapper. Use XPath functions in the mapper to create the output location and file name.
Element Description

Specify an Output Directory

Specifies the directory path for file writing.

File Name Pattern

Specifies the file name pattern of files transferred to the output directory. Use the pattern inside %%. For example, Oracle%SEQ%ICS.txt creates files in sequence, such as Oracle1ICS.txt, Oracle2ICS.txt, and so on. For a list of supported file patterns, click the information icon.

Append to Existing File

When selected, the file name is appended to the existing file name and is not overwritten.

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.

Summary Page

You can review the specified adapter configuration values on the Summary page.

Element Description

Summary

Displays a summary of the configuration values you defined on previous pages of the wizard.

The information that is displayed can vary by adapter. For some adapters, the selected business objects and operation name are displayed. For adapters for which a generated XSD file is provided, click the XSD link to view a read-only version of the file.

To return to a previous page to update any values, click the appropriate tab in the left panel or click Back.

To cancel your configuration details, click Cancel.