Oracle® Public Cloud Machine

Using the FTP Adapter

Release 16.3.1

E74251-02

October 2016

This guide describes how to configure and add the FTP Adapter to an integration in Oracle Integration Cloud ServiceOracle Integration Cloud Service.

Oracle Public Cloud Machine Using the FTP Adapter, Release 16.3.1

E74251-02

Copyright © 2015, 2016, Oracle and/or its affiliates. All rights reserved.

Primary Author: Mark Kennedy

This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited.

The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please report them to us in writing.

If this is software or related documentation that is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government, the following notice is applicable:

U.S. GOVERNMENT END USERS: Oracle programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, delivered to U.S. Government end users are "commercial computer software" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, use, duplication, disclosure, modification, and adaptation of the programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, shall be subject to license terms and license restrictions applicable to the programs. No other rights are granted to the U.S. Government.

This software or hardware is developed for general use in a variety of information management applications. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications.

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are used under license and are trademarks or registered trademarks of SPARC International, Inc. AMD, Opteron, the AMD logo, and the AMD Opteron logo are trademarks or registered trademarks of Advanced Micro Devices. UNIX is a registered trademark of The Open Group.

This software or hardware and documentation may provide access to or information about content, products, and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third-party content, products, and services unless otherwise set forth in an applicable agreement between you and Oracle. Oracle Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of third-party content, products, or services, except as set forth in an applicable agreement between you and Oracle.

Contents

Preface

- Audience

- Related Resources

- Conventions

1 Getting Started with the FTP Adapter

- About the FTP Adapter

- About Oracle Integration Cloud Service

- About Oracle Integration Cloud Service Connections

- About Oracle Integration Cloud Service Integrations

- Typical Workflow for Creating and Including an Adapter Connection in an Integration

2 Creating an FTP Adapter Connection

- Prerequisites for Creating a Connection

- Creating a Connection

- Adding a Contact Email

- Configuring Connection Properties

- Configuring Connection Security

- Testing the Connection

- Editing a Connection

- Cloning a Connection

- Deleting a Connection

3 Creating an Integration

4 Adding the FTP Adapter Connection to an Integration

- Configuring Basic Information Properties

- What You Can Do from the Basic Info Page

- What You See on the Basic Info Page

- Configuring FTP Adapter Trigger Configure File Read Properties

- What You Can Do from the FTP Adapter Configure File Read Page

- What You See on the FTP Adapter Configure File Read Page

- Configuring FTP Adapter Format Definition Properties

- What You Can Do from the FTP Adapter Format Definition Page

- What You See on the FTP Adapter Format Definition Page

- Configuring FTP Adapter Invoke Configure File Write Properties

- What You Can Do from the FTP Adapter Configure File Write Page

- What You See on the FTP Adapter Configure File Write Page

- Configuring FTP Adapter Invoke PGP Configuration Properties

- What You Can Do from the FTP Adapter PGP Configuration Page

- What You See on the FTP Adapter PGP Configuration Page

- Reviewing Configuration Values on the Summary Page

- What You Can Do from the Summary Page

- What You See on the Summary Page

5 Creating Mappings and Lookups in Integrations

6 Administering Integrations

Preface

Topics:

Using the FTP Adapter describes how to configure the FTP Adapter as a connection in an integration in Oracle Integration Cloud Service.

- Audience

- Related Resources

- Conventions

Audience

Using the FTP Adapter is intended for developers who want to use the FTP Adapter in integrations in Oracle Integration Cloud Service.

Related Resources

For more information, see these Oracle resources:

- Using Oracle Integration Cloud Service

- Using the Oracle Mapper

- Oracle Public Cloud Machine documentation in the Oracle Help Center:

http://docs.oracle.com

Conventions

The following text conventions are used in this document:

Convention

Meaning

boldface

Boldface type indicates graphical user interface elements associated with an action, or terms defined in text or the glossary.

italic

Italic type indicates book titles, emphasis, or placeholder variables for which you supply particular values.

monospace

Monospace type indicates commands within a paragraph, URLs, code in examples, text that appears on the screen, or text that you enter.

1 Getting Started with the FTP Adapter

Review the following conceptual topics to learn about the FTP Adapter and how to use it as a connection in integrations in Oracle Integration Cloud Service. A typical workflow of adapter and integration tasks is also provided.

