How do I use MemSQL as a data source in Cloud Reporting?

The Bold Reports® Cloud Web Report Designer connects to a MemSQL database and retrieves data with a SQL query.

What the MemSQL connector supports

The Web Report Designer connects to MemSQL with the following options.

Item Supported in Cloud Reporting
Default port 3306
Query design Query mode only. You write and execute a SQL query.
Connection options Basic options (server, port, username, password, database) or advanced options (your own connection string)
Authentication types (advanced options) Authentication, Prompt, None
Save password Embeds the credentials in the report saved in the Report Server. A downloaded report does not keep them.

How to choose the MemSQL data source

In the Web Report Designer, you add a MemSQL data source from the DATA configuration panel by clicking NEW DATA and selecting MemSQL.

  1. Click the Data icon in the configuration panel. Data icon configuration panel
  2. In the DATA configuration panel, click NEW DATA. NEW DATA button in the DATA configuration panel
  3. In the connection type panel, select MemSQL. MemSQL selected in the data source connection types panel

Create MemSQL data source with basic options

When you create a new data source, the NEW DATASOURCE panel opens with the following basic options:

  1. Specify the data source name without special characters, in Name field.
  2. In the Server Name field, enter the remote server name, such as myserver.domain.com.
  3. In the Port field, enter the port number. The default port is 3306.
  4. Specify the username of your MemSQL server in Username field.
  5. Specify the password of your MemSQL server in 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 database, such as Northwind. MemSQL basic options with server, port, credentials, and database
  8. Click Connect to open the query design pane, and then enter and execute your query to preview the values in a grid. MemSQL query design pane with query results in the preview grid

    Only query mode is supported for MemSQL data source.

  9. Click Finish to save the data source and continue designing the report. Saved MemSQL data source in the DATA configuration panel list

Create MemSQL data source with advanced options

To connect to MemSQL with your own connection string, click Advanced Options in the New Data panel.

Advanced Options link in the MemSQL New Data panel

The panel switches to advanced options, where you can build your own connection string.

Set the connection string and input the username and password of MemSQL server.

MemSQL advanced options with connection string, username, and password

Click on the Connect to proceed with query design pane. Now, enter the required query and execute. Its corresponding values will be shown in grid for preview. MemSQL query results in the query design pane preview grid

Only query mode is supported for MemSQL data source.

Click Finish to save the data source with a relevant name to proceed with designing report. New MemSQL data source in the report data list

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

Basic Options link to switch back to MemSQL basic settings

Authentication types for advanced connection

For a MemSQL advanced connection, choose Authentication for database credentials, Prompt for prompted credentials, or None for no credentials.

MemSQL authentication types list with database, prompt, and none

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.

MemSQL database authentication with username and password fields

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

When you download the report, the credentials are not saved with the 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 during preview to retrieve the data.

Prompt authentication selected for MemSQL prompted credentials

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

Frequently asked questions

What details do I need to connect to MemSQL?

You need the MemSQL server name, the port (default 3306), a username and password, and the database name. Enter them in the basic options of the NEW DATASOURCE panel.

Does the MemSQL connector support design view?

No. Only query mode is supported for the MemSQL data source. Write your SQL query in the query design pane and execute it to preview the data.

Why can’t I connect to my MemSQL server?

Connections to your MemSQL server come from fixed IP addresses. Allow inbound connections from those addresses in your database firewall or security group. See IP addresses to whitelist for remote database access.

Can viewers enter their own MemSQL credentials?

Yes. In Advanced Options, set the authentication type to Prompt. Each user then enters a user name and password on preview to retrieve the data.

Data connectors

Create an embedded data source

Create an embedded dataset

Define query parameters

IP addresses to whitelist for remote database access