February 10, 20261 min read·Planasonix Team
OneLink Driver: Query Any SaaS API with SQL
productonelinkintegrations
Imagine opening Excel, writing SELECT * FROM salesforce.contacts WHERE created_date > '2026-01-01', and getting live results — no ETL pipeline, no staging database, no CSV exports. That's OneLink.
The Problem with API Wrappers
Most SaaS APIs speak REST or GraphQL. BI tools, spreadsheets, and data science notebooks speak SQL. Bridging that gap usually means:
- Writing custom Python scripts per API
- Maintaining pagination, rate-limiting, and auth token refresh logic
- Scheduling scripts and storing intermediate CSVs or JSON blobs
- Hoping nothing breaks when the vendor changes their API version
OneLink's Approach
OneLink is an ODBC/JDBC driver that sits between your SQL client and the SaaS API. Under the hood it:
- Translates SQL — parses your query, maps table and column names to API endpoints and fields, and pushes down filters and projections.
- Handles pagination — transparently iterates through pages so you get the complete result set.
- Manages auth — stores OAuth tokens securely and refreshes them automatically.
- Caches metadata — schema introspection is fast because OneLink caches table/column definitions locally and refreshes them in the background.
Supported Clients
Because OneLink speaks standard ODBC and JDBC, it works everywhere:
| Client | Connection Method |
|---|---|
| Excel / Google Sheets | ODBC |
| Power BI | ODBC |
| Tableau | JDBC |
| DBeaver | JDBC |
| Python (pyodbc / jaydebeapi) | ODBC / JDBC |
| R (RODBC) | ODBC |
Getting Started
- Download the OneLink driver from your Planasonix dashboard.
- Add a DSN in your operating system's ODBC manager (or a JDBC URL in your client).
- Enter your Planasonix API key and select the SaaS sources you want to query.
- Open your SQL client and start querying.
Plans start at $49/month for up to 5 connectors. See pricing for details.