Ingres as Target

Fivetran HVR supports integrating changes into Ingres database. This section describes the configuration requirements for integrating changes using Integrate and Refresh into Ingres location. For the list of supported Ingres versions, into which HVR can integrate changes, see Integrate changes into location in Capabilities.

• HVR uses Ingres OpenAPI interface to write data into Ingres during Integrate and Refresh.
• HVR uses Ingres SQL command 'copy table ... () from program' during Burst Integrate and Bulk Refresh.

For HVR to integrate changes into an Ingres installation on a remote machine, special database roles (hvr_integrate and hvr_refresh) must be created in that Ingres installation. Execute the following script to create these roles:

• In UNIX & Linux,

  $ sql iidbdb < $HVR_HOME/dbms/ingres/hvrrolecreate.sql
  

• In Windows,

  C:\>sql iidbdb < %HVR_HOME%\sql\ingres\hvrrolecreate.sql