Skip to main content
Native integration

Connect Oracle Database to clariBI

Query your Oracle tables and views in plain English. clariBI's AI engine turns your enterprise data warehouse into an interactive, self-serve analytics platform -no SQL expertise required.

Powered by cx_Oracle via SQLAlchemy with connection pooling, Fernet-encrypted credentials, and 440+ ready-to-use analysis templates.

Start free 14-day trial View pricing →

What is Oracle Database?

Oracle Database is one of the world's most widely deployed enterprise relational database management systems (RDBMS). Developed by Oracle Corporation, it has been the backbone of mission-critical applications in finance, healthcare, manufacturing, and government for decades. Oracle is renowned for its robustness, advanced SQL capabilities, partitioning, OLAP extensions, and rock-solid transactional guarantees at massive scale.

Enterprises use Oracle to store everything from ERP data (Oracle E-Business Suite, SAP on Oracle) and CRM records to logistics tables and financial ledgers. Because of this, Oracle databases often contain some of the most strategically valuable data an organization holds -data that has historically been accessible only to trained DBA teams or expensive licensed BI tools.

clariBI connects to Oracle Database using the cx_Oracle driver (the industry-standard Python Oracle adapter), managed through SQLAlchemy with the oracle+cx_oracle dialect. Once connected, clariBI introspects your schema automatically and makes every table and view available to clariBI's AI engine for natural-language querying, dashboard generation, and automated insight reports.

Unlike generic BI tools that require you to write SQL or configure data models manually, clariBI lets any business user type a question -“What were our top 10 customers by revenue last quarter?” -and get an instant, accurate, chart-ready answer sourced directly from your Oracle tables.

Learn more about Oracle Database at oracle.com →

How to connect Oracle to clariBI

The entire setup takes under five minutes. You will need network access from clariBI's servers to your Oracle host on port 1521 (or your custom listener port).

1

Open Data Sources and click "Add Data Source"

From your clariBI workspace, navigate to Data Sources in the left sidebar. Click the + Add Data Source button in the top-right corner of the page. You'll see a categorised list of all supported integrations.

2

Select Oracle from the database list

Under the Databases category, click the Oracle tile. The connection form will open. Oracle uses a service name (e.g. ORCL or XEPDB1) rather than a plain database name -this is an important distinction from MySQL or PostgreSQL connectors.

3

Enter your Oracle connection details

Fill in the five required fields:

  • Host - the hostname or IP address of your Oracle server (e.g. db.corp.example.com or 10.0.1.42)
  • Port - default is 1521; change only if your DBA configured a custom listener port
  • Service Name - the Oracle service name (not a SID or database name); your DBA can confirm this value
  • Username - the Oracle user with SELECT privilege on the schemas you want to query
  • Password - stored with Fernet symmetric encryption; never stored in plaintext
4

Test the connection and confirm reachability

Click Test Connection. clariBI will attempt to open a cx_Oracle connection via the SQLAlchemy oracle+cx_oracle dialect. If it succeeds, you'll see a green confirmation banner. If it fails, clariBI will surface the specific Oracle ORA- error code so your DBA can diagnose firewall rules, listener configuration, or credential issues quickly.

5

Select schemas and tables, then start querying

clariBI will introspect all schemas accessible to your user and list every table and view. Choose which ones to include. From that moment, clariBI's AI engine can answer natural-language questions about your Oracle data, generate dashboards, and surface automated insights using our 440+ built-in analysis templates across 30 business categories.

What you can analyze

Once connected, every table and view in your Oracle instance becomes a data source for clariBI's full suite of analytics features.

  • Plain-English queries across any table or view

    Ask questions like "Show me monthly revenue by region for 2024" without writing a line of SQL.

  • Multi-table joins resolved automatically

    clariBI's AI engine understands foreign key relationships and constructs the correct JOIN logic on your behalf.

  • Oracle-specific data types handled natively

    NUMBER, VARCHAR2, CLOB, DATE, TIMESTAMP WITH TIME ZONE, and INTERVAL types are all supported and correctly represented in visualisations.

  • 440+ pre-built analysis templates

    Finance, supply chain, HR, sales, operations -choose from 440+ templates across 30 business categories and apply them instantly to your Oracle data.

  • Connection pooling with automatic recycling

    A pool of 5 persistent connections with a max overflow of 10 and 1-hour connection recycling ensures high throughput without saturating your Oracle listener.

  • Automated dashboard generation from your schema

    After connecting, clariBI can auto-generate a starter dashboard from your most important tables -ready to share with your team in seconds.

  • Scheduled reports and automated data refreshes

    Configure sync intervals to keep dashboards current. Schedule email or Slack delivery of reports generated directly from Oracle data.

  • Row-level and table-level access controls

    Restrict which clariBI users can query which Oracle tables. Combine with Oracle's own user privileges for defence-in-depth data governance.

Connection details

