MariaDB starting with 10.0
The CONNECT storage engine was introduced in MariaDB 10.0.
|Connect 1.05.0003||MariaDB 10.1.22, MariaDB 10.0.30||Gamma|
|Connect 1.05.0001||MariaDB 10.2.4, MariaDB 10.1.21||Gamma|
|Connect 1.04.0008||MariaDB 10.2.2, MariaDB 10.1.17, MariaDB 10.0.27||Gamma|
|Connect 1.04.0006||MariaDB 10.2.0, MariaDB 10.1.13, MariaDB 10.0.25||Gamma|
|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.19||Gamma|
|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) 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 also 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.
How execute an insert in a Trigger using table with Engine CONNECT?Hello Guys I hope you are fine. I have a project, where I need to insert d...
Access XML Tags with namespacesHow is it possible to access tags with namespaces (<ns:tag>) in a XML file?
Connect DB2 table via ODBC with CLOB or Text datatype.I am attempting to connect a DB2 table using the following command line: c...
CONNECT engine on MariaDB Enterprise ClusterIf I connect an XML file using the CONNECT engine must then every cluster n...
Connect Storage EngineHi Can i store multiple file types(txt,csv,xml,xls,etc.) in a single table...
Connect to ExcelHow can i connect to an Excel file? I try this: create table Customer engin...
Data limit on joins with connect tables?I am attempting run a query against two tables in a remote database with an...
Encoding and access issuesHi. I love the CONNECT engine and I have a perfect use case for it. Actuall...
External (Connect) Tables read-only after MariaDB upgrade from 10.0.12.0 to 10.0.15.0Hello, I am testing MariaDB and I have ODBC connections to MSSQL server. Th...
Getting column names from the fields that use non-ANSI charactersI am trying to replicate example how to create pivot table like from MariaD...
How do I connect to MongoDB with Connect engine? Could not find any doc.I loaded the plugin, what's next? Could not find any docs/examples at all. Thanks in advance!
Loading CSV filesHi, I have data in CSV files. Partitioned inside a directory, one file per ...
ROWID in *.dbf FilesIs there a way to get the recno() / ROWID as field from the *dbf File?
Unsupported DBF type M (Memo)I'm using 10.0.22-MariaDB openSUSE package. I've received this "Unsupported...
Using Connect with MySQL 5.5Hi We're currently testing usage of MySQL Federated engine, used for read-o...