Mission Pharmacal Case Study

This document outlines the use of the NetQuarry Enterprise Application Platform to rapidly build a web application to manage the medical meeting (“Trade Show”) process for Mission Pharmacal. Mission Pharmacal (http://www.missionpharmacal.com) is a privately held pharmaceutical manufacturer headquartered in San Antonio, Texas.

Mission Pharmacal has representatives that attend approximately 100 “medical meetings” a year on behalf of the company. A medical meeting is effectively a trade show where Mission displays, explains, and generates leads on their pharmaceutical products. During the course of a meeting, attendees of the meeting can register at the mission display (booth) to request more information. This data (attendee demographics), is sent to Mission post-meeting in a somewhat standardized format.

Original Process

The original process involved a manual import of the post-meeting data into a Microsoft Excel format. Next, a mail merge was used to generate mailing labels for each of the attendees. The labels were affixed to a thank you letter that included a response card that the attendee could send
back to request samples or more information. When the response card was returned, a separate Mission employee would manually key the responses, including all demographic information, into a Microsoft Access Database. Periodically, the names and their responses from the
response card were exported and printed in a tabular format. This final report was then sent to the customer service department for order fulfillment.

There were several problems with this process. First, it was extremely time consuming and error prone, requiring interaction with at least 3 different applications to manage a single meeting. Second, there was no way to track the fact that attendees can and do attend multiple meetings, which meant that Mission was unable to capitalize on this information. Finally, the process of matching an attendee to an assigned account required a looking into Mission’s SFA system, a step that was impossible due to access and license issues.

Problems Solved

The new software consolidates all of the original processes into a single web interface. From one application, one can enter information about the meeting, import attendees, export labels, manage response cards, and export fulfillment information for customer service. In addition,
the attendees are matched against the Mission Sales Force Automation system and notification is sent to the correct sales representatives of the fact that one of their accounts (called “professionals”) has attended the meeting.

How it was done

Using the NetQuarry platform and one developer, a complete, enterprise-class application was delivered to Mission in a remarkably short amount of time.

The entire process from initial discussions and analysis to running implementation took place in two and one-half days. Of this time, approximately one day was spent on analysis of the problem and existing systems (the SFA system) and one-half day was spent dealing with deployment and testing on Mission’s server.

The application includes rich import and export facilities, manages more than a dozen functionally rich web-based forms, and provides Mission
with a single application to manage all of their medical meetings. Again, all completed in less than three days.

The key to this success was the NetQuarry platform. Using the NetQuarry Studio, a single developer produced a complete application in less than three days.

About NetQuarry

NetQuarry is the Enterprise Application Platform for Microsoft .NET.

The platform is comprised of pre-built software, metadata and tools designed to help professional software teams develop significantly
better enterprise and hosted business applications. Developers using NetQuarry will deliver everything faster (less time and manpower equals less cost):

  • Rapid Prototypes (in as little as one day)
  • Functional applications that perform like highly mature ISV solutions
  • Continuous, quality improvements and iterations
  • Agile response to the reality of changing requirements

The NetQuarry platform is not a code generator. Rather, it is a declarative framework that provides a foundation of deep functionality common to all enterprise and hosted applications, including data binding, database virtualization, OS-virtualization, searching, filtering, user interface, and role-based security.

Today’s dynamic business environments demand a great deal from developers and their managers. Rapid, agile, iterative development allows developers to incorporate frequent feedback from end users, realizing that successful applications are constantly refined, changing rapidly to meet the needs of the enterprise.

Making agile development successful requires advanced software infrastructure and disciplined methodologies. Infrastructure should be
designed to facilitate iterative development, producing quality applications.

Our Value Proposition is simple: Higher quality business applications delivered in a fraction of the time.

For more information, visit www.netquarry.com or contact us via email: info@netquarry.com.

NetQuarry Version 1.1 Released

Version 1.1 adds important features to the platform, including enhanced cross-browser support, rich editable datasheets, and declarative validation. Most significantly, the 1.1 version adds support for Microsoft Visual Studio 2005, Microsoft .NET 2.0, and SQL Server 2005.

NetQuarry Studio

Application Developers build applications by doing one of three primary tasks. First, a developer develops or analyzes the data that is to be used in the application. Second, the developer uses NetQuarry Studio to manipulate meta-data that describes to the NetQuarry runtime how the end application will look and manage the application’s data. Third, any custom business logic is written using any .NET language and IDE (e.g. Visual Studio .NET) to produce focused application extensions.

To describe an application to the NetQuarry runtime the developer interacts with the NetQuarry Studio. The NetQuarry Studio is a Windows application that manipulates the meta-data objects and guides the developer through the creation and management of these objects.

The Studio is built using both Microsoft .NET and the NetQuarry platform. It provides a Visual Studio developer with a familiar user interface paradigm further enhancing the productivity of developers.

NetQuarry Studio is not a replacement for Visual Studio. Rather, it is the main tool interface used to describe the application. Developers still use Visual Studio to write business logic using the .NET language of their choice.

Read the full white paper.


Keeping at the forefront in any industry requires that companies cannot only imagine great new products, but can get them from the vision stage into full production in the most efficient possible manner. The NetQuarry platform provides an engine for driving innovation, enabling products to be designed quickly, collaboratively, and iteratively.

Read the full White Paper.

Issue Track Tutorial

This tutorial explains how to use the platform to create a simple, yet powerful issue tracking application.

In this application, there are two important objects, an “issue” and an “individual.” The issue holds information about the issue or problem report and the individual models information about a user in the system.

The basic requirements are as follows:

  • Users of the system are authenticated using a directory managed by the application.
  • Issues should be entered with a minimum of information – description, type, severity. The rest of the information should default to reasonable values.
  • Issues assigned to the logged in user should be easily available.
  • Issues can be related to each other. This relationship may be specified as related, duplicate, dependency. Relationships are displayed only in one direction.
  • The Issue and Individual objects must support attachments and free text notes.
  • The Issue and Individual objects should track the last updated user and last updated date/time.
  • Read the document here.

    NetQuarry Version 1.0 Released

    LONG BEACH, Calif. – August 31, 2005 – NetQuarry, Inc. announces release of v1.0 of its NetQuarry Enterprise Application Platform. The NetQuarry platform is developed in and for the Microsoft .NET 1.1 environment and supports customization in any .Net CLR-compliant language.