Topics

- About the FTP Adapter

- About Oracle Integration Cloud Service

- About Oracle Integration Cloud Service Connections

- About Oracle Integration Cloud Service Integrations

- Typical Workflow for Creating and Including an Adapter Connection in an Integration

About the FTP Adapter

The FTP Adapter enables you to transfer files to an invoke FTP server in an integration in Oracle Integration Cloud Service.

The FTP Adapter provides the following benefits:

- Transfers (writes) files to any publicly accessible server in either binary or ASCII format.

- Enables you to create integrations in which a file is read from a trigger FTP server and transferred (written) to an invoke FTP server. For these integration scenarios, you can schedule the time and frequency at which the transfer occurs. For more information, see Scheduling Integration Runs.

- Supports a synchronous one-way request message exchange pattern. There is no response from the FTP Adapter.

- Enables you to create a schema file format to use for the files to transfer. The schema can be created (sampled) from either a comma-separated value (CSV) file or from an existing schema file. Supported delimiters in the file are single spaces, commas, semicolons, or tabs.

- Enables you to encrypt or decrypt the invoke (outbound) message file to transfer using Pretty Good Privacy (PGP) cryptography.

The FTP Adapter is one of many predefined adapters included with Oracle Integration Cloud Service. You can configure the FTP Adapter as a connection in an integration in Oracle Integration Cloud Service. For information about Oracle Integration Cloud Service, connections, and integrations, see the following sections:

- About Oracle Integration Cloud Service

- About Oracle Integration Cloud Service Connections

- About Oracle Integration Cloud Service Integrations

About Oracle Integration Cloud Service

Oracle Integration Cloud Service is a complete, secure, but lightweight integration solution that enables you to connect your applications in the cloud. It simplifies connectivity between your applications, and can connect both your applications that live in the cloud and your applications that still live on premises. Oracle Integration Cloud Service provides secure, enterprise-grade connectivity regardless of the applications you are connecting or where they reside.

Oracle Integration Cloud Service provides native connectivity to Oracle Software as a Service (SaaS) applications, such as Oracle Sales Cloud, Oracle RightNow Cloud, and so on. Oracle Integration Cloud Service adapters simplify connectivity by handling the underlying complexities of connecting to applications using industry-wide best practices. You only need to create a connection that provides minimal connectivity information for each system. Oracle Integration Cloud Service lookups map the different codes or terms used by the applications you are integrating to describe similar items (such as country or gender codes). Finally, the visual data mapper enables you to quickly create direct mappings between the trigger and invoke data structures. From the mapper, you can also access lookup tables and use standard XPath functions to map data between your applications.

Once you integrate your applications and activate the integrations to the runtime environment, the dashboard displays information about the running integrations so you can monitor the status and processing statistics for each integration. The dashboard measures and tracks the performance of your transactions by capturing and reporting key information, such as throughput, the number of messages processed successfully, and the number of messages that failed processing. You can also manage business identifiers that track fields in messages and manage errors by integrations, connections, or specific integration instances.

About Oracle Integration Cloud Service Connections

Connections define information about the instances of each predefined configuration you are integrating. Oracle Integration Cloud Service includes a set of predefined adapters, which are the types of applications on which you can base your connections, such as Oracle Sales Cloud, Oracle Eloqua Cloud, Oracle RightNow Cloud, and others. A connection is based on an adapter. A connection includes the additional information required by the adapter to communicate with a specific instance of an application (this can be referred to as metadata or as connection details). For example, to create a connection to a specific RightNow Cloud application instance, you must select the Oracle RightNow adapter and then specify the WSDL URL, security policy, and security credentials to connect to it.

Video

About Oracle Integration Cloud Service Integrations

Integrations are the main ingredient of Oracle Integration Cloud Service. An integration includes at the least a trigger (source) connection (for requests sent to Oracle Integration Cloud Service) and invoke (target) connection (for requests sent from Oracle Integration Cloud Service to the target) and the field mapping between those two connections.

When you create your integrations, you build on the connections you already created by defining how to process the data for the trigger (source) and invoke (target) connections. This can include defining the type of operations to perform on the data, the business objects and fields against which to perform those operations, required schemas, and so on. To make this easier, the most complex configuration tasks are handled by Oracle Integration Cloud Service. Once your trigger (source) and invoke (target) connections are configured, the mappers between the two are enabled so you can define how the information is transferred between the trigger (source) and invoke (target) data structures for both the request and response messages.

