1 About This Recipe

Use this recipe to synchronize data between Azure Storage and PostgreSQL upon receiving notification on Azure Event Grid.

Note:

Oracle provides this recipe as a sample only. The recipe is meant only for guidance, and is not warranted to be error-free. No support is provided for this recipe.

Overview

This recipe demonstarates how a file that is uploaded to Azure Storage gets reflected in PostgreSQL database when a notification is received on Azure Event Grid.

In this recipe, the Event grid schema is used from Azure Event Grid. GET Blob (file) is used to read the uploaded file by Azure Storage (Invoke) and Put Blob (file) is used to upload the file into Azure Storage (Invoke). The Data Import Operation is reflected in the PostgreSQL database (Invoke).

To use the recipe, you must install the recipe and configure the connection and other resources within the recipe. The recipe uses three adapters in two integration flows. The first integration flow (Oracle FTP Azure Storage Create Data) is a scheduled orchestration style integration which reads a file from FTP to upload the data in Azure Storage. The second integration flow (Oracle AEG Azure Storage PostgreSQL Data Sync) is an app-driven integration that syncs data from Azure Storage to PostgreSQL on receiving a notification on Azure Event Grid.

System and Access Requirements

  • Oracle Integration 3

  • Azure Event Grid for creating subscriptions to receive notifications, with the following roles:

    • Azure Event Grid Reader
    • Azure Event Grid Contributor
    • Azure Event Grid Sender
  • Azure Storage for uploading the files, with the following roles:

    • Data Reader
    • Data Contributor
  • A PostgreSQL database

  • An account on PostgreSQL database with the Administrator role, for importing the data.

  • A secure FTP (sFTP) server or File Server.

  • An FTP client to read the data/file from the server.