Ingres as Source

Capture

Fivetran HVR supports capturing changes from an Ingres database. HVR uses Ingres OpenAPI interface to capture changes from the Ingres location. This section describes the configuration requirements for capturing changes from Ingres location. For the list of supported Ingres versions, from which HVR can capture changes, see Capture changes from location in Capabilities.

Table Types

HVR supports capture from the following table types in Ingres:

• Regular tables (HEAP, HASH, ISAM, BTREE)
• Partitioned tables
• Compressed tables

Capture Methods

HVR supports only the following method for capturing (Capture) changes from Ingres:

Direct DBMS Log Access

If log–based capture is defined for an Ingres database, then HVR may need to go back to reading the Ingres journal files. But each site has an existing backup/recovery regime that periodically deletes these Ingres checkpoint and journal files.

Creating Trusted Executable

In Linux and UNIX, to perform log-based capture from Ingres, a trusted executable must be created so that HVR can read from the internal DBMS logging files.

It is not required to create a trusted executable when either of the following are true:

• capture is trigger-based

• capture will be from another machine

• HVR is running as the DBMS owner (ingres)

• Execute the following commands while logged in as the DBMS owner (ingres):

  $ cd /usr/hvr/hvr_home
  $ cp bin/hvr sbin/hvr_ingres
  $ chmod 4755 sbin/hvr_ingres
  

• On Linux, the trusted executable should be patched using the following command:

  $ /usr/hvr/hvr_home/lib/patchelf --set-rpath /usr/hvr/hvr_home/lib --force-rpath /usr/hvr/hvr_home/sbin/hvr_ingres
  

• If HVR and ingres share the same Unix group, then the permissions can be tightened from 4755 to 4750. Permissions on directories HVR_HOME and HVR_CONFIG may need to be loosened so that user Ingres can access them:

  $ chmod g+rX $HVR_HOME
  $ chmod -R g+rwX $HVR_CONFIG
  

Compare and Refresh from Ingres

HVR allows you to perform only Compare and Refresh from Ingres database (without using Capture). This section describes the configuration requirements for performing only Compare and Refresh from Ingres database.

Grants for Compare and Refresh from Ingres

This section lists the grants required for performing only Compare and Refresh from Ingres database.

• The HVR database User must be granted the select privilege:

  grant select on tablename to username;
  

Limitations

There is a known issue in Ingres when using prepared statements to insert data with UTF-8 encoding into columns with the LONG VARCHAR data type. This can sometimes cause the data to be corrupted. For further assistance on addressing this (Ingres issue number II-11621), refer to Ingres documentation or contact Ingres support.