Connect to Amazon Aurora data source

The Bold Reports Designer supports connecting multiple database through Amazon Aurora using SQL Query.

How to create Amazon Aurora data source

To configure the Amazon Aurora data source, follow these steps:

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

Create Amazon Aurora data source with basic options

When you create a new data, the NEW DATASOURCE panel will show up with basic options.

1. Specify the data source name without special characters in the Name field.

2. Select a database engine you want to use with the given Amazon Aurora Server from the Database Engine drop-down.

3. Enter a valid Amazon Aurora server or host name in the Server Name field.

4. Enter a valid Amazon Aurora username in the UserName text box.

5. Enter a valid Amazon Aurora password in the Password text box.

6. Select a database that you want to query in the listed database associated with the given Amazon Aurora server in the database drop-down.

   

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.

Click Finish to save the data source with a relevant name to proceed with designing report.

Amazon Aurora supported database engine in Bold Reports

• MySQL
• PostgreSQL

See Also

MySQL

PostgreSQL

Postgre SSH Settings

MySQL SSH Settings