Connect Oracle Database to clariBI
Give clariBI a read-only Oracle user and the service name, choose the tables, and it copies them next to your other sources and builds a dashboard for them.
clariBI| Connection | Built in. Host, port (1521 if empty), service name (such as ORCLPDB1, not a SID), user name and password, plus an optional schema owner and table list. |
| Access | SELECT statements only. Use a user that can only read the tables you want to share. |
| Rows | Each sync copies up to your plan's row cap per table (3,000 rows on Free and Trial, up to 100,000 on Enterprise). |
| Network | The server must be reachable from the internet. Private and local addresses (10.x, 192.168.x, 127.0.0.1) are refused. |
| Plans | Every plan, including Free, within its data source limit. Asking questions in plain English needs the trial or Starter and above. |
About Oracle Database
Oracle Database is a relational database, common behind ERP, finance and other enterprise applications.
clariBI connects over the network with a service name, reads the schema, and runs SELECT statements only. The password is stored encrypted. We tested the connector against Oracle Database 23 Free.
Vendor site: oracle.com/database
What clariBI syncs
When you connect, clariBI tests the connection and syncs right away: it reads the schema (tables, columns and types) and copies every table in it, or only the tables you list. With the schema owner empty, clariBI reads the user's own schema.
A sync re-reads each table and copies up to your plan's row cap (3,000 on Free and Trial, 5,000 on Lite, 10,000 on Starter, 50,000 on Professional and 100,000 on Enterprise), so point clariBI at summary tables or views (daily revenue, weekly signups) rather than raw event tables. There is no incremental sync. Click Sync now to copy fresh rows. clariBI also syncs on its own when the copy is more than a day old and a question, a dashboard refresh or a report uses it.
The database must accept connections from the internet on its port. clariBI refuses private, local and internal addresses such as 10.x, 192.168.x and 127.0.0.1, so a server reachable only inside your network or VPN cannot be connected. Allow clariBI through your firewall; write to support@claribi.com for the address. A connection attempt gives up after 15 seconds, and queries run with a statement timeout.
How to connect Oracle
Create a read-only user
In Oracle, create a user for clariBI and grant it CREATE SESSION and SELECT on the tables or views you want to share, and nothing else.
Enter the connection
In clariBI, open Settings > Integrations > Add Data Source > Databases > Oracle and enter host, port, service name, user and password. Add a schema owner if the tables belong to another user, or a table list if you want to limit what is read. Click Test Connection, then Create Data Source.
Sync the tables
clariBI copies the tables right away and builds a dashboard for them. You can ask questions once the first sync finishes.
Questions you can ask
Asking in plain English uses AI credits, so it needs the trial or a Starter, Professional or Enterprise plan. Totals and trends are computed from the synced rows; the AI plans the question, picks the chart and writes the explanation.
- "Which cost centers went over budget last quarter?"
- "How do monthly shipments in the ERP compare with the same months last year?"
About the Oracle connector
Can clariBI write to my database?
clariBI only runs SELECT statements and blocks queries with write keywords. A user with read-only grants makes sure of it on the database side.
My database uses a SID. Can I connect?
The form takes a service name, such as ORCLPDB1, not a SID. Most databases register a service name as well; your database administrator can tell you which one to use.
The tables belong to another user. What do I enter?
Put that user in the schema owner field and grant your clariBI user SELECT on the tables. With the field empty, clariBI reads the user's own schema.
How many rows does a sync copy?
Up to a row cap per table that depends on your plan: 3,000 on Free and Trial, 5,000 on Lite, 10,000 on Starter, 50,000 on Professional and 100,000 on Enterprise. Larger tables are copied in part, so summary tables and views give complete answers.
Can clariBI reach a database on a private network?
No. clariBI connects over the internet and refuses private, local and internal addresses such as 10.x, 192.168.x and 127.0.0.1. Give the server a public host name or address and allow clariBI through your firewall.
Which other databases can clariBI connect?
PostgreSQL, MySQL and SQL Server, with the same form. SQLite is not offered; export those tables as CSV and upload them.
Which clariBI plans include Oracle?
Every plan can connect it, within its data source limit: 3 on Free, 5 on Lite, 10 on Starter, 50 on Professional and 100 on Enterprise. Each source gets an automatic dashboard on every plan. Asking questions in plain English and AI reports need the trial or a Starter, Professional or Enterprise plan.
Try Oracle in clariBI
The trial lasts 14 days, includes 50 AI credits and needs no card. When it ends, your account moves to the Free plan and keeps its data and dashboards.