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.

Copyright Actuate Corporation 2012