Ingres as Target

Data Source Solutions DSS 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 DSS can integrate changes, see Integrate changes into location in Capabilities.

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

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

• In UNIX & Linux,

  $ sql iidbdb < $DSS_HOME/dbms/ingres/dssrolecreate.sql
  

• In Windows,

  C:\>sql iidbdb < %DSS_HOME%\sql\ingres\dssrolecreate.sql
  

Intermediate Directory

{% partial file="dss6/requirements/source-and-target-requirements/intermediate-directory.template.md" /%}

Intermediate Directory is Local

{% partial file="dss6/requirements/source-and-target-requirements/intermediate-directory-local.template.md" /%}