ODBC
Technology & Computing abbreviation · Data & Database
| Stands for | Open Database Connectivity |
|---|---|
| Categories | Technology & Computing |
ODBC stands for Open Database Connectivity, a data & database abbreviation.
A standard API that lets applications reach many different databases through drivers, so the same program can query SQL Server, Oracle, PostgreSQL or even spreadsheets without code changes.
Example: Install the ODBC driver, create a DSN, then connect to it from Excel or Tableau.
Usage notes
Released by Microsoft in 1992, based on the SQL Access Group's Call Level Interface. A DSN (data source name) stores the connection details. Java's JDBC followed the same idea, and BI tools still rely heavily on ODBC drivers to reach cloud warehouses.
Related abbreviations
More data & database abbreviations
- JDBC – Java Database Connectivity
- KV – Key-value (store)
- MDM – Master data management
- MPP – Massively parallel processing
- MSSQL – Microsoft SQL Server
- MVCC – Multiversion concurrency control
- ODS – Operational data store
- OLAP – Online analytical processing
- OLTP – Online transaction processing
- PK – Primary key
- PL/SQL – Procedural Language/SQL
- QPS – Queries per second