Selecting the data to use in a data source

After you configure the description and connection information for a data source, you select the specific data to include.

1. For an Oracle BI data source:
   
   1. On the Select Data Table page of the data source dialog, from the Subject Area drop-down list, select the subject area to use.

      The Presentation Table list is populated with the available tables from the selected subject area. The list only includes tables that contain data.

   2. To select the presentation table to use for the data source, click the presentation table, then click Next.

      The Configure Data Source page is displayed. See Configuring the attributes in a data source.

2. For a JDBC connection data source:
   
   1. On the Data Source Definition page, in the text area, type the SQL query to use to retrieve the data.

      Do not include a trailing semicolon in the query. While direct SQL queries to a database do require the semicolon, it is not required for SQL queries over JDBC, and may cause errors.

      When selecting the data, also note that data sources cannot include columns that have the following data types:

      • BINARY_FLOAT
      • BINARY_DOUBLE
      • BLOB
      • BFILE
      • LONGBLOB
      • LONG RAW
      • MEDIUMBLOB
      • RAW
      • TIMESTAMP WITH TIME ZONE
      • TIMESTAMP WITH LOCAL TIME ZONE
      • UROWID

      If columns using these data types are included, Studio returns a validation error.

   2. Click Next.

      Studio validates the SQL before continuing to the Configure Data Source page. See Configuring the attributes in a data source.