Ingres Requirementslink
This section describes the requirements, access privileges, and other features of Fivetran HVR when using Ingres for replication.
For information about compatibility and supported versions of Ingres with HVR platforms, see Supported Platforms.
For the Capabilities supported by HVR on Ingres, see Capabilities for Ingres.
For information about the supported data types and mapping of data types in source DBMS to the corresponding data types in target DBMS or file format, see Data Type Mapping.
For the character encodings supported by HVR on Ingres, see the Character Encodings page.
Access Privilegeslink
This section describes the access privileges required for capturing or integrating changes into an Ingres location.
For an Ingres database location, each account used by HVR must have permission to use Ingres. Typically, HVR connects to database locations as the owner of that database. This means that either HVR is already running as the owner of the database, or it is running as a user with Ingres Security Privilege. HVR can also connect to a database location as a user who is not the database's owner, although the Row-wise Refresh into such a database is not supported if database rules are defined on the target tables.
Accessdb permission screen:
DBA permission screen: