Databases

A Database connection lets agents answer questions from live data. The agent turns the question into SQL, runs it against your database and explains the result. Nothing is copied: every answer uses the data as it is at that moment.

Supported databases

Oracle needs no extra driver on your side.

Connect a database

1. 1Go to Studio → Connections, click Create Connection and choose Database.
2. 2Pick the Database Type, then enter a Connection Name and a Description.
3. 3Fill in the connection details. The port is filled in for you.
4. 4Click Create Connection.
5. 5When Harmona asks Analyze this database?, click Analyze database, or Not now to choose tables first.

Tables and descriptions

Before an agent can answer anything, Harmona reads the schema and writes a description of every table and column. Agents use these descriptions to write correct queries. The analysis costs model usage in proportion to the size of the schema.

• Update analysis analyzes new and out-of-date tables only. This is usually enough.
• Choose tables… under More analysis options lets you pick specific tables, then click Analyze selected.
• Analyze from scratch re-runs every table. Your own edits are kept either way.

Open a table to read its description and column details. Click a description to edit it. Each column shows how sure the analysis is:

Short or cryptic names like `ord_amt` or `cst_flg` are where your edits help most. A clear connection Description helps too: it gives the analysis the business context behind the names. To remove a table from the connection, click Deactivate Table.

Use a read-only user

Agents are instructed to run only SELECT queries, and the tiles a Worker saves only read.

The model that writes table descriptions is set under Management → Organization Settings → General: SQL analysis model, and SAP HANA analysis model for HANA, whose schemas are often larger. See Deep document analysis.