To create a connection to your system, follow these steps:

  1. Navigate to Settings inline-svg-1 > Data Ingestion > Connections.
  2. In the top-right corner, click New connection, find your system, and click Connect.

General configuration

In the general connection configuration step:

  1. Name your connection for easier identification in Dawiso. Use a unique, descriptive name, for example a combination of the server name and environment, such as server1_prod.
  2. Provide a description of the connection’s purpose.
  3. Select a Connection type.
    • Shared: The source is accessible from the public internet, and you can share your credentials with Dawiso.
    • Private: The source isn’t accessible from the public internet, and you can’t share your credentials with Dawiso. For more information, see Create a private connection.
  4. Click Next.

Server configuration

In the server configuration step, provide the following information:

  1. Server: Host name or IP address of your MariaDB server, e.g., mariadb.mycompany.com. Don’t include the port or a protocol prefix.
  2. Port: The network port used by the MariaDB server for connections. The default port is 3306.
  3. Authentication:
    1. User: Username of the user created in Prepare for MariaDB integration.
    2. Password: Password to your user.

The connection doesn’t specify a database. You select the databases to ingest when you create the data source.

Optional and additional settings

Both Optional Settings and Additional Settings for your connection are optional:

  • Optional Settings: Specify options supported by the provider in JSON format.
  • Additional Settings: A JSON formatted list of additional settings for troubleshooting or advanced connection configuration. Leave this field empty unless Dawiso support asks you to change it.

Enter optional settings as valid JSON.

Encrypt the connection

Dawiso uses an encrypted (TLS) connection whenever your MariaDB server supports it, and connects without encryption when it doesn’t. MariaDB 11.4 and later enable TLS by default, so the connection to them is encrypted without any configuration. On versions earlier than MariaDB 11.4, TLS is available only if your administrator has configured it on the server.

To make Dawiso refuse to connect without encryption, enter the following in Optional settings:

{ "SslMode": "Required" }

With Required, the connection test and the ingestion fail with the error Server does not support SSL if the server has no TLS configured.

Required encrypts the connection but doesn’t check the server certificate. To also verify the certificate, use VerifyCA (the certificate is issued by a trusted authority) or VerifyFull (the host name also matches the certificate). If your server uses a certificate from a private certificate authority, add SslCa with the path to the authority’s certificate in PEM format. The path must exist on the machine that runs the ingestion, for example the Dawiso Integration Runtime (DIR) host:

{ "SslMode": "VerifyFull", "SslCa": "C:/certs/mariadb-ca.pem" }

For all supported values, see the MySqlConnector connection options.

Test and save connection

If your connection is shared, click Test connection and wait a few seconds.

  • If successful, a green checkmark appears next to the button.
  • If it fails, a red error icon appears. Hover over it for a detailed error message. See the troubleshooting section for more information. You can still save the connection.
Tip

If your connection is private and you used dummy credentials, the connection test fails.

Finally, click Save and continue to the next step: creating a data source, where you specify what metadata to ingest.

Troubleshooting

Error messageSolution
Unable to connect to any of the specified MySQL hostsCheck the server name and port, and that the MariaDB server accepts remote connections (bind-address in the server configuration). Make sure your firewall allows connections from Dawiso.
Access denied for userCheck the username and password. Make sure the user’s host part ('user_name'@'host') matches the address Dawiso connects from.
Server does not support SSLSslMode is set to Required or stricter, but the server has no TLS configured. Configure TLS on the server. Don’t remove SslMode to work around this, since that accepts an unencrypted connection.
SSL Authentication ErrorThe server certificate can’t be verified. Set SslCa to the certificate of the authority that issued the server certificate, or correct a host name mismatch. Don’t switch to "SslMode": "Required" to work around this, since that skips certificate verification entirely.