4.1.2 Creating a Table from Database Tables
In most cases, you should access data from a relational database only via queries and data models. (See the Data Modeling for information on creating queries and data models.) However, you can also directly access the underlying database tables.
Note: Whenever possible, use queries or data models to create Worksheet assets. Only use database tables directly if this is absolutely necessary.
To create a Worksheet table or column directly from a database table, follow these steps:
1. Expand the 'TABLE' folder in the Asset Repository tree. The database tables are now listed in the tree.

If the 'TABLE' folder is empty or nonexistent, your administrator may have disabled the listing of the physical fields. If the 'TABLE' folder does not reflect recent changes to the database schema, your administrator may need to refresh the metadata. See Specifying Data Source Information in Administration Reference.
2. Drag and drop a table or table column into the Worksheet. (This is the same as adding a query or query column to the Worksheet. See Creating a Regular Data Table and Adding a Table Column for details.)
| << 4.1.1 Creating a Table from a Query or Data Model | © 1996-2013 InetSoft Technology Corporation (v11.5) | 4.1.3 Creating a Table from Existing Table Columns >> |