Integrations Guide > Design > Source and Target Connections > Actian Ingres
Was this helpful?
Actian Ingres
This topic describes Actian Ingres connector properties and connection details for reading data from an Actian Ingres database. This connector enables users to access a publicly accessible Actian Ingres database (hosted in the cloud, not on-premise).
If you’re Creating Integrations or Connections, use this information to Define Source.
Actian Ingres also supports connecting via agent. This option is useful when an Actian Ingres database is located behind a firewall (hosted on-premise). For information, see Actian Ingres - Via Agent.
Prerequisites
The connection to Actian Ingres is made via JDBC, so users must ensure that their Actian Ingres instance is publicly accessible, 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: 12/12/2024