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.
Open Questions
-
CONNCET via ODBC: Logging connect-generated sql
Hello, I want to update an Oracle table via the connect storage engine. For... -
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...
Answered Questions
-
Access XML Tags with namespaces
How 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 Cluster
If I connect an XML file using the CONNECT engine must then every cluster n... -
Connect Storage Engine
Hi Can i store multiple file types(txt,csv,xml,xls,etc.) in a single table... -
Connect to Excel
How 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... -
decimal gives error 122 Unsupported Column Typ 9 from connect, float works
Hi, I wonder if this is a normal behavior. I am connecting to a Json file,... -
Encoding and access issues
Hi. 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.0
Hello, I am testing MariaDB and I have ODBC connections to MSSQL server. Th... -
Getting column names from the fields that use non-ANSI characters
I 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! -
how to enable connect engine in windows
How do i enable Connect engine in windows -
How to troubleshoot: ERROR 1296 (HY000): Got error 122 'Cannot retrieve error message' from CONNECT
Hi. How can i troubleshoot error below? ERROR 1296 (HY000): Got error 122 '... -
Loading CSV files
Hi, I have data in CSV files. Partitioned inside a directory, one file per ... -
mariadb columnstore plus connect
Hello I have a server with mariadb columstore 1.0.11 (mariadb 10.1.26) I ... -
ROWID in *.dbf Files
Is 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.5
Hi We're currently testing usage of MySQL Federated engine, used for read-o...