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 schedule 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 Entities page, select the entities into which to ingest data. For this example, Customer is selected.
   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.
   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.
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.