CONNECT
Note: You can download a PDF version of the CONNECT documentation (1.7.0003).
Connect Version | Introduced | Maturity |
---|---|---|
Connect 1.07.0002 | MariaDB 10.5.9, MariaDB 10.4.18, MariaDB 10.3.28, MariaDB 10.2.36 | Stable |
Connect 1.07.0001 | MariaDB 10.4.12, MariaDB 10.3.22, MariaDB 10.2.31, MariaDB 10.1.44 | Stable |
Connect 1.06.0010 | MariaDB 10.4.8, MariaDB 10.3.18, MariaDB 10.2.27 | Stable |
Connect 1.06.0007 | MariaDB 10.3.6, MariaDB 10.2.14, MariaDB 10.1.33 | Stable |
Connect 1.06.0005 | MariaDB 10.3.3, MariaDB 10.2.10, MariaDB 10.1.29 | Stable |
Connect 1.06.0004 | MariaDB 10.3.2, MariaDB 10.2.9, MariaDB 10.1.28 | Stable |
Connect 1.06.0001 | MariaDB 10.3.1, MariaDB 10.2.8, MariaDB 10.1.24 | Beta |
Connect 1.05.0003 | MariaDB 10.3.0, MariaDB 10.2.5, MariaDB 10.1.22 | Stable |
Connect 1.05.0001 | MariaDB 10.2.4, MariaDB 10.1.21 | Stable |
Connect 1.04.0008 | MariaDB 10.2.2, MariaDB 10.1.17 | Stable |
Connect 1.04.0006 | MariaDB 10.2.0, MariaDB 10.1.13, | Stable |
Connect 1.04.0005 | MariaDB 10.1.10 | Beta |
Connect 1.04.0003 | MariaDB 10.1.9 | 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 or MongoDB) via ODBC or JDBC, or data retrieved from the environment (for example DIR, WMI, and MAC tables)
This storage engine supports table partitioning, MariaDB virtual columns and permits defining special columns such as ROWID, FILEID, and SERVID.
No precise definition of maturity exists. Because CONNECT handles many table types, each type has a different maturity depending on whether it is old and well-tested, less well-tested or newly implemented. This will be indicated for all data types.
-
Introduction to the CONNECT Engine
Reasons behind the CONNECT storage engine. -
Installing the CONNECT Storage Engine
Installing the CONNECT storage engine. -
CONNECT Create Table Options
CREATE TABLE options for the CONNECT engine. -
CONNECT Data Types
Data types supported by CONNECT. -
Current Status of the CONNECT Handler
The current CONNECT handler is a stable release.
CONNECT Table Types
Other CONNECT Articles
-
CONNECT - Security
CONNECT requires the FILE privilege for "outward" tables -
CONNECT - OEM Table Example
Example showing how an OEM table can be implemented.
Using CONNECT
Other CONNECT Articles
-
CONNECT - Making the GetRest Library
Compiling the function calling the cpprestsdk package separately that will be loaded by CONNECT. -
CONNECT - Adding the REST Feature as a Library Called by an OEM Table
How the REST feature can be added as a library called by an OEM table. -
CONNECT - Compiling JSON UDFs in a Separate Library
There are situations when you may need to have JSON UDFs in a separate library. -
CONNECT System Variables
System variables related to the CONNECT storage engine. -
JSON Sample Files
expense.json sample file