Reference these parameters when configuring your Oracle connection in clariBI. Note that Oracle uses a service name, not a database name -a key difference from other database connectors.

Parameter Value / Notes
Driver cx_Oracle via SQLAlchemy (oracle+cx_oracle dialect)
Default port 1521 (Oracle Net Listener default)
Required fields host port service_name username password
Identifier type Service name (not SID or database name). Example: ORCL, XEPDB1, prod.example.com
Credential storage Fernet symmetric encryption at rest; never stored in plaintext
Connection pool Pool size: 5 • Max overflow: 10 • Connection recycle: 1 hour
Access model Read-only credentials strongly recommended; table allow- and exclude-lists supported
Network requirement clariBI servers must be able to reach your Oracle host on the configured port; whitelist our IP ranges or use a site-to-site VPN

Enterprise use cases

Oracle powers the most demanding enterprise workloads. clariBI makes the data inside those workloads instantly accessible to every business team.

ERP & Financial Reporting

Connect to Oracle E-Business Suite or Oracle Financials tables to produce P&L statements, balance sheets, and budget-vs-actual reports in seconds. Ask "What is our gross margin by product line for Q3?" without a single line of SQL.

Sales & CRM Analytics

Pull pipeline data from Oracle-backed CRM systems. Track win rates, average deal size, rep performance, and sales cycle length. Build leaderboards and territory roll-ups that update automatically as new deals close.

Supply Chain & Inventory

Monitor inventory levels, supplier lead times, purchase order fulfilment, and logistics costs from Oracle WMS or SCM tables. Set automated alerts when stock falls below reorder thresholds and share dashboards with procurement teams.

HR & Workforce Analytics

Query Oracle HRMS data to analyse headcount, attrition, time-to-hire, and compensation equity across departments and geographies. Generate scheduled reports for executive review boards without any DBA involvement.

Operational KPI Dashboards

Bring together data from multiple Oracle schemas into unified executive dashboards. Track OEE, defect rates, production throughput, and SLA compliance across business units -all updated on a schedule you define.

Compliance & Audit Reporting

Generate accurate compliance reports from Oracle audit tables and transaction logs. clariBI's AI engine can surface anomalies and deviations, making internal audit preparation significantly faster for finance and compliance teams.

Security & requirements

Enterprise data demands enterprise-grade security. Here is how clariBI protects your Oracle connection and what you need to get started.

Security measures

  • Fernet encryption at rest

    All Oracle credentials (username, password) are encrypted using Fernet symmetric encryption before being stored in the clariBI database. The encryption key is managed separately from the data store.

  • TLS in transit

    All connections between clariBI and your Oracle server use TLS encryption if your Oracle Net configuration supports it. We recommend enabling Oracle Advanced Security for production environments.

  • Read-only access recommended

    Create a dedicated Oracle user with only SELECT privileges on the schemas you want to query. clariBI never writes to your source database.

  • Connection pooling with auto-recycle

    Connections are pooled (max 5 + 10 overflow) and recycled after 1 hour to prevent stale connections and reduce your Oracle listener load.

  • Audit logging

    All queries executed against your Oracle data source are logged in clariBI's audit trail, visible to workspace administrators at any time.

Prerequisites

  • Oracle Database version

    Oracle Database 11g Release 2 or later. Compatible with Oracle 12c, 18c, 19c, 21c, and 23c. Also works with Oracle Autonomous Database.

  • Network reachability

    clariBI's servers must be able to reach your Oracle host on port 1521 (or your custom port). You may need to add clariBI's IP ranges to your firewall allowlist or configure a site-to-site VPN.

  • Oracle service name (not SID)

    clariBI connects using the service name, not the legacy SID. If you only have a SID, ask your DBA for the corresponding service name using lsnrctl status.

  • Oracle Instant Client

    clariBI's infrastructure includes the Oracle Instant Client libraries required by cx_Oracle. No additional software needs to be installed on your end.

  • Dedicated analytics user

    Create a dedicated Oracle user (CREATE USER claribi_ro IDENTIFIED BY ...) and grant SELECT on the required schemas only.

Pricing & availability

Oracle Database integration is included on all paid clariBI plans and the free 14-day trial. No extra fees, no per-query charges.

Trial
Free
14 days
Oracle integration included
Starter
$99/mo
500 AI credits • 3 users
Oracle integration included
Popular
Professional
$199/mo
1,500 AI credits • 15 users
Oracle integration included
Enterprise
$999/mo
5,000 AI credits • 100 users
Oracle integration included

Annual billing saves up to 17% • All plans include unlimited dashboards, reports, and data source connections within your plan's limits • See full pricing details

Oracle Database

Connect Oracle in minutes

Start your free 14-day trial and have your first Oracle-powered dashboard live today. No credit card required.

440+ analysis templates • Fernet-encrypted credentials • Connection pooling built in • All paid plans from $99/month

Start free trial View pricing