The CONNECT storage engine was introduced in MariaDB 10.0.
Note: You can download a PDF version of the CONNECT documentation.
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. |
| 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 DBF Table Type | CONNECT dBASE III or IV tables |
| 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 XML Table Type | CONNECT XML files |
| 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 |
| 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 |
© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/connect/