|
|
:
Technological Overview |
|
Architecture
- EQWin Desktop Edition
is designed for standalone use on a desktop or portable PC,
and for workgroup use on a LAN with a shared directory for database files.
- EQWin System Manager
provides administrative facilities for creating databases,
customizing database tables, and controlling user access.
EQWin Data Manager provides a limited subset of these
functions.
- We utilize XML extensively for
file formats.
- Our use of COM technology facilitates customized
application development using tools such
as Visual Basic. EQWin
provides COM automation objects that a VB programmer or
application expert can use to retrieve EQWin data and work with it
in ways specific to environmental tasks, such as retrieving
sampling results for display in a GIS.
Database support
- EQWin utilizes Microsoft
Windows ADO and ODBC technologies, which provide support for
most popular database types and which are part of
Microsoft's database support roadmap.
- EQWin Desktop Edition
currently supports Access 2003 databases.
Support is planned for later versions of Access,
and for MS SQL Server during 2012.
Microsoft Excel integration
- EQWin Data Manager is the only data management software
currently available to be dynamically integrated with
Microsoft Excel via office automation (COM
and ActiveX) technology. This enables Excel
to be used interactively as EQWin Data Manager's default input
source and output
destination.
- Environemntal
professionals find EQWin Data Manager
intuitive and easy to use.
It lets users work in a familiar spreadsheet environment for all of their data
import, validation, interpretation, analysis and reporting.
- Competing software systems still use
static
connectivity (export) as the means
of outputting data
to a spreadsheet or other third party application. This static
export system does not detect any changes made to the database,
and therefore does not automatically reflect them in report
updates. EQWin ouput maintains live
links to the database and can refresh a report with a single
click.
|