HCL OneDB - Via Agent
IMPORTANT! When using an Agent to run an integration using the Connect via Agent option, ensure that you download the integration-agent-3.3.0-47 version or later, as previous versions are not supported.
This topic describes how to connect via agent using the HCL OneDB connector. This option is useful for reading data from a HCL OneDB database that is located behind a firewall (hosted on-premise). This connector is available if Connect via Agent is enabled when creating a new connection or integration.
Use this information when Creating Integrations or creating Connections.
Prerequisites
• Download the Actian Integration Agent. See Download an Agent.
• Install the Actian Integration Agent on your machine. See Install an Agent.
• Register the Actian Integration Agent with Actian Data Platform. See Register an Agent.
• HCL OneDB ODBC driver must be installed on the same machine where Actian Integration Agent is installed.
Connection Details
Specify the following details to define a connection:
Option | Description |
|---|---|
Name | Specify a descriptive name for the connection and click Continue. This property is mandatory. |
Agent | Select the Actian Integration Agent that is installed on your system and is registered to the logged in user. (The agent must be registered to the logged in user, otherwise it will not work.) This property is mandatory. |
HCL OneDB Server | Specifies the name of the server on which the HCL OneDB database is hosted. This property is mandatory. |
HCL OneDB Database Name | Specifies the name of the HCL OneDB database to connect to. This property is mandatory. |
User Name | Specifies the user name for the specified database. This property is mandatory. |
Password | Specifies the password for the specified database. This property is mandatory. |
HCL OneDB Server Locale | Specifies the locale of the server on which the HCL OneDB database is hosted. The default setting is EN_US.819. Select one of the following: • EN_US.819 • EN_US.UTF8 This property is mandatory. |
Test | Click to verify your connection, then click Save. The new connection is listed on the Connections page and selected as the source connection (if you’re in the process of creating an integration). |
The connection appears in the list of connections on the Connections page.
If creating an integration specify the following details to define the source to be read:
Note: The following options are visible when Creating Integrations and not when creating Connections.
Option | Description |
|---|---|
Test Credentials | Click to verify your connection. A “Connection successful” message is returned when the connection is successful. An error message is returned when the connection attempt fails. |
Table Name | Specifies the table from which the data will be read. This property is mandatory. |
Preview the first 20 records | Click to preview the first 20 records. Use this to verify that you’re connected to the correct table. Data for the selected source table is displayed in the source data preview pane. Click  and enter a string to search for a particular record. |
Continue | Click when you have finished entering source definitions. |
The integration appears in the list of integrations on the Integration Designs page.
Last modified date: 12/12/2024