Use the GCP Storage Adapter to Import Data Files into Google Cloud Storage

This use case describes how to import data files from an FTP server into Google Cloud Storage. Similarly, you can import data files from an application into Google Cloud Storage using the GCP Storage Adapter.

To perform this operation, you must create the REST Adapter, FTP Adapter, and GCP Storage Adapter connections in Oracle Integration.
  1. Create an application integration.
  2. Drag the REST Adapter into the integration canvas.
  3. Configure the REST Adapter as follows.
    1. On the Basic Info page, provide the endpoint name.
    2. On the Resource Configuration page, the following details are specified or selected for this use case:
      1. Provide the endpoint’s relative resource URI (for example, /upload/{fileName}).
      2. Select the GET action.
      3. Select the Add and review parameters for this endpoint check box.
      4. Select the Configure this endpoint to receive the response check box.
    3. On the Request Parameters page, select the string type.
    4. On the Response page, select JSON Sample in the Select the response payload format field.
    5. Click inline and provide a valid JSON payload.
    6. Review your selections on the Summary page.
  4. Drag the FTP Adapter into the integration canvas.
  5. Configure the FTP Adapter as follows:
    1. On the Basic Info page, provide a name.
    2. On the Operations page, select Read a File from the Select operation list.
    3. Select Binary from the Select a Transfer Mode list.
    4. Provide the input directory and file name.
    5. On the Schema page, select No.
    6. Review your selections on the Summary page.
  6. In the mapper, map the source (REST) File Name to the target (FTP) Filename.
  7. Drag the GCP Storage Adapter into the integration canvas.
  8. Configure the GCP Storage Adapter as follows:
    1. On the Basic info page, provide an endpoint name, select Objects as a resource, and select Upload Object as an action.
    2. On the Configuration page, select the bucket name.
    3. On the Summary page, review your selections.
  9. In the mapper, map the source (REST) File Reference element to the target (Google Cloud Storage) Stream Reference element and Filename to name.
  10. In the REST Response mapper, map the source (InvokeGCP Response) to the target (TriggerREST Response) as follows.

    The Sources, Mapping canvas, and Target sections are shown. The source Self Link, Media Link, Name, and Bucket elements under Body are mapped to the target Self Link, Media Link, Name, and Bucket elements under Response mapper.

  11. Add the tracking variable element in the Business Identifier field.
  12. When complete, activate the integration. As a result, the GCP Storage Adapter inserts the file or object into the respective bucket.
    The completed integration looks as follows.


    The trigger, map, invoke, map, invoke, and map elements are shown.