Skip to content

Exasol + Querri

Exasol analytics for the whole team, no SQL needed

Pick the Exasol tables that matter; Querri keeps a copy in its Library and answers questions about them in plain English, applying the same business definitions every time.

Querri only reads from Exasol and never changes your records. SOC 2 Type II, HIPAA and ISO 27001:2022 certified, and your data is never used to train a model.

What you can answer

Questions teams ask about their Exasol data

Why do two reports show different revenue for the same month?

Revenue logic in Exasol is spread across views and saved queries, and each treats returns or credits a little differently. Querri keeps one definition as a fact or rule, so every answer counts revenue the same way.

Facts & rules

Which customers bought less after the last price change?

Exasol holds the order lines, but price changes often sit in a spreadsheet or the ERP, and comparing them means a new SQL join each time. Querri reads both, and you ask in chat with follow-ups in plain language.

AI Chat

Can the board pack charts update themselves?

Charts pasted into slides go stale the day after they are made. Querri dashboards built on Exasol tables refresh with each sync and can be shared with the people who need them.

Dashboards

What comes over

What Querri reads from Exasol

Querri copies this data into your Library on a schedule, next to every other system you connect, so one question can draw on all of it.

  • Tables
  • Views
  • Schemas

Incremental syncs

After the first load, each scheduled sync brings in only rows that are new or changed since the last one.

Read only

Querri reads from Exasol and never creates, edits or deletes anything there. Every answer runs on Querri's own copy.

Who sees what

Querri's own sharing and row-level access decide who sees which rows, in chat, dashboards, Claude, ChatGPT and the API.

How to connect

Connect Exasol to Querri

  1. 1

    Ask the Connector Agent

    Say "connect Exasol" or pick it from the connector catalog.

  2. 2

    Sign in or add your credentials

    Enter the Exasol host, port (8563 by default), user and password. The password is required and stays in the secure form. The connection is encrypted by default, and a self-signed server certificate can be trusted by pasting its SHA-256 fingerprint.

  3. 3

    Choose what to bring in

    Pick the data you want and how often it refreshes, then approve the first load.

  4. 4

    Ask your first question

    The data lands in your Library, ready for chat, dashboards and scheduled reports.

FAQ

Exasol and Querri: common questions

How do I connect Exasol to Querri?

Give the Connector Agent your Exasol host, port 8563, user and password. Encryption is on by default. If your server uses a self-signed certificate, paste its SHA-256 fingerprint rather than turning validation off. Choose a schema and the tables to bring in.

What Exasol data syncs to Querri?

Tables and views from the Exasol schema you name, with their column types kept. Exasol's SYS and EXA_STATISTICS schemas are not offered. Each sync copies only the tables you selected into your Library.

How often does Exasol data refresh?

Every table has its own schedule: a full reload daily, weekly or monthly, or an incremental sync hourly, daily or weekly. Incremental syncs use a cursor column, updated_at unless you choose another, and pull only rows changed since the previous sync.

Do I need to install an Exasol driver?

No. Querri connects to Exasol over its WebSocket protocol with an open-source driver that ships with Querri, so there is nothing to install or upload. Exasol SaaS and self-hosted Exasol databases connect through the same form.

Does Querri change anything in Exasol?

No. Querri only reads from Exasol. It never creates, edits or deletes records there, and every answer runs on Querri's own copy of the data.

Is my Exasol data secure in Querri?

Yes. Querri is SOC 2 Type II, HIPAA and ISO 27001:2022 certified, credentials are stored encrypted, and your data is never used to train a model.

Ask your Exasol data a question today

Connect Exasol, add the rest of your systems, and get answers your whole team can check.