1. Sync Data between Azure Storage and PostgreSQL Upon Receiving Notification on Azure Event Grid
  2. Activate and Run the Recipe

4 Activate and Run the Recipe

After you've configured the connections and other resources, you can activate and run the recipe.

  1. In the project workspace, click Activate. In the Activate project panel, with the default project deployment selected, choose an appropriate tracing option, then click Activate.

    A message confirms that the integrations have been activated. Refresh the page to view the updated status of the integrations.

  2. Update integration property values for the Oracle FTP Azure Storage Create Data and Oracle AEG Azure Storage PostgreSQL Data Sync integration flows.
    1. In the Integrations section, click Actions Actions icon on the integration flow, then select Update property values.
    2. In the Update property values panel, update the integration properties with appropriate values.
      • EmailTo: This integration property holds the email ID to which error notifications are to be sent.
      • retryCount: This integration property holds the number of retries when an invoke fails. The default value is 3.
    3. Click Submit.

      A message confirms that the integration properties have been updated successfully.

  3. Run the Oracle FTP Azure Storage Create Data integration flow.
    1. In the Integrations section of the project workspace, click Actions Actions icon on the integration flow, then select Run.
    2. On the Configure and run page, click Run.

      You've now successfully submitted the integration for execution. The integration now reads a file from FTP and creates the data in Azure Storage.

      Note:

      You can also schedule this integration to run at a date, time, and frequency of your choosing. See Define the Integration Schedule.
  4. Run the Oracle AEG Azure Storage PostgreSQL Data Sync integration flow.
    1. In the Integrations section of the project workspace, click Actions Actions icon on the integration flow, then select Run.
    2. On the Configure and run page, click Run.

      You've now successfully submitted the integration for execution. The integration now synchronizes data from Azure Storage to PostgreSQL on receiving a notification on Azure Event Grid.

      Note:

      To run the recipe, you must create a subscription in Azure Event Grid and a database table in PostgreSQL.

      Note:

      You can also schedule this integration to run at a date, time, and frequency of your choosing. See Define the Integration Schedule.
  5. Monitor the running of the integration flows in Oracle Integration.
    1. In the project workspace, click Observe. You'll see the integration flows being triggered and running successfully.
    2. To manage errors in your project, see Manage Errors in a Project.
  6. Log in to the Azure Event Grid instance and check for the notification received.
    1. Click the wired message.
    2. Click the eye icon to open the message.
    3. Observe the Blob-created message.
      Thus, you have successfully received a notification on uploading a file.
  7. Log in to the PostgreSQL instance, and check for the data created.
    1. On the DB visualizer, create a successful connection.
    2. Enter the query as select * from tablename;.
    3. Observe if the data has been imported successfully.
    4. Cross-verify the file data and imported data into the database.
      Thus, you have successfully imported data from Azure Storage into PostgreSQL database.

Related Documentation