Trouble Viewing Images? Right-click on any image and select "Open in new tab" to view a larger version. You can also zoom in using Ctrl + Mouse Wheel for easier readability.
Article Goal
This article explains how to navigate and interact with the Tables / Fields section in VDM. This is a foundational step in creating a View.
Steps in this article will require a connection to a database. Reference How to Connect to a Database in VDM if you do not already have a database connection within VDM.
Why Use Tables and Fields?
The Tables and Fields panel displays all available tables and fields for your connected databases. From this panel, you can:
Browse schema structure
Expand tables to view available fields
Add fields to your report by dragging or double-clicking
Note: Field names only appear after clicking and expanding the table name.
Video Tutorial
Steps To Use Tables and Fields
1. Open VDM.
2. Connect to your database, then expand the connection to view the available schemas and tables.
3. If Prefix TO/Schema Name is enabled for the connection, expand the schema node to view the available tables.
4. Expand a table to view its available fields.
5. Add fields to your View using one of the following methods:
- Double-click the field.
- Drag the field into the Report Fields section.
Right-Click Menu Options
Database Menu
| Option | Description |
|---|---|
| Connect | Connect to the selected database |
| Disconnect | Disconnect from the selected database |
| Edit | Open the Connection Wizard to modify settings |
| Load All Tables | Preload all tables from the database |
| Delete | Remove the selected database from the list |
| Expand All Tables | Expand all tables and fields in the tree view |
| Collapse All Tables | Collapse the entire tree view |
| Find Tables | Search for table names matching a string |
| Show All Tables | Reset filters and display all tables |
| Show Favorites | Display only favorited tables |
| Edit Knowledge (Beta) | Opens the Knowledge Editor for managing schema information, database relationships, and profile-specific reporting guidance. |
Right-click on the database to show the menu.
Table Menu
| Option | Description |
|---|---|
| Add to Favorites | Add this table to your favorites list |
| View Schema | Display the schema definition of the table |
Right-click on the table to show the menu.
Tip: Favorited tables appear when using the Show Favorites filter. This is useful when working with a subset of tables across large schemas.
Summary
The Tables / Fields panel is the starting point for building a View in VDM. Whether you’re browsing schemas, adding report fields, or marking tables as favorites, this section helps you structure your data before applying filters or visualizations.
Comments
2 comments
Under Right Click Menus in Tables and Fields it states
Can you confirm if this is correct? I would think that it deletes the Connection Profile
Thanks for pointing that out, Nicolas. I have made the correction.
Please sign in to leave a comment.