Integrations Guide > Design > Source and Target Connections > Actian Ingres
Was this helpful?
Actian Ingres
With the Actian Ingres connector, a user can access an Actian Ingres instance to fetch stored data, and transform and upload it to an Actian Warehouse. This connector does not enable a user to access to an on-premise instance of Actian Ingres.
Prerequisites
The connection to Actian Ingres is made via JDBC, so users must ensure that their Actian Ingres instance is reachable from the outside world, or add the following Actian Data Platform IP addresses to the allow-list of their own database host: 
• 35.170.36.127
• 34.198.71.203
• 35.171.66.189
• 3.215.150.162
• 35.174.183.2
• 52.226.47.196/30
Connection Details
Specify the following details to define a connection:
Property
Description
Server Host Name
Specifies the URL or IP address of the server that hosts Actian Ingres. This is a mandatory property.
Port
(Optional) Specifies the JDBC port number on which the JDBC connection can be established to the specified host/server. If the port number is not provided then the default port number is used. For example: II7.
Database Name
(Optional) Specifies the database name to connect to.
User Name
Specifies the user name for the specified database. This is a mandatory property.
Password
Specifies the password for the specified database. This is a mandatory property.
Additional Properties
(Optional) Specifies additional connection properties, in a comma separated format, that must be appended to the connection string. For example: rewriteBatchedStatements=true
Source Details
Specify the following source details:
Property
Description
Table
Specifies the required table from which the data will be read. This is a mandatory property.
Additional Information
None
Last modified date: 05/15/2024