Use a MariaDB database for synthetic data

If you use the web application, create a new Oracle connector from the Connectors page.

Steps

1. From the Connectors page, click New connector.
2. From the Create a new connector window, select MariaDB.
3. From the New connector page, configure the connector.
   1. For Name, enter a name that you can distinguish from other connectors.
   2. For Access type, select whether you want to use the connector as a source or destination.
   3. For Host, enter the MariaDB database hostname.
   4. For Port, enter the database port.
      The default port for MariaDB databases is 3306.

   5. For Username and Password, enter your MariaDB database credentials.
4. Click Save to save your new MariaDB connector.
   
   MOSTLY AI tests the connection. If you see an error, check the connection details, update them, and click Save again.
   
   You can click Save anyway to save the connector disregarding any errors.

If you use the Python client, create a MariaDB connector with mostly.connect() and provide a connector configuration dictionary as shown below.

c = mostly.connect({
    "name": "MariaDB Connector",
    "type": "MARIADB",
    "access_type": "SOURCE",
    "config": {
        "host": "mariadb.hostname.com",
        "port": "3306",
        "username": "admin",
    },
    "secrets": {
        "password": "******"
    },
    "test_connection": True
})