Connect to MariaDB data source

The Bold Reports^® Designer supports connecting MariaDB database using SQL Query. You can connect with basic options, advanced options, or through a secure SSH tunnel.

How do I choose the MariaDB data source?

To choose the MariaDB data source in the Bold Reports^® Designer, open the Data configuration panel and select the MariaDB connection type.

1. Click the Data icon in the configuration panel.
2. In the DATA configuration panel, click the NEW DATA button.
3. In the connection type panel, choose the MariaDB data source type.

How do I create a MariaDB data source with basic options?

When you create a new data source in the Bold Reports^® Designer, the NEW DATASOURCE panel shows the basic options.

1. Specify the data source name without special characters in the Name field.
2. In the Server Name field, specify the remote server name, like myserver.domain.com.
3. In the Port field, specify the Port number. The default port number is 3306.
4. Specify the username of your MariaDB server in the Username field.
5. Specify the password of your MariaDB server in the Password field.
6. Enable the Save password option to embed the credentials within the report when saving it in Bold Reports^® Report Server.
7. Choose or enter an existing valid database, e.g. Northwind.
8. Click Connect to open the query design pane. Enter the required query and execute it. The corresponding values appear in a grid for preview.

   Only query mode is supported for MySQL data source.

9. Click Finish to save the data source with a relevant name and continue designing the report.

How do I connect to MariaDB through an SSH tunnel?

Bold Reports^® lets you connect to a MariaDB data source using a secure SSH tunnel. The SSH tunnel provides a more secure method for connecting, especially when you access remote databases over untrusted or insecure networks.

Refer to Configuring SSH tunnel for data connectors for more details.

How do I create a MariaDB data source with advanced options?

The Bold Reports^® advanced options let you build your own connection string for MariaDB.

1. Click Advanced Options in the New Data panel.

   

2. The panel switches to advanced options. Set the connection string and input the username and password of the MariaDB server.

   

3. Click Connect to open the query design pane. Enter the required query and execute it. The corresponding values appear in a grid for preview.

   Only query mode is supported for MariaDB data source.

4. Click Finish to save the data source with a relevant name and continue designing the report.

Click Basic Options to switch back to the basic connection settings.

Authentication types for advanced connection

Bold Reports^® advanced MariaDB connections support database credentials, prompted credentials, or no credentials.

Authentication - A user name and password must be supplied to access the database, the credentials might be for a database login. The credentials are passed to the data source for authentication.

Enable the Save Password option to embed the credentials within the report when saving it in Report Server.

On report download action, the credentials will be not be saved with report data.

Prompt - When you configure a data source connection to use prompted credentials, each user who accesses the report must enter a user name and password on preview action to retrieve the data.

None - Choose the authentication type as None when the authentication details or any other arguments required to connect with the data source are provided in the connection string.

Frequently asked questions

What is the default MariaDB port?

The default port number is 3306.

Does the MariaDB data source support design view?

No. Only query mode is supported for the MariaDB data source.

Can I connect to MariaDB through an SSH tunnel?

Yes. Bold Reports^® supports connecting to a MariaDB data source through a secure SSH tunnel.

See also

• Connect to MySQL data source
• Configuring SSH tunnel for data connectors
• Connect to Amazon RDS data source