Skip to content
M↓ View as Markdown ↗

Actian Data Platform

Connect an Actian Data Platform database so that Actian AI Analyst can query its tables for Models, Metrics, and SemQL. In Studio, this connector is the Actian tile.

Availability

  • Who can do this: members with the Edit capability in the active Workspace. If your organization turns on Restrict connection management, adding or changing organization connections also needs the Manage organization capability. See Who can add connections.
  • Plan: your organization's plan can leave this connector out. Studio then doesn't show the Actian tile.
  • Deployment: offered only on deployments that are set up to reach Actian, Ingres, Informix, and ZenDB databases. If the Actian tile isn't listed under Warehouses, ask your administrator.

Use a read-only user

AI Analyst only needs read access. This connector can't enforce read-only access by itself, so Studio shows "This Connector cannot enforce read-only access itself. Supply a warehouse user that is limited to read-only privileges." AI Analyst asks the driver for a read-only session where the driver supports it, and limits how long queries run and how many rows they return. See Read-only access and query limits.

1. Create a read-only user

Create a dedicated database user for AI Analyst. Run the following SQL as a user with administrative privileges:

-- Create a user for Actian AI Analyst
CREATE USER actian_analyst_user WITH PASSWORD '<your_secure_password>';

2. Grant read access to your schemas

Grant the user read access to the tables in each schema you want to use:

-- Grant read-only access to a specific schema
GRANT SELECT ON ALL TABLES IN SCHEMA your_schema_name TO actian_analyst_user;

Repeat this for each schema.

Tip

Only grant access to the schemas your analysts need. You can grant more later, then re-test the connection and select the new schemas.

3. Allow network access

If your instance's firewall restricts inbound traffic, allow AI Analyst's egress IP addresses on your Actian port (default 27839).

  • If your deployment publishes its egress IP addresses, Studio lists them under Which IPs to allow in the Setup help panel next to the connection form.
  • Otherwise, for example on a self-managed deployment, allow your installation's outbound addresses, or ask your administrator which addresses to allow.

For details, see Network access and IP allowlisting.

4. Add the connection in Studio

  1. In Studio, open Connections and click + (Add connection).
  2. Under Warehouses, select Actian.
  3. Under Connection details, enter a Name (for example Actian analytics) and, if you like, a Description (optional).
  4. Leave Private to this Workspace unticked to create an organization connection, or tick it to keep the connection in this Workspace only. See Data connections and Workspaces.
  5. Under Credentials, fill in the fields described in Connection fields, or paste a connection string.
  6. Click Test connection and wait for Connection successful.
  7. In Schemas, select the schemas you granted access to in step 2. The list shows the schemas in the database, and the first one is preselected. If you change the selection, the test result is cleared: click Test connection again (your selection is kept) and wait for Connection successful.
  8. Click Save connection.

Save connection stays disabled until the connection has a name and a successful test. If you change a credential field after testing, test again. For the general flow and the Setup help panel, see Connect a data source.

Connection fields

Field What to enter
Host The hostname only, for example av-xxxxx.avprod.actiandatacloud.com. Port, database, and encryption are separate fields, so don't paste a JDBC string here.
Port The port of your instance. The default is 27839.
Database The database name only, for example db. JDBC attributes such as encryption=on belong in Encryption.
Encryption On (the default) to encrypt the connection, or Off.
Username actian_analyst_user, or the read-only user you created.
Password The password you set in step 1.
Schemas Appears after a successful test. Select the schemas to expose for browsing and Model authoring.

Host and Database can't contain ;, =, or spaces.

Paste a connection string

Instead of typing each field, you can fill the form from a connection string:

  1. Under Credentials, click Paste a connection string.

  2. Paste a JDBC URL or an ODBC-style string into Connection string, for example:

    jdbc:actian://av-xxxxx.avprod.actiandatacloud.com:27839/db;encryption=on;UID=actian_analyst_user;PWD=<your_secure_password>

    Server=av-xxxxx.avprod.actiandatacloud.com;Port=27839;Database=db;UID=actian_analyst_user;PWD=<your_secure_password>

  3. Click Fill the form, then check the filled-in fields.

Studio fills the fields in your browser. It doesn't store the string, and nothing is sent until you test the connection.

Older connection strings

The vnode-style string used in earlier versions of the product (@<hostname>,tcp_ip,<port>::<database>) isn't accepted. Enter its parts in the separate fields instead: the hostname in Host, the port in Port, and the database name in Database.

Troubleshooting

Problem What to try
The Actian tile isn't listed The connector isn't enabled for your deployment or isn't included in your organization's plan. Ask your administrator.
This warehouse type isn't available right now Your deployment can't currently reach Actian databases. Contact your administrator.
Could not reach the warehouse Check Host and Port, and allow AI Analyst through your firewall (step 3).
Could not establish a secure connection Check that Encryption matches what your instance accepts.
Authentication failed Check Username and Password.
This warehouse user cannot see those objects Grant the user read access (step 2).

For the other messages, see If the test fails.

Next steps