1. Set Up Oracle Fusion Marketing
  2. Set Up the Initial Import of Data in Fusion Unity Data Platform

Set Up the Initial Import of Data in Fusion Unity Data Platform

After creating an Export Activity in Oracle Sales and uploading the compressed (.zip) file to a Secure FTP site, you'll need to import the data in the compressed file with an ingest job in Fusion Unity Data Platform (UDP).

Learn more about correctly formatting source files and ingest jobs so that you can successfully import data:

  • Review the import results. See Manage Jobs for more information..

Create Secure FTP Source

Follow the steps for creating a source object in the Define an Ingest Job section of this guide. You'll configure the Fusion Unity Data Platform to access the Secure FTP site you uploaded the compressed files to.

Create and Run the Ingest Job

To create and run the ingest job:

  1. Follow the steps as outlined in Define an Ingest Job.
    • Select the source you created for the Secure FTP site that has the uploaded zip files.
    • Create a sample file of the zip files with the required fields.
    • Map source fields to Fusion Unity Data Platform data model attributes.
  2. After saving the ingest job, follow the steps as outlined in Publish Changes to the Fusion Unity Data Platform.
  3. Start the ingest job and monitor the progress of the job for the following system jobs:
    • System - Data warehouse job
    • System - Identity resolution pipeline job

  4. Monitor the progress of the jobs from the Manage Jobs.

After the two system jobs successfully complete, you can follow the steps as outlined in Set Up the Ongoing Import of Oracle Sales Data.