If you are creating a data source from a relational database management system (RDBMS), you have the option to selectively retrieve data by defining a structured query language (SQL) WHERE clause. For example, you might want to exclude data for a particular sales rep or region. The SQL WHERE clause you insert will be displayed in the Creation Rule metadata column in the Source Metadata view. The Creation Rule column will also be available in the list when choosing columns for view.
Note the following:
- This procedure assumes you are familiar with the syntax for defining SQL conditions.
- The Discovery Center does not validate your SQL syntax.
- Extended SQL syntax is not supported.
To filter relational database data
-
To change the clause, click the edit icon (
).