Zoomdata Version

Connecting to Aurora

To configure the connector, perform the following steps:

  1. Log into Zoomdata.
  2. Click the Sources menu item.

Figure 1

  1. Click the Aurora connector icon.
  2. Specify the name of your source and add a description (if desired).

Figure 2

  1. Click Next . On the 'Connection' page, specify the connection name and JDBC URL. You can also specify the user name and password. Click Validate . When the credentials have been validated and saved, click Next .

Figure 3

  1. On the 'Tables' page, select the schema and the data collection to use for your charts.  If you want to add a custom SQL query to retrieve the data, click Custom SQL .
Zoomdata wraps your SQL query into a SELECT statement. If specific statements inside the wrapped query are not supported by your data source, the query will not be executed.
  1. Toggle the caching options (SparkIt and Caching) as needed (by default, SparkIt is disabled; access the article How Zoomdata Caches the Data for more information).
    Click Next to continue.

Figure 4

  1. On the 'Fields' page, you can create unique label names for the available fields in your data source. These labels will be displayed on the charts. Create unique label names, as needed, for each 'Label' field. If necessary, change the 'Type' and 'Default' options, select the checkboxes in the 'Distinct Count' column. Configure Filter Display settings for the required fields. Click Next .

Figure 5

  1. On the Refresh page, you can schedule asynchronous jobs to refresh fields in your data source. Refer to Using the Zoomdata Scheduler article for more information.
  2. On the Charts page, you can:
    • Edit Global Default Settings
    • Select the Standard and, if available, Custom chart styles to be used with the data source
    • Set default parameters  (group-bys, colors, sorting, etc.) for each chart style
    Learn more about how to customize a chart .

Figure 6

  1. Click Finish to save your changes.