Omni Loader Docs
  • OVERVIEW
    • About
    • Getting Started
    • Databases
    • Performance considerations
    • Prerequisites
  • Project Wizard
    • General
    • Database List
    • Favorites
    • Review
  • Project types
    • Full Table Copy
    • Data Compare & Sync
    • Change Data Capture
    • Overview
  • Project Options
    • General
    • Performance
    • Databases
    • Mapping
    • Logging
    • Troubleshooting
  • Table Options
    • Columns
    • WHERE clause
    • Partitioning
    • Cut-off
    • Options Override
  • Global Settings
    • Overview
  • Automations
    • Overview
    • JSON job specification
  • Connections
    • Amazon RedShift
    • Analytics Platform System
    • Synapse Dedicated Pool
    • CockroachDB
    • CSV
    • Databricks
    • DB2 iSeries
    • DB2 LUW
    • DB2 zOS
    • Greenplum
    • Google AlloyDB
    • Google BigQuery
    • MariaDB
    • MySQL
    • Netezza
    • NuoDB
    • ODBC
    • Oracle
    • Parquet
    • PostgreSQL
    • Snowflake
    • Sybase ASE
    • Sybase IQ
    • SQL Server
    • Teradata
    • Vertica ODBC
    • Fabric Lakehouse
    • Fabric Warehouse
    • Azure SQL Database
    • V-ORDER Fabric Lakehouse Optimization
Powered by GitBook
On this page
  • Connection Details
  • Server
  • Port
  • Username
  • Password
  • Database
  • Encryption
  • Include views as tables
  1. Connections

MariaDB

PreviousGoogle BigQueryNextMySQL

Last updated 10 months ago

Connection Details

Server

Enter the hostname or IP address of the MariaDB server. Use localhost if the database server is on the same machine as the migration tool.

Port

The port number for MariaDB, which is typically 3306. Make sure this matches the configuration of the MariaDB server.

Username

The username for the database login, often root for administrative access.

Password

Enter the password corresponding to the username provided.

Database

Click 'Select' to browse available databases, or manually enter the name of the database you want to connect to.

Encryption

Toggle between Not encrypted and Encrypted to indicate if the connection should be secured with SSL. Using Encrypted is recommended when sensitive data is being transmitted, particularly over public networks.

Include views as tables

Check this if you want the migration tool to treat views as tables. This can be useful if you need to include data that is aggregated or presented through views in your database migration.