Connect to Amazon Aurora data source

The Bold Reports® Designer supports connecting multiple database through Amazon Aurora using SQL Query. You can use the MySQL or PostgreSQL database engine and feed the query results to your reports.

How do I create an Amazon Aurora data source?

To create an Amazon Aurora data source in the Bold Reports® Designer, open the Data configuration panel and choose the Amazon Aurora connection type.

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

How do I configure the 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. 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.

    Web datasource properties

  7. Click Connect to open the query design pane.

  8. Enter the required query and execute it. The corresponding values appear in a grid for preview.

    New connection panel

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

New connection panel

Amazon Aurora supported database engine in Bold Reports®

Bold Reports® supports the following Amazon Aurora database engines:

  • MySQL
  • PostgreSQL

The following image shows the Database Engine drop-down.

Database Engine

Frequently asked questions

Which database engines can I use with Amazon Aurora in Bold Reports®?

Bold Reports® supports the MySQL and PostgreSQL database engines for Amazon Aurora.

How do I preview Amazon Aurora data before saving the data source?

Click Connect, enter the required query, and execute it. The corresponding values appear in a grid for preview.

See Also