Ingres as Source

Capture

Data Source Solutions DSS supports capturing changes from an Ingres database. DSS 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 DSS can capture changes, see Capture changes from location in Capabilities.

Table Types

DSS supports capture from the following table types in Ingres:

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

Capture Methods

DSS 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 DSS 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 DSS can read from the internal DBMS logging files.

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

  $ cd /usr/dss/dss_home
  $ cp bin/dss sbin/dss_ingres
  $ chmod 4755 sbin/dss_ingres
  

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

  $ /usr/dss/dss_home/lib/patchelf --set-rpath /usr/dss/dss_home/lib --force-rpath /usr/dss/dss_home/sbin/dss_ingres
  

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

  $ chmod g+rX $DSS_HOME
  $ chmod -R g+rwX $DSS_CONFIG
  

Compare and Refresh from Ingres

DSS 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 DSS database User must be granted the <b>select</b> privilege:

  grant select on <em>tablename</em> to <em>username</em>;
  

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.