MariaDB starting with 10.0
The CONNECT storage engine was introduced in MariaDB 10.0.
|Connect 1.04.0001||MariaDB 10.1.6||Beta|
|Connect 1.03.0007||MariaDB 10.0.19||Gamma|
|Connect 1.03.0005||MariaDB 10.0.17||Beta|
The CONNECT storage engine enables MariaDB to access external local or remote data (MED). This is done by defining tables based on different data types, in particular files in various formats, data extracted from other DBMS or products (such as Excel) via ODBC, or data retrieved from the environment (for example DIR, WMI, and MAC tables)
This storage engine supports table partitioning, MariaDB virtual columns and also permits defining special columns such as ROWID, FILEID, and SERVID.
Introduction to the CONNECT EngineReasons behind the CONNECT storage engine
Loading the CONNECT Storage EngineLoading the CONNECT storage engine
Creating and Dropping CONNECT TablesCreating and dropping CONNECT Tables
Other CONNECT Articles
CONNECT Data TypesData types supported by CONNECT
CONNECT - SecurityThe use of the CONNECT engine requires the FILE privilege for "outward" tab...
CONNECT - OEM Table ExampleExample showing how an OEM table can be implemented
CONNECT System VariablesSystem variables related to the CONNECT storage engine
JSON Sample Filesexpense.json sample file