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

1. Activate the recipe. See Activate a Recipe or Accelerator.
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 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 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 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 flow in Oracle Integration. See Monitor Integrations.
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.