Video

Typical Workflow for Creating and Including an Adapter Connection in an Integration

You follow a very simple workflow to create a connection with an adapter and include the connection in an integration in Integration Cloud Service.

This table lists the workflow steps for both adapter tasks and overall integration tasks, and provides links to instructions for each step.

Step

Description

More Information

1

Create the adapter connections for the applications you want to integrate. The connections can be reused in multiple integrations and are typically created by the administrator.

Creating an FTP Adapter Connection

2

Create the integration. When you do this, you add trigger and invoke connections to the integration.

Creating an Integration and Adding the FTP Adapter Connection to an Integration

3

Map data between the trigger connection data structure and the invoke connection data structure.

Mapping Integration Cloud Service Data of Using Oracle Integration Cloud Service

4

(Optional) Create lookups that map the different values used by those applications to identify the same type of object (such as gender codes or country codes).

Creating Lookups of Using Oracle Integration Cloud Service

5

Activate the integration.

Managing Integrations of Using Oracle Integration Cloud Service

6

Monitor the integration on the dashboard.

Monitoring Integration Cloud Services of Using Oracle Integration Cloud Service

7

Track payload fields in messages during runtime.

Assigning Business Identifiers for Tracking Fields in Messages and Managing Business Identifiers for Tracking Fields in Messages of Using Oracle Integration Cloud Service

8

Manage errors at the integration level, connection level, or specific integration instance level.

Managing Errors of Using Oracle Integration Cloud Service

2 Creating an FTP Adapter Connection

A connection is based on an adapter. You define connections to the specific cloud applications that you want to integrate. The following topics describe how to define connections:

Topics

- Prerequisites for Creating a Connection

- Creating a Connection

- Editing a Connection

- Cloning a Connection

- Deleting a Connection

Prerequisites for Creating a Connection

You must satisfy the following prerequisites for creating a connection with the FTP Adapter.

- Ensure that the target FTP server is publicly accessible (that is, not behind a firewall, unless the firewall has been opened for outside FTP client access).

- Ensure that you have write permissions on the FTP server directory to which to transfer files.

- Ensure that you have read permissions on the FTP server directory from which to transfer files.

- Know the host name or IP address and port number of the FTP server.

- Know the user name and password for connecting to the FTP server.

- If want to use an FTP over OpenSSL certificate, know the location of the .p12 format certificate to upload.

Creating a Connection

The first step in creating an integration is to create the connections to the applications with which you want to share data.

1. In the Integration Cloud Service toolbar, click Designer.

2. On the Designer Portal, click Connections.

3. Click Create New Connection.

The Create Connection — Select Adapter dialog is displayed.

4. Select an adapter from the dialog. You can also search for the type of adapter to use by entering a partial or full name in the Search field, and clicking Search.
The New Connection — Information dialog is displayed.

5. Enter the information to describe the connection. Use a meaningful name to help others find your connection when they begin to create their own integrations.

6. Click Create.
Your connection is created and you are now ready to configure connection details, such as email contact, connection properties, security policies, and connection login credentials.

Adding a Contact Email

From the Connection Administrator section of the connection, you can add a contact email address for notifications.

1. In the Email Address field, enter an email address to receive email notifications when problems occur.

2. In the upper right corner, click Save.

Configuring Connection Properties

Enter connection information so your application can process requests.

1. Click Configure Connectivity.
The Connection Properties dialog is displayed.

2. In the FTP Server Host Address field, enter the host address of the FTP server.

3. In the FTP Server Port field, enter the FTP server port number.

4. If you are using an FTP over OpenSSL certificate, select the SSL Certificate checkbox, then click Upload to upload a .p12 format certificate.

5. If you plan to specify a processing delay value of greater than zero when configuring the trigger FTP Adapter in the Adapter Endpoint Configuration Wizard, select your FTP server time zone from the FTP Server Time Zone dropdown list. This is because the server checks the difference in the time stamp of the file. If you do not select a time zone, the default value is that of the Oracle Integration Cloud Service server. This can delay the processing of files for up to 12 hours. For more information about specifying a processing delay, see What You See on the FTP Adapter Configure File Read Page.

6. Click OK.
You are now ready to configure connection security.

Configuring Connection Security

Configure security for your FTP connection by selecting the security policy and setting login credentials. An FTP connection is only allowed for publicly accessible FTP servers.

1. Click Configure Credentials.

2. Enter your login credentials.

a. Note that only the FTP Server Access Policy is supported and cannot be deselected.

b. Enter a username and password to connect to the FTP server.

c. Reenter the password a second time.
The FTP Adapter supports a nonmanaged connection factory.

d. If you uploaded an FTP over OpenSSL certificate, enter the password for the .p12 format certificate.

e. Reenter the password a second time.

3. Click OK.
You are now ready to test your connection.

Testing the Connection

Test your connection to ensure that it is successfully configured.

1. In the upper right corner of the page, click Test.
If successful, the following message is displayed and the progress indicator shows 100%.
The connection test was successful!

2. If your connection was unsuccessful, an error message is displayed with details. Verify that the configuration details you entered are correct.

3. When complete, click Save.

Editing a Connection

You can edit connection settings after creating a new connection.

1. In the Oracle Integration Cloud Service toolbar, click Designer.

2. On the Designer Portal, click Connections.

3. On the Connections page, select Edit from the connection Actions menu or click the connection name.

The Connection page is displayed.

4. To edit the notification email contact, change the email address in the Email Address field.

5. To edit the connection properties, click Configure Connectivity. Note that some connections do not include this button. If your connector does not include a Configure Connectivity button, then click the Configure Credentials button.

Cloning a Connection

You can clone a copy of an existing connection. It is a quick way to create a new connection.

1. In the Oracle Integration Cloud Service toolbar, click Designer.

2. On the Designer Portal, click Connections.

3. On the Connections page, select Clone from the connection Actions menu.

The Clone Connection dialog is displayed.

4. Enter the connection information.

5. Click Clone.

6. Click Edit to configure the credentials of your cloned connection. Cloning a connection does not copy the credentials.

See Editing a Connection for instructions.

Deleting a Connection

You can delete a connection from the connection menu.

1. In the Oracle Integration Cloud Service toolbar, click Designer.

2. On the Designer Portal, click Connections.

3. On the Connections page, click Delete from the connection Actions menu.

The Delete Connection dialog is displayed if the connection is not used in an integration.

4. Click Yes to confirm deletion.

3 Creating an Integration

Integrations use the adapter connections you created to your applications, and define how information is shared between those applications. You can create, import, modify, or delete integrations; create integrations to publish or subscribe to messages; add and remove request and response enrichment triggers; and create routing paths for different invoke endpoints in integrations. Click the following topics for more information.

Topic

- Creating Integrations (in Using Oracle Integration Cloud Service)

4 Adding the FTP Adapter Connection to an Integration

When you drag the FTP Adapter into the trigger or invoke area of an integration, the Adapter Endpoint Configuration Wizard is invoked. This wizard guides you through configuration of FTP Adapter endpoint properties.

The following sections describe the wizard pages that guide you through configuration of the FTP Adapter as a trigger or invoke in an integration. If you configure the FTP Adapter as a trigger connection in an integration, the only adapter that you can configure as an invoke connection in that same integration is another FTP Adapter. If you configure the FTP Adapter as an invoke connection in an integration, then any adapter can be configured as the trigger connection in that same integration.

Topics

- Configuring Basic Information Properties

- Configuring FTP Adapter Trigger Configure File Read Properties

- Configuring FTP Adapter Format Definition Properties

- Configuring FTP Adapter Invoke Configure File Write Properties

- Configuring FTP Adapter Invoke PGP Configuration Properties

- Reviewing Configuration Values on the Summary Page

For more information about the FTP Adapter, see About the FTP Adapter.

Configuring Basic Information Properties

Enter the basic information parameters.

Topics

- What You Can Do from the Basic Info Page

- What You See on the Basic Info Page

What You Can Do from the Basic Info Page

You can specify the following values on the Basic Info page. The Basic Info page is the initial wizard page that is displayed whenever you drag the FTP Adapter to the trigger or invoke area.

- Specify a meaningful name.

- Specify a description of the responsibilities.

