User's Guide Overview

Overview

Welcome to the ViewManager User's Guide.

This document describes how to use the Empower ViewManager to create and manage database views and reports.

The ViewManager allows you to create:

Types	Description
Views	Stored database queries that are accessible to 3rd party applications
Reports	Stored database queries that are only accessible to Empower applications

Database 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 Empower data. Examples include:

• CAD/CAE systems: Mentor Graphics, Cadence Design, Altium, etc.
• ERP/MRP systems: Oracle, SAP, NetSuite, Aptean, Infor, etc.
• Reporting systems: Crystal, SQL Server, Microsoft Excel, etc.
• Custom database applications

Using the Empower ViewManager, you can create reports and views for the following Empower objects:

• Items/Parts/BOMs
• Changes/ECOs
• Projects
• CARs/PARs
• Vendor Items

Contents

Section	Description/Topics
Launching/Accessing the ViewManager	Various ways to launch the ViewManager
ViewManager Home Page	Navigating the pages and features of the ViewManager
Creating Views/Reports	Topics for creating database views and reports
Modifying Views/Reports	Topics for modifying database views and reports
Deleting Views/Reports	Topics for deleting database views and reports
Displaying Views/Reports	Viewing the contents/results of any database view or report

For additional support please contact Arena Empower at:

Ways	Address
Support Email	arena-support@ptc.com
Support Portal	https://arenasolutions.my.salesforce.com/sserv/login.jsp?orgId=00D00000000hZci