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