Actian Data Platform

To connect your Actian Data Platform instance to Actian AI Analyst, follow these steps:

1. Create a dedicated user with read-only access.

2. Grant read-only permissions on the schemas you want to expose.

3. Allow Actian AI Analyst's IP address through your firewall or network rules.

4. Set up the connection in the Actian AI Analyst interface.

Actian AI Analyst's agents only run read-only queries on your data. No write permissions are required.

---

1. Create a Read-Only User in Actian

Create a dedicated database user for Actian AI Analyst with read-only access. 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-Only Access to Your Schemas

Grant Actian AI Analyst read access to the tables in the schemas you want to expose:

-- 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 you want Actian AI Analyst to access.

Security tip: only grant access to the schemas your analysts actually need. You can always add more schemas later.

---

3. Allow Actian AI Analyst's IP Address

If your Actian instance is protected by firewall or network rules, allow inbound traffic from Actian AI Analyst's static IP:

34.77.172.158

---

4. Set Up the Connection in Actian AI Analyst

1. Click Connections → Plus button → Select Actian Data Platform.

2. Fill in the following details:

   • Connection string: your Actian connection string, in the format @<hostname>,tcp_ip,<port>::<database> (e.g. @av-043ios4r2921.avd.actiandatacloud.com,tcp_ip,27832::db)

   • Database: the name of the database Actian AI Analyst should connect to

   • Username: actian_analyst_user

   • Password: the password you defined earlier

   • Schemas: select the schemas you granted access to in step 2

3. Test the connection and save.

---

That's It!

Actian AI Analyst is now connected to your Actian Data Platform and can start delivering insights with natural language queries—no SQL or dashboards needed.