1. Using the Oracle Unity Adapter with Oracle Integration 3
  2. Implement Common Patterns Using the Oracle Unity Adapter
  3. Export Oracle Unity Data to Different Destinations

Export Oracle Unity Data to Different Destinations

You can export Oracle Unity data to different destinations. This integration exports a segment and ingests data into Oracle Unity with the Oracle Unity Adapter. This integration only describes the Oracle Unity Adapter design portions of the integration. Design the remaining parts of the integration according to your requirements.

The segment is exported in three steps, each of which must be created in a separate Oracle Unity Adapter connection in the integration:
  • Invoke: This invokes the Segment export API.
  • Find Status: This returns the status of the Invoke API. Segment data is returned in parts. A successful response means all the data parts are ready to be queried.
  • Query Part: Once a successful status is returned in step 2, all parts are retrieved individually and written to the staging file.
  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 Oracle Unity Adapter into the integration canvas. 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 Export (Export data out of Unity).
    3. On the Export Operation page, select Segment, then select a single segment from the list.
      The Export Operation tab is selected in the left navigation pane. In the page, the Segment option is selected. Below this are the 360 Data and Metadata options. Below this is the Select Unity Segment section and Filter by name field. Below this is the list of segments available for selection.

    4. On the Export Segment Data page, select Initiate Data Query to trigger the API to invoke the segment export.
      The Export Segment Config tab is selected in the left navigation pane. The page shows the Initiate Data Query, Check the status of the Query, and Fetch Part options. Initiate Data Query is selected.

    5. On the Summary page, review your selections and click Done.
  5. Drag a second Oracle Unity Adapter into the integration canvas to check the status of the segment export. 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 Export (Export data out of Unity).
    3. On the Export Operation page, select Segment, then select the same segment you selected with the first Oracle Unity Adapter.
    4. On the Export Segment Data page, select Check the status of the Query. The status check logic must be written inside a while action.
    5. On the Summary page, review your selections and click Done.
  6. Drag a third Oracle Unity Adapter into the integration canvas to fetch the data. 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 Export (Export data out of Unity).
    3. On the Export Operations page, select Segment, then select the same segment you selected with the first and second Oracle Unity Adapters.
    4. On the Export Segment Data page, select Fetch Data Parts. Once the status is successful, fetch all the parts of the data in a for-each action and write the data into a staging file.
    5. On the Summary page, review your selections and click Done.
  7. Activate the integration. After successful activation, you can submit the integration and monitor the runtime in Oracle Integration.