The Bold Reports Designer supports connecting MemSQL database using SQL Query.
DATA
configuration panel, click on the NEW DATA
button.
MemSQL
data source type.
When you create a new data, the NEW DATASOURCE
panel will show up with basic options,
myserver.domain.com
.3306
.Connect
to proceed with query design pane. Now, enter the required query and execute. Its corresponding values will be shown in grid for preview.
Only query mode is supported for MemSQL data source.
Finish
to save the data source with a relevant name to proceed with designing report.
You can now connect to MemSQL data sources through a secure SSH tunnel. This enhancement aims to offer a more robust and secure connection method, especially when accessing remote databases over insecure networks.
SSH Server Name: The address of the server running SSH.
SSH Port: The port number used for SSH connections (default is 22, but might be different).
SSH Username: Your authorized username for SSH access.
SSH Password: Your secure password for the SSH username (keep confidential).
To connect the MemSQL database with advanced options, click on the Advanced Options
in New Data
panel.
Now, the panel is switched to advanced options. In advanced options, you can build your own connection string.
Set the connection string and input the username and password of MemSQL server.
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.
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.
Click on
Basic Options
to switch back to the basic connection settings.
You can set database credentials, prompted credentials, or use 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 access 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 connection string.