CONNECT

• 3

  Introduction to the CONNECT Engine

  Reasons behind the CONNECT storage engine.
• 2

  Installing the CONNECT Storage Engine

  Installing the CONNECT storage engine.
• 1

  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

• CONNECT Table Types Overview

  CONNECT can handle many table formats.
• Inward and Outward Tables

  The two broad categories of CONNECT tables.
• 1

  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
• 5

  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 - NoSQL Table Types

  Based on files that do not match the relational format but often represent hierarchical data.
• CONNECT - Files Retrieved Using Rest Queries

  JSON, XML and CSV data files can be retrieved as results from REST queries.
• 4

  CONNECT JSON Table Type

  JSON (JavaScript Object Notation) is a widely-used lightweight data-interchange format.
• CONNECT XML Table Type

  CONNECT XML files
• CONNECT INI Table Type

  CONNECT INI Windows configuration or initialization files.
• 1

  CONNECT - External Table Types

  Access tables belonging to the current or another server.
• 3

  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.
• 1

  CONNECT MONGO Table Type: Accessing Collections from MongoDB

  Used to directly access MongoDB collections as tables.
• 6

  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...
• 3

  CONNECT PIVOT Table Type

  Transform the result of another table into another table along “pivot” and "fact" columns.
• 2

  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
• 1

  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...
• 3

  CONNECT engine windows

  with mariadb 10.07 installed on windows, how to setup engines, particulary ...
• 11

  creating pivot table fails

  I tried to create a pivot table based on an existing table "test1" and get ...
• 1

  limit of number of columns

  I have a table of 6MB with 50 values in the pivot-values leading to 50 colu...

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

• 1

  Using CONNECT - General Information

  Using CONNECT - General Information.
• Using CONNECT - Virtual and Special Columns

  Virtual and special columns example usage
• 1

  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 - Offline Documentation

  CONNECT Plugin User Manual.
• Using CONNECT - Partitioning and Sharding

  Partitioning and Sharding with 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