MariaDB support

Supported versions

MariaDB Server 5.1, 5.2, 5.3, 5.5, 10.0, 10.1, 10.2, 10.3

MariaDB Columnstore

Some versions of MariaDB Columnstore may cause issues - we have tested and version 1.1.2-1 works properly.

If you do run into any issues please post here.

Supported schema elements and metadata

Dataedo reads following metadata from MariaDB databases.

• Tables
  • Columns
    • Data type with length
    • Nullable
    • Default value
  • Primary keys
    • Columns
  • Unique indexes
    • Column
  • Foreign keys
    • Columns
  • Triggers
    • When triggered
    • Script
• Views
  • Columns (see tables)
  • Script
• Procedures
  • Script
  • Parameters (may not work on older versions of MariaDB)
• Functions
  • Script
  • Parameters (may not work on MariaDB 5.1)
  • Returned value (may not work on MariaDB 5.1)

Comments

Dataedo reads MariaDB comments from following objects:

• Tables
  • Columns
  • Primary keys
  • Unique indexes
• Views
  • Columns
• Procedures
• Functions

Dataedo does not write comments back to MariaDB.

Limitations

Following schema/metadata elements currently are not supported:

• Check constraints (vote)
• Non unique indexes (vote)
• Dependencies - are not presented by MariaDB

Connection:

• SSL connection is not currently supported

Learn more

Connect to MariaDB