Bookshelf Home | Contents | Index | Search | PDF |
Siebel Analytics Server Administration Guide > Creating and Administering the Physical Layer in a Repository > Setting Up Database Objects >
Specifying SQL Features Supported by a Database
When you import the schema or specify a database type in the General tab of the Database dialog box, the Feature table is automatically populated with default values appropriate for the database type. These are the SQL features that the Analytics Server uses with this data source.
You can tailor the default query features for a database. For example, if a data source supports left outer join queries but you want to prohibit the Analytics server from sending such queries to a particular database, you can change this default setting in the Feature table.
CAUTION: Be very careful when modifying the Feature table. If you enable SQL features that the database does not support, your query may return errors and unexpected results. If you disable supported SQL features, the server could issue less efficient SQL to the database.
To specify SQL features supported by a database
- In the Physical layer of the Administration Tool, double-click the database.
- In the Database dialog box, click the Features tab.
- In the Features tab, use the information in the following list to help you locate and specify SQL features:
Used only if installing and querying a database that has no Features table. Allows you to query this database for Feature table entries. For more information, see Changing Feature Table Entries Using Ask DBMS.Changing Feature Table Entries Using Ask DBMS
You should use the Ask DBMS button only if installing and querying a database that has no Features table.
NOTE: The Ask DBMS button is not available if you are using an XML or a multidimensional data source.
The Ask DBMS button on the Features tab of the Database dialog box allows you to query a database for the SQL features it supports. You can change the entries that appear in the Feature table based on your query results.
CAUTION: Be very careful when using Ask DBMS. The results of the features query are not always an accurate reflection of the SQL features actually supported by the data source. You should only use this functionality with the assistance of Siebel Technical Support.
Bookshelf Home | Contents | Index | Search | PDF |
Siebel Analytics Server Administration Guide Published: 11 March 2004 |