Ingres Requirements
This section describes the requirements, access privileges, and other features of Fivetran HVR when using Ingres for replication.
Supported Platforms
- Learn about the Ingres versions compatible with HVR on our Platform Support Matrix page (6.1.0, 6.1.5, 6.2.0, and 6.2.5).
Supported Capabilities
- Discover what HVR offers for Ingres on our Capabilities for Ingres page (6.1.0, 6.1.5, 6.2.0, and 6.2.5).
Data Management
Learn how HVR maps data types between source and target DBMSes or file systems on the Data Type Mapping page. For the list of supported Ingres data types and their mapping, see Data Type Mapping for Ingres
Understand the character encodings HVR supports for Ingres on the Supported Character Encodings page.
Access Privileges
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:
