1. Using the Oracle Unity Adapter with Oracle Integration Generation 2
  2. Implement Common Patterns Using the Oracle Unity Adapter
  3. Read a File from an FTP Server and Ingest the Data into Oracle Unity

Read a File from an FTP Server and Ingest the Data into Oracle Unity

You can ingest data from different sources into Oracle Unity. This use case provides an overview of how to read a file from an FTP server and ingest the data into Oracle Unity using the Oracle Unity Adapter.

  1. Create an FTP Adapter connection to an FTP server.
  2. Create an Oracle Unity Adapter connection to Oracle Unity.
  3. Create a scheduled orchestrated integration.
  4. Drag the FTP Adapter into the integration canvas. The Adapter Endpoint Configuration Wizard is displayed.
  5. Provide information about the location of the file to read, the file format, and other details.
  6. Perform the source to target mappings between the schedule and the FTP Adapter.
  7. Drag the Oracle Unity Adapter into the integration canvas after the FTP Adapter. The Adapter Endpoint Configuration Wizard is displayed.
    1. On the Basic Info page, enter a name and optional description.
    2. On the Operations page, select Ingest (Ingest data into Unity).
    3. On the Ingest Config page, select the entities into which to ingest data. For this example, Customer is selected.
      This image shows the Ingest Config tab selected in the left navigation pane. To the right are the Select Unity Entity, Available Entities, and Selected Entities sections. SourceID, Customer is displayed in the Selected Entities section.

    4. On the Ingest Fields page, select the entity fields into which to save the data. These fields are available in the mapper. For this example, SourceID, SourceCustomerID, and Email are selected. The message at the bottom of the page tells you to use the resource name customers for this entity in the mapper.
      This image shows the Ingest Fields tab selected in the left navigation pane. To the right are the Select Data Source Fields, Available Field, and Selected Fields sections. SourceID, SourceCustomerID, and Email are displayed in the Selected Fields section.

    5. On the Summary page, review your selections and click Done.
  8. In the mapper, perform the following steps:
    • Map the input fields from the sFTP server file. The resource name customers is displayed for mapping in the mapper.
    • Map the field attributes.

    The Map to writeToUnity name appears at the top left. Below are the Designer, Code, Test, and Recommend links. At the far right are the Developer, XSLT, View, and Filter links. Below are the Sources, Mapping Canvas, and Target areas. The Sources element customers is expanded to show the elements that have been mapped to Target customer elements.

    When complete, the integration looks as follows.
    The completed integration shows the scheduler, mapper, FTP Adapter, mapper, Oracle Unity Adapter, and end icons.

  9. Activate the integration. After successful activation, you can submit the integration and monitor the runtime in Oracle Integration.
  10. Run the data warehouse (DW) job in Oracle Unity to see the ingested data persist in the corresponding entities.