MariaDB starting with 10.0

The CONNECT storage engine was introduced in MariaDB 10.0.

Note: You can download a PDF version of the CONNECT documentation.

Connect Version Introduced Maturity
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, MariaDB 10.0.35 Stable
Connect 1.06.0005 MariaDB 10.3.3, MariaDB 10.2.10, MariaDB 10.1.29, MariaDB 10.0.33 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, MariaDB 10.0.31 Beta
Connect 1.05.0003 MariaDB 10.3.0, MariaDB 10.2.5, MariaDB 10.1.22, MariaDB 10.0.30 Stable
Connect 1.05.0001 MariaDB 10.2.4, MariaDB 10.1.21, MariaDB 10.0.29 Stable
Connect 1.04.0008 MariaDB 10.2.2, MariaDB 10.1.17, MariaDB 10.0.27 Stable
Connect 1.04.0006 MariaDB 10.2.0, MariaDB 10.1.13, MariaDB 10.0.25 Stable
Connect 1.04.0005 MariaDB 10.1.10, MariaDB 10.0.23 Beta
Connect 1.04.0003 MariaDB 10.1.9 Beta
Connect 1.03.0007 MariaDB 10.1.5, MariaDB 10.0.20 Stable
Connect 1.03.0006 MariaDB 10.1.3, MariaDB 10.0.16 Beta
Connect 1.03.0005 MariaDB 10.1.2, MariaDB 10.0.15 Beta
Connect 1.03.0003 MariaDB 10.1.1, MariaDB 10.0.14 Beta
Connect 1.03.0002 MariaDB 10.0.13 Beta
Connect 1.02.0002 MariaDB 10.1.0, MariaDB 10.0.10 Beta
Connect 1.02.0001 MariaDB 10.0.8 Beta
Connect 1.01.0008 MariaDB 10.0.5 Beta
Connect 1.01.0007 MariaDB 10.0.4 Beta
Connect 1.01.0006 MariaDB 10.0.3 Experimental
Connect 1.01.0004 MariaDB 10.0.2 Experimental

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.

Maturity is specified as “gamma” but this does not mean much because 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.

Title Description
Introduction to the CONNECT Engine Reasons behind the CONNECT storage engine.
Installing the CONNECT Storage Engine Installing the CONNECT storage engine.
Creating and Dropping CONNECT Tables Creating and dropping CONNECT tables.

CONNECT Table Types

Title Description
CONNECT Table Types Overview CONNECT can handle many table formats.
Inward and Outward Tables The two broad categories of CONNECT tables
CONNECT Table Types - Data Files CONNECT plain DOS or UNIX data files.
CONNECT Zipped File Tables When the table file or files are compressed in one or several zip files.
CONNECT DOS and FIX Table Types CONNECT tables based on text files
CONNECT BIN Table Type CONNECT binary files in which each row is a logical record of fixed length
CONNECT VEC Table Type CONNECT binary files organized in vectors
CONNECT CSV and FMT Table Types Variable length CONNECT data files
CONNECT - Files Retrieved Using Rest Queries JSON, XML and CSV data files can be retrieved as results from REST queries.
CONNECT JSON Table Type JSON (JavaScript Object Notation) is a widely-used lightweight data-interchange format.
CONNECT INI Table Type CONNECT INI Windows configuration or initialization files.
CONNECT - External Table Types Access tables belonging to the current or another server
CONNECT ODBC Table Type: Accessing Tables From Another DBMS CONNECT Table Types - ODBC Table Type: Accessing Tables from other DBMS
CONNECT JDBC Table Type: Accessing Tables from Another DBMS Using JDBC to access other tables.
CONNECT MONGO Table Type: Accessing Collections from MongoDB Used to directly access MongoDB collections as tables.
CONNECT MYSQL Table Type: Accessing MySQL/MariaDB Tables Accessing a MySQL or MariaDB table or view
CONNECT PROXY Table Type Tables that access and read the data of another table or view
CONNECT XCOL Table Type Based on another table/view, used when object tables have a column that contains a list of values
CONNECT OCCUR Table Type Extension to the PROXY type when referring to a table/view having several c...
CONNECT PIVOT Table Type Transform the result of another table into another table along “pivot” and "fact" columns
CONNECT TBL Table Type: Table List Define a table as a list of tables of any engine and type.
CONNECT - Using the TBL and MYSQL Table Types Together Used together, the TBL and MYSQL types lift all the limitations of the FEDERATED and MERGE engines
CONNECT Table Types - Special "Virtual" Tables VIR, WMI and MAC special table types
CONNECT Table Types - VIR VIR virtual type for CONNECT
CONNECT Table Types - OEM: Implemented in an External LIB CONNECT OEM table types are implemented in an external library.
CONNECT Table Types - Catalog Tables Catalog tables return information about another table or data source
Adding DataFlex 3.1c .dat Files As An External Table Type With CONNECT I'm using MariaDB's CONNECT engine to access / utilize a set of Visual FoxP...
CONNECT engine windows with mariadb 10.07 installed on windows, how to setup engines, particulary ...
creating pivot table fails I tried to create a pivot table based on an existing table "test1" and get ...
limit of number of columns I have a table of 6MB with 50 values in the pivot-values leading to 50 colu...


Title Description
Using CONNECT - General Information Using CONNECT - General Information
Using CONNECT - Virtual and Special Columns Virtual and special columns example usage
Using CONNECT - Importing File Data Into MariaDB Tables Directly using external (file) data has many advantages
Using CONNECT - Exporting Data From MariaDB Exporting data from MariaDB with CONNECT
Using CONNECT - Indexing Indexing with the CONNECT handler
Using CONNECT - Condition Pushdown Using CONNECT - Condition Pushdown
USING CONNECT - Documentation CONNECT Plugin User Manual
Using CONNECT - Partitioning and Sharding Partitioning and Sharding with CONNECT

Other CONNECT Articles

Title Description
CONNECT Data Types Data types supported by CONNECT.
Current Status of the CONNECT Handler The current CONNECT handler is a stable release.
CONNECT - Security CONNECT requires the FILE privilege for "outward" tables
CONNECT - OEM Table Example Example showing how an OEM table can be implemented.
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
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.

© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.