ONES Analytics - Embedded NLP SQL Driver | Grand Nasser Enterprises

What is ONES Analytics?

ONES Analytics is an embedded NLP and text analytics engine that integrates directly with your existing BI tools. Instead of requiring API calls to cloud-based NLP services, ONES runs locally as a lightweight SQL driver, exposing natural language processing functions through the PostgreSQL wire protocol.

Connect from Tableau, Power BI, Qlik, Excel, DBeaver, or any application that supports JDBC or ODBC. Write standard SQL queries to analyze sentiment, extract entities, detect root causes, classify text into taxonomies, and score semantic similarity — all from within your dashboards and reports.

The engine ships with over 182,000 lexicon entries and 21 domain-specific lexicons covering healthcare, finance, legal, retail, telecommunications, manufacturing, and more. All processing happens on your machine with zero data leaving your environment, making ONES suitable for regulated industries with strict data residency and compliance requirements.

Key Features

Enterprise NLP without the enterprise complexity

Standard SQL Interface

No new language to learn. Call NLP functions with SELECT statements through any PostgreSQL-compatible client.

On-Premises Only

All processing happens locally. No data leaves your machine. No cloud APIs, no telemetry, no external calls.

21 Industry Domains

Pre-trained lexicons for healthcare, finance, legal, retail, telecom, manufacturing, and 15 more industries.

Single Binary

One executable, no dependencies. Installs in seconds on Windows, macOS, and Linux. Under 35MB.

BI Tool Native

Works with Tableau, Power BI, Qlik, Excel, DBeaver, and any tool that connects via PostgreSQL, JDBC, or ODBC.

Domain Auto-Detection

Automatically identifies the industry domain of input text and applies the most relevant lexicon for accurate scoring.

SQL Functions Reference

Call NLP from any SQL client

SENTIMENT(text)

Returns polarity score (-1.0 to 1.0), intensity, and label (positive/negative/neutral).

SELECT SENTIMENT('The product quality is excellent but delivery was slow');

ENTITIES(text)

Extracts named entities including people, organizations, locations, dates, and amounts.

SELECT ENTITIES('Dr. Smith at Mayo Clinic prescribed treatment on Jan 5');

ROOT_CAUSE(text)

Identifies causal patterns, contributing factors, and root cause candidates from text.

SELECT ROOT_CAUSE('Server crashed due to memory leak in the cache module');

TAXONOMY(text)

Classifies text into a hierarchical taxonomy with category, subcategory, and confidence.

SELECT TAXONOMY('Patient reported chest pain and shortness of breath');

SIMILARITY(text1, text2)

Computes semantic similarity between two texts on a 0.0 to 1.0 scale.

SELECT SIMILARITY('server is down', 'system outage reported');

DOMAIN_DETECT(text)

Identifies the industry domain of text (healthcare, finance, legal, etc.) with confidence.

SELECT DOMAIN_DETECT('The patient exhibited signs of acute respiratory distress');

SENTIMENT_DOMAIN(text, domain)

Domain-specific sentiment analysis with industry-tuned lexicon for higher accuracy.

SELECT SENTIMENT_DOMAIN('Bearish outlook on tech sector', 'finance');

KEYWORDS(text)

Extracts key phrases and significant terms from text, ranked by relevance.

SELECT KEYWORDS('The quarterly earnings exceeded analyst expectations');

BI Tool Compatibility

Connect with your existing tools today

Tableau

Native TACO connector with ONES Analytics icon in the connection pane. Also works via PostgreSQL connector.

TACO + PostgreSQL

Power BI

Connect using the built-in PostgreSQL connector. Server: localhost, Port: 5433, Database: ones.

PostgreSQL Connector

Qlik Sense

Connect using the PostgreSQL ODBC driver. Standard connection string with port 5433.

ODBC / PostgreSQL

Excel / DBeaver / Any SQL

Any tool that supports PostgreSQL, JDBC, or ODBC connections works out of the box.

JDBC / ODBC

Getting Started

Up and running in 3 steps

Download

Download the ONES Analytics binary for your platform (Windows, macOS, or Linux).

ones-driver.exe (35MB)

Start the Driver

Run the binary. It starts a PostgreSQL-compatible server on port 5433.

./ones-driver --port 5433

Connect

Point your BI tool to localhost:5433 using the PostgreSQL connector.

Host: localhost
Port: 5433
Database: ones

Query

Run SQL with NLP functions directly in your dashboard.

SELECT SENTIMENT('Great product!');

Security & Compliance

Built for regulated industries

HIPAA Ready

No PHI leaves your environment. Process healthcare text locally.

GDPR Compliant

Zero data transmission. No PII processing outside your infrastructure.

SOC 2 Compatible

Air-gapped deployment with offline license support for restricted environments.

No Telemetry

No usage tracking, no analytics, no phone-home except optional license validation.

Frequently Asked Questions

Does ONES Analytics require internet access?

No. The driver runs entirely offline. The only network call is an optional license validation heartbeat on startup. If the server is unreachable, the driver continues working with a warning. For air-gapped environments, offline license files are available with Enterprise plans.

How does it connect to my BI tool?

ONES Analytics exposes a PostgreSQL-compatible interface on port 5433. Any tool that can connect to PostgreSQL (Tableau, Power BI, Qlik, Excel, DBeaver, DataGrip, etc.) works out of the box. For Tableau, a dedicated TACO connector is also available.

What data does the license heartbeat send?

Only two things: your license key and a hashed machine fingerprint (SHA-256 of hostname + username). No user data, no text content, no query logs. The heartbeat validates that your license is active.

Can I add custom terms or domain lexicons?

Yes. Domain lexicons are loaded on demand. You can extend coverage by adding custom terminology files for your organization's proprietary vocabulary. Enterprise plans include assistance with custom lexicon development.

What is the performance like?

The underlying ONES-RS engine processes over 60,000 texts per second for sentiment analysis. The driver adds minimal overhead via the PostgreSQL wire protocol. Lexicons are loaded into memory once at startup for fast lookups.

Is the license tied to one machine?

Yes. Each license key is bound to a machine fingerprint on first activation. This ensures fair per-seat licensing. If you need to move a license, contact support for a key reset.

What happens when my trial expires?

After 30 days the driver will show a license expired message on startup. Your data and configurations are preserved. Purchase a license key to continue using ONES Analytics without interruption.

Which operating systems are supported?

Windows (x86_64), macOS (x86_64 and Apple Silicon), and Linux (x86_64). The driver is a single statically-linked binary with no external dependencies.