2 Before You Install the Recipe

You must perform the following configuration tasks on your FTP, Azure Event Grid, Azure Storage and PostgreSQL instances to successfully connect to these external systems using Oracle Integration and synchronize data between Azure Storage and PostgreSQL.

Access Your FTP Server

Obtain an FTP server and ensure that you complete the FTP Server Prerequisites listed in Prerequisites for Creating a Connection.

Also, ensure that you have the read and write permissions on the FTP server directory to and from which you want to transfer files.

Configure Azure Event Grid

To access Azure Event Grid from Oracle Integration and successfully receive notifications on created subscriptions you must complete certain prerequisites.

See Prerequisites for Creating a Connection.

Configure Azure Storage (Get Blob)

To successfully get a file to Azure Storage using Oracle Integration, Azure Storage needs to get the blob for respective container.

See Prerequisites for Creating a Connection.

Configure PostgreSQL

To access the PostgreSQL database from Oracle Integration and synchronize data, you must perform certain configurations on your PostgreSQL instance.

For general configuration tasks, see Prerequisites for Creating a Connection.

In addition, you must create a database table. To create a database table:

1. Log in to your PostgreSQL Workbench instance as an Administrator.
2. Create the database table in either of the two ways given below.
   1. Right-click on Public Schema.
   2. Click Query Tool.
   3. Paste the query on the Query tool and then execute.

      For a sample query, refer to the following: PostgreSQLTableCreateQuery.txt

   or,

   1. Under public schema, right-click Tables, select Create, and then Tables.
   2. In the Create-Table dialog, specify the name of the table as aeg.
   3. Right-click on the empty table, and under Create select Column.
   4. Click Save.