- Select whether or not to define a schema for the files to transfer.

- Specify whether to create a new schema or select an existing schema.

- Select if you want to encrypt or decrypt the target (outbound) file to transfer using Pretty Good Privacy (PGP) cryptography.

What You See on the Basic Info Page

The following table describes the key information on the Basic Info page.

Element

Description

What do you want to call your endpoint?

Provide a meaningful name so that others can understand the connection. For example, FTPReadWriteConnection. You can include English alphabetic characters, numbers, underscores, and dashes in the name. You cannot include the following:

- Blank spaces (for example, My FTP 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 transfers files to a directory.

Do you want to define a schema for this endpoint?

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

Note: If configuring the FTP Adapter in the trigger (inbound) direction, schema selection is not supported. If you select Yes and upload a schema, it is not used. You must select No to transfer files as an attachment.

Do you want to create a new schema or select an existing one?

Select an option:

- Create a new schema from a CSV file: Select to create a new schema file from a comma-separated value (CSV) file. On a subsequent page of this wizard, you are prompted to select the CSV file from which to create the schema.

- Select an existing schema from the file system: Select an existing schema file. On a subsequent page of this wizard, you are prompted to select the existing schema (XSD) file from the file system.

Do you want to encrypt or decrypt the message?

Note: This selection is only available in the invoke (outbound) direction.

Select this checkbox if you want to encrypt or decrypt the file to transfer using Pretty Good Privacy (PGP) cryptography. If you select this checkbox, the PGP Configuration page is displayed later in this wizard.

Configuring FTP Adapter Trigger Configure File Read Properties

Enter the FTP Adapter trigger file read parameters.

Topics

- What You Can Do from the FTP Adapter Configure File Read Page

- What You See on the FTP Adapter Configure File Read Page

What You Can Do from the FTP Adapter Configure File Read Page

You can configure the following parameters on the invoke FTP Adapter Configure File Read page.

- Select the transfer mode for the files (ASCII or binary).

- Specify the directory path from which to transfer (read) files.

- Select the pattern name for files to transfer.

- Specify the maximum number of files to transfer.

- Specify the chunk size.

- Specify the processing delay.

- Optionally select to delete the file from the directory from which it was read after the transfer is successful.

What You See on the FTP Adapter Configure File Read Page

The following table describes the key information on the FTP Adapter Configure File Read page.

Element

Description

Select a Transfer Mode

Select the transfer mode:

- ASCII: Transfers special control characters to format the data.

- Binary: Transfers raw bytes of the file data.

Specify an Input Directory

Specify the directory path from which to read the files to transfer (for example, /Oracle/input/file/).

Specify a File Name Pattern

Specify the pattern of file names to transfer from the input 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.

Maximum Files

Specify the maximum number of files to be processed in one scheduled call. If the schedule is every hour, then every hour the maximum number of files must be processed. For information about scheduling, see Scheduling Integration Runs.

Chunk Size

Enter the portion of the file to transfer in MBs. This action enables you to break up the transfer of very large files into smaller (chunked) portions.

Processing Delay

Specify the delay in seconds. After a file is created, the value specified indicates how long to wait to process the file. For example, if a file is created at 11:02:30 and a processing delay of 60 seconds is provided, the file is not picked up until 11:03:30 for processing.

If you specify a processing delay value of greater than zero, select your FTP server time zone from the FTP Server Time Zone dropdown list in the Connection Properties dialog. This is because the server checks the difference in the time stamp of the file. If you do not select a time zone, the default value is that of the Oracle Integration Cloud Service server. This can delay the processing of files for up to 12 hours. For more information, see Configuring Connection Properties.

Delete Files After Successful Retrieval

Select to delete the file from the directory from which it was read after the transfer is successful. If the transfer is initially unsuccessful and the transfer is resubmitted, the source file is deleted after the resubmitted transfer is successful.

Configuring FTP Adapter Format Definition Properties

Enter the FTP Adapter format definition parameters.

Topics

- What You Can Do from the FTP Adapter Format Definition Page

- What You See on the FTP Adapter Format Definition Page

What You Can Do from the FTP Adapter Format Definition Page

You can configure the following parameters on the FTP Adapter Format Definition page.

- Create a new schema file from a comma-separated value (CSV) file.

- Use an existing schema file.

What You See on the FTP Adapter Format Definition Page

The following tables describe the key information on the FTP Adapter Format Definition page.

The fields that display on the Format Definition page are determined by your selection on the Basic Info page:

- Selected to create a new schema file

- Selected to use an existing schema file

Note:
If configuring the FTP Adapter in the trigger (inbound) direction, schema selection is not supported. If you select Yes to define a schema for the endpoint on the Basic Info page, nothing prevents you from uploading a schema on the Format Definition page. However, this schema is not used. You must select No on the Basic Info page to transfer files as an attachment.

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 one of the following supported file delimiter options:

- Single space

- Comma

- Semicolon

- Tab

- Use the First Row of the File as the Column Headers

Displays by default the first row of the selected CSV file as the column headers.

- Detach

Select to edit the CSV file in a separate window.

Editable Column Headers

Edit the column headers of the table, as needed.

Data Types

Select the data type (for example, string, byte, integer, and so on) to use for each column in the table.

Using an Existing Schema File

Element

Description

Select a New File

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 name.

- 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.

Configuring FTP Adapter Invoke Configure File Write Properties

Enter the FTP Adapter invoke file write parameters.

Topics

- What You Can Do from the FTP Adapter Configure File Write Page

- What You See on the FTP Adapter Configure File Write Page

What You Can Do from the FTP Adapter Configure File Write Page

You can configure the following parameters on the invoke FTP Adapter Configure File Write page.

- Select the transfer mode for the files (ASCII or binary).

- Specify the directory path to which to transfer files.

- Select the pattern name for files to transfer.

- Optionally select to append files to an existing file name.

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.

What You See on the FTP Adapter Configure File Write Page

The following table describes the key information on the FTP Adapter Configure File Write page.

Element

Description

Select a Transfer Mode

Select the transfer mode:

- ASCII: Transfers special control characters to format the data.

- Binary: Transfers raw bytes of the file data.

Specify an Output Directory

Specify the directory path to which to transfer files (for example, /Oracle/output/file/).

Specify a File Name Pattern

Specify the pattern of file names to transfer 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

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

Configuring FTP Adapter Invoke PGP Configuration Properties

Enter the FTP Adapter invoke PGP configuration parameters.

Topics

- What You Can Do from the FTP Adapter PGP Configuration Page

- What You See on the FTP Adapter PGP Configuration Page

What You Can Do from the FTP Adapter PGP Configuration Page

You can configure the following parameters on the invoke FTP Adapter PGP Configuration page.

Pretty Good Privacy (PGP) is a data encryption and decryption program that provides cryptographic privacy and authentication for encrypting and decrypting message files. Message file encryption uses a serial combination of hashing, data compression, symmetric-key cryptography, and public-key cryptography. Each step uses one of several supported algorithms. Each public key is bound to a user name, an e-mail address, or both.

- If you select to encrypt the message file, you are prompted to enter the following information:

- Format the message file in ASCII-armor.

- Select the cypher algorithm.

- Select the PGP public key to upload.

- If you select to decrypt the message file, you are prompted to enter the following information:

- Select the PGP private key to upload.

- Specify the private key password.

What You See on the FTP Adapter PGP Configuration Page

The following tables describe the key information on the FTP Adapter PGP Configuration page.

The fields that are displayed on this page are based on whether you select to encrypt or decrypt the message file to transfer using Pretty Good Privacy (PGP) cryptography.

Select to Encrypt

Element

Description

Format the Encrypted Message in ASCII-Armor

Select to format the encrypted message in ASCII armor. ASCII armor is a binary-to-textual encoding converter. ASCII armor formats encrypted messaging in ASCII. This enables messages to be sent in a standard messaging format. This selection impacts the visibility of message content. If not selected, the message is sent in binary format.

Select the Cipher Algorithm

Select the symmetric cryptographic algorithm to use. Symmetric-key algorithms for cryptography use the same cryptographic keys for both encryption of plain text and decryption of cipher text.

- CAST5

- 3DES

- AES128

- AES192

- AES256

Select the PGP Public Key to Upload

Click Browse to select the PGP public key to use for encryption.

Select to Decrypt

Element

Description

Select the PGP Private Key to Upload

Click Browse to select the private key to use for decryption.

Specify the Private Key Password

Specify the private key password to use to decrypt this message. Only the private key belonging to the receiver can decrypt the key.

Reviewing Configuration Values on the Summary Page

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

Topics

- What You Can Do from the Summary Page

- What You See on the Summary Page

What You Can Do from the Summary Page

You can review trigger (source) or invoke (target) configuration details from the Summary page. The Summary page is the final wizard page for each adapter after you have completed your configuration.

- View the configuration details you defined for the trigger (source) or invoke (target) adapter. For example, if you have defined an inbound trigger (source) adapter with a request business object and immediate response business object, specific details about this configuration are displayed on the Summary page.

- Click Done if you want to save your configuration details.

- Click a specific tab in the left panel or click Back to access a specific page to update your configuration definitions.

- Click Cancel to cancel your configuration details.

What You See on the Summary Page

The following table describes the key information on the Summary page.

Element

Description

Summary

Displays a summary of the trigger (source) or invoke (target) 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.

5 Creating Mappings and Lookups in Integrations

You must map data between trigger connections and invoke connections in integrations. You can also optionally create lookups in integrations.

Topics

- Mapping Integration Cloud Service Data (in Using Oracle Integration Cloud Service)

- Creating Lookups (in Using Oracle Integration Cloud Service)

6 Administering Integrations

Oracle Integration Cloud Service provides you with the information and tools required to activate, monitor, and manage your integrations in the runtime environment.

Topic

- Administering Integration Cloud Service (in Using Oracle Integration Cloud Service)

Oracle Legal Notices

Copyright Notice

Copyright © 1994-2017, Oracle and/or its affiliates. All rights reserved.

License Restrictions Warranty/Consequential Damages Disclaimer

This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited.

Warranty Disclaimer

The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please report them to us in writing.

Restricted Rights Notice

If this is software or related documentation that is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government, then the following notice is applicable:

U.S. GOVERNMENT END USERS: Oracle programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, delivered to U.S. Government end users are "commercial computer software" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, use, duplication, disclosure, modification, and adaptation of the programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, shall be subject to license terms and license restrictions applicable to the programs. No other rights are granted to the U.S. Government.

Hazardous Applications Notice

This software or hardware is developed for general use in a variety of information management applications. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications.

Trademark Notice

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are used under license and are trademarks or registered trademarks of SPARC International, Inc. AMD, Opteron, the AMD logo, and the AMD Opteron logo are trademarks or registered trademarks of Advanced Micro Devices. UNIX is a registered trademark of The Open Group.

Third-Party Content, Products, and Services Disclaimer

This software or hardware and documentation may provide access to or information about content, products, and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third-party content, products, and services unless otherwise set forth in an applicable agreement between you and Oracle. Oracle Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of third-party content, products, or services, except as set forth in an applicable agreement between you and Oracle.

Alpha and Beta Draft Documentation Notice

If this document is in preproduction status:

This documentation is in preproduction status and is intended for demonstration and preliminary use only. It may not be specific to the hardware on which you are using the software. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to this documentation and will not be responsible for any loss, costs, or damages incurred due to the use of this documentation.

Private Alpha and Beta Draft Documentation Notice

If this document is in private preproduction status:

The information contained in this document is for informational sharing purposes only and should be considered in your capacity as a customer advisory board member or pursuant to your beta trial agreement only. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described in this document remains at the sole discretion of Oracle.

This document in any form, software or printed matter, contains proprietary information that is the exclusive property of Oracle. Your access to and use of this confidential material is subject to the terms and conditions of your Oracle Master Agreement, Oracle License and Services Agreement, Oracle PartnerNetwork Agreement, Oracle distribution agreement, or other license agreement which has been executed by you and Oracle and with which you agree to comply. This document and information contained herein may not be disclosed, copied, reproduced, or distributed to anyone outside Oracle without prior written consent of Oracle. This document is not part of your license agreement nor can it be incorporated into any contractual agreement with Oracle or its subsidiaries or affiliates.

Documentation Accessibility

For information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program website at http://www.oracle.com/pls/topic/lookup?ctx=acc&id=docacc.

Access to Oracle Support

Oracle customers that have purchased support have access to electronic support through My Oracle Support. For information, visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=info or visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=trs if you are hearing impaired.