Oracle

Connect an Oracle database and ask questions about live enterprise data.

Before you start

You’ll need:

• The host, port, and service name of your Oracle database, reachable from the internet.
• A username and password, ideally for a read-only user.
• Admin rights in your Terno workspace, to see the option to add a datasource.

Connect Oracle

1. Click Add Data Connectors, open the Datasources tab, and choose Oracle.
2. Choose Standard Setup or Connection URI at the top of the form.
3. Leave Start exploring my database ticked (it’s on by default). Right after connecting, Terno opens a background chat that explores the database and learns its tables, joins, and metrics. You’ll find it in your chat history and can open it any time.
4. Enter a Display Name and an optional Description, then fill in the fields below.
5. Click Add Connection. Terno tests the connection before saving it. If the test fails, you’ll see what went wrong, and nothing is saved.

Connection fields

Display Name required

A name for this connection, such as Production DB or Sales warehouse. It can be up to 40 characters and must be unique.

Description optional

A short note on what the data is about, such as Orders, customers, and payments for our online store. Up to 1024 characters. Terno uses it to understand when to use this source.

Standard Setup

User required

The database username, for example ADMIN.

Password required

The password for that user.

Host required

The server address, for example db.internal.

Port required

The listener port. Usually 1521.

Service Name required

The Oracle service name, for example orclpdb1.

Connection URI

oracle+oracledb://username:password@host:port/?service_name=SERVICE

Caution

The connection string must start with oracle+oracledb://. Strings starting with oracle+cx_oracle:// aren’t accepted.

Create a read-only user

CREATE USER terno_readonly IDENTIFIED BY "a-strong-password";
GRANT CREATE SESSION TO terno_readonly;
-- Repeat for each table Terno should read:
GRANT SELECT ON sales.orders TO terno_readonly;

After you connect

Terno reads your tables, columns, primary keys, foreign keys, and row counts. You’ll get a DataSource Ready notification when it’s done, and the new source appears in the sidebar’s Data Connectors panel. Expand it to see its tables.

Ask questions

Start a chat and ask in plain English, for example:

• “Which 10 customers spent the most this year?”
• “What’s the average order value by month?”
• “Show a chart of new sign-ups per week this quarter.”

Terno writes the SQL for Oracle, runs it, and replies with tables, charts, and an explanation. You don’t need to know SQL.

Security

• Credentials are encrypted at rest and used only to connect to your database.
• The AI never sees your password or connection string.
• SQLShield allows only a single read-only SELECT per query. Inserts, updates, deletes, and schema changes are blocked.
• Admins can hide tables, columns, and rows from groups of users. See Access control.

Troubleshooting

Connection timed out, or Terno can’t reach the server

• Check the host and port.
• Make sure the database accepts connections from outside your network, and that no firewall or security group blocks it.
• Use a real hostname or IP address. localhost and 127.0.0.1 point to Terno’s own servers, not yours.
• Check the database is running.

Authentication failed

• Check the username and password. Watch for extra spaces when pasting.
• Make sure the user is allowed to log in to this database.
• If you used a Connection URI, special characters in the password (like @, /, :) must be URL-encoded.

The database does not exist

Check the spelling of the database name. It’s the database inside the server, not the server name.

Terno can’t find my tables

• Make sure the user has SELECT permission on the tables.
• Check you connected to the right database and that the tables belong to a schema the user can read.
• An admin may have hidden some tables. See Access control.

See Connection errors for the full list of messages.

Best practices

• Use a read-only user created just for Terno, with access to only the data you want to analyse.
• Try a staging or replica database first before connecting production.
• Add a description and table descriptions so Terno picks the right tables. See Add context.
• Watch database load when asking for large, unfiltered results on production systems.
• Work with your database administrator on network access and permissions.