Specifying the data to retrieve from Amazon RDS

Once the report connects to a MySQL or Oracle database in Amazon RDS, you create a data set and write a SQL query to specify what data rows to retrieve.

How to specify what data to retrieve from a database in Amazon RDS

1 In Data Explorer, right-click Data Sets, then choose New Data Set.

2 In New Data Set, specify the following information:

1 In Data Source Selection, select the Amazon RDS data source to use. Data Set Type displays SQL Select Query.

2 In Data Set Name, type a name for the data set.

3 Choose Next.

3 In New Data Set, in Query Text, type a SQL statement that indicates what data to retrieve.

4 Choose Finish to save the data set. Edit Data Set displays the columns, and provides options for editing the data set.

5 Choose Preview Results to view the data rows returned by the data set.