Using Virtual Entity Wizard

If your organization has information stored in databases other than the Aptify database, you can add links to this data as a virtual entity. A virtual entity provides read-only access to data stored outside of Aptify (or to data stored within Aptify but not accessible via a standard entity). Virtual Entities allow an organization to centralize all of its data in Aptify, even if some business operations store data in non-Aptify databases.

Organizations can use Aptify's feature-rich viewing system to create views (list view, charts, and calendars) or use the Report Wizard to run reports on this data. Note that since access is read-only, users cannot open forms, update existing information, or add new records for virtual entities.

Administrators can easily create virtual entities using the Virtual Entity Wizard. The wizard can add a virtual entity for the following types of data:

• External data stored in another database on the same SQL server as Aptify.
• External data stored in another location on the network that has a Linked Server relationship with the SQL Server on which Aptify is installed.
• Data within Aptify that is not available from a top-level entity, such as sub-type data or organization-specific SQL views. Aptify's hierarchies feature for List views provides visibility for sub-type information within the viewing system, but a virtual entity further extends this functionality, allowing an organization to create a filter relationship between a sub-type and its parent and to report on the sub-type data using chart or calendar views.

This section describes how to create a virtual entity using the wizard. It covers the following topics:

• Understanding the Virtual Entity Data Requirements
• Creating a Linked Server Relationship for a Virtual Entity
• Creating a View in a Local Database to Point to a Virtual Entity Data Source
• Setting Up a Virtual Entity Using the Wizard
• About the Virtual Entity Characteristics