Ingres Requirements

This section describes the requirements, access privileges, and other features of Data Source Solutions DSS when using Ingres for replication.

Supported Platforms

• Learn about the Ingres versions compatible with DSS on our Platform Support Matrix page (6.1.0, 6.1.5, 6.2.0, and 6.2.5).

Supported Capabilities

• Discover what DSS 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 DSS 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 DSS 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 DSS must have permission to use Ingres. Typically, DSS connects to database locations as the owner of that database. This means that either DSS is already running as the owner of the database, or it is running as a user with Ingres Security Privilege. DSS 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:

Related Articles

• Ingres as Source
• Ingres as Target
• Location Connection for Ingres