1. Using the PostgreSQL Adapter with Oracle Integration 3
  2. Understand the PostgreSQL Adapter
  3. PostgreSQL Adapter Capabilities

PostgreSQL Adapter Capabilities

The PostgreSQL Adapter enables you to integrate a PostgreSQL cloud database with Oracle Integration. In addition, the PostgreSQL Adapter enables you to integrate a PostgreSQL database residing behind the firewall of your on-premises environment with Oracle Integration through use of the on-premises connectivity agent. You can configure the PostgreSQL Adapter as an invoke connection in an integration in Oracle Integration.

The PostgreSQL Adapter provides the following benefits:

  • Support for invocation of stored procedures in the PostgreSQL database.

  • Support for performing the Select, Insert, Update, and Merge operations against database tables.

    For complex SQL queries, use stored procedures by selecting the Invoke a Stored Procedure option on the Basic Info page of the Adapter Endpoint Configuration Wizard. Stored procedures can reduce the complexity of a SQL query.

The PostgreSQL Adapter is one of many predefined adapters included with Oracle Integration.

Supported Data Types for the Stored Procedure and Operation On Table Operations

The PostgreSQL Adapter supports the following data types for stored procedure and Operation On Table operations.

  • int
  • int2
  • int4
  • int8
  • integer
  • bigInt
  • smallint
  • numeric
  • double precision
  • real
  • float
  • float4
  • float8
  • money
  • decimal
  • oid
  • varchar
  • char
  • text
  • bpchar
  • name
  • date
  • timestamp
  • timestamptz
  • time
  • timetz
  • boolean