Import Data Files Using the Bulk Data Import Operation

This use case describes how to import data files from an FTP server into the PostgreSQL database. Similarly, you can import data files from an application into the PostgreSQL database using the PostgreSQL Adapter.

To perform this operation, you create the FTP Adapter and PostgreSQL Adapter connections in Oracle Integration. The PostgreSQL Adapter first validates an input file header with the target table header (columns), and then inserts the data into the target table if the data is in the expected format.

1. Create a scheduled orchestration integration.
2. Drag an FTP Adapter into the integration canvas.
3. Configure the FTP Adapter as follows.
   1. On the Basic Info page, provide a name.
   2. On the Operations page, select Download File from the Select Operation list.
   3. Select Binary from the Select a Transfer Mode list.
   4. Provide the input directory, file name, and download directory.
   5. On the Summary page, review your selections.
4. Drag a PostgreSQL Adapter into the integration canvas.
5. Configure the PostgreSQL Adapter endpoint:
   1. On the Basic info page, provide an endpoint name, and select Perform Bulk Data Import Operation.
   2. On the Bulk load from File to Table page, select the delimiter (for example, comma), schema, table, and table columns.
   3. On the Summary page, review your selections.
6. In the mapper, map the file reference from the FTP response to pass the data to the target table. The FTP response (file reference) provides an input to the PostgreSQL database.
7. Click Validate.
   The completed integration looks as follows.

   
   
   

8. When complete, save and activate the integration. As a result, the PostgreSQL Adapter inserts the data into the target table if the data is in the expected format.