Welcome to the ViewManager User's Guide.
This document describes how to use the Omnify ViewManager to create and manage database views.
Views are stored queries that act as a virtual table in the database. Unlike ordinary tables, a view does not form part of the physical schema.
A view is a dynamic, virtual table computed or collated from data in the database.
Changing the data in a table alters the data shown in the view.
Views can combine (link) data from various tables in a database.
Views can be accessed by 3rd party applications to provide a real-time, dynamic view of Omnify data. Examples include:
| • | CAD/CAE systems: Mentor Graphics, Cadence Design, Altium, etc. |
| • | ERP/MRP systems: Oracle, SAP, NetSuite, Consona, Infor, etc. |
| • | Reporting systems: Crystal, SQL Server, Microsoft Excel, etc. |
| • | Custom database applications |
Using the Omnify ViewManager, you can create views for the following Omnify objects:
| • | Items/Parts/BOMs |
| • | Changes/ECOs |
| • | Projects |
| • | CARs/PARs |
| • | Vendor Items |
|