Defining a data set
To define a data set you must provide a query and set options for the query.
*
Defines a SQL query from a relational database data source. You can type a query manually, and use Get columns to retrieve the columns from the data set.
Alternatively, you can use View database structure to select tables and columns. Use Datasource to select tables and their columns, and specify the column order.
*
Enter the options required by the connection drivers. For example, when loading data from an Oracle database, it is recommended to include a parameter, such as PreFetchRows=10000.
The process of defining the target table structure is the same as the one discussed in Defining table columns, earlier in this section. While you edit the structure of a target data table, use Get columns to retrieve existing column information, then use Edit to make modifications. To create a new column, choose New, then provide information using Table Declaration, as shown in Figure 3-22section.

Additional Links:

Copyright Actuate Corporation 2013 BIRT Analytics 4.2