PostgreSQL as Target

Fivetran HVR supports integrating changes into PostgreSQL, including managed PostgreSQL services. This section describes the configuration requirements for integrating changes (using Integrate and Refresh) into PostgreSQL location. For the list of supported PostgreSQL versions, into which HVR can integrate changes, see Integrate changes into location in Capabilities.

HVR uses the following interfaces to write data to PostgreSQL during Integrate and Refresh:

• PostgreSQL native client library "libpq" is used during Continuous Integrate and Row-wise Refresh.

• PostgreSQL COPY FROM STDIN command via "libpq" is used for Burst Integrate and Bulk Refresh.

Table and Column Names Forced Case

Since v6.1.0/34

This option allows you to manage the case sensitivity of object names created in the target PostgreSQL tables. This applies to Activating Replication, Refresh, and Compare.

Available options are:

• No default: Create table and column names in the same case as received from the source, which can be either lowercase or uppercase.
• Upper: Create table and column names in uppercase.
• Lower: Create table and column names in lowercase.

This option is equivalent to the location property ForceCase.

Grants for Integrate and Refresh

This section lists the grants required for integrating changes into PostgreSQL location.

1. The HVR database User must be granted the following privileges to read and change the replicated tables:

   GRANT SELECT, INSERT, UPDATE, DELETE ON tablename TO username;
   

2. The HVR database User must be granted the permission to create and drop HVR state tables.