Testing Your VDB

In Dimension Designer you can execute a VDB to test/query actual data. (see Virtual Database Summary ). To execute a VDB, follow the steps below:

> Step 1: In the VDB Explorer, click on the Test Sources and Views icon to switch to the SQL Explorer perspective. Your VDB should now be connected via the connector bindings defined previously. Verify the connection in the Connections View.

> Step 2: In the Database Structure View (upper left), expand the Table node to list the tables in your VDB.

> Step 3: Select one of the tables and do a right click. Select the ‘Generate Select in SQL Editor’ menu item.

> Step 4: A SELECT statement will appear in the editor (upper right).

> Step 5: Click the Execute SQL icon to run the SQL. Results will appear in the SQL Results tab (lower right).

Related Topics

- What's a VDB?
- Create a New VDB
- SQL Explorer Perspective
- Web Service Advisor View
- Getting Started with Metamatrix Dimension

(c) Copyright © 2000-2006 MetaMatrix, Inc. All rights reserved.
Visit http://www.metamatrix.com