Scantraq can be linked to
industry-standard database software.
Why you need the
Quality-control departments can organize tens of thousands of spectral
measurements and select them according to type, customer, etc.
Management can evaluate trends, identify problem areas, and
perform what-if analyses. Calculations can be performed over selected data sets.
ensured via user-name and password protection, audit trails, etc. Unlike
solutions provided by spectrophotometer manufacturers, a world-wide support
network is available.
Scantraq provides the programming examples you
need to utilize database technology in your facility. With database technology
Scantraq becomes an important tool for managing
meeting quality requirements.
As an alternative (or supplement) to the
solutions given below, the optional Scantraq Database also supports NTFS file
properties. Click here to learn more.
Flash Video Demo
Why you need the Scantraq
Database Take advantage
of popular business software to organize, select, sort
and interpret spectral data! It's easier than you think! (3.75 min)
FileMaker Pro Database Solution
FileMaker Pro provides
means to store spectra and/or scan methods in a secure database environment. With
millions of users, FileMaker is an industry-standard database which can
be part of a 21 CFR Part 11
solution. FileMaker Pro provides means to integrate with corporate
(enterprise) databases such as Oracle, SQL Server, etc.
FileMaker user-privileges can be password protected. Data files (and optional pictures) can be stored directly in the database
instead of in disk directories. Examples for storing spectra are based on the
following FileMaker advances:
Scantraq BASIC can run FileMaker scripts via ActiveX.
Once you understand the included examples, you'll be amazed how simple and
is. Measure a sample and the spectrum automatically appears in the
database; it's that easy!
FileMaker Pro includes the ability
to customize menu commands according to user name and password. This feature is essential in ensuring
that users and browsers do not alter results or modify database structures.
FileMaker Pro includes container fields
which store data files as well as pictures.
Thousands of spectra and
pictures can be stored in a single database file.
Click here for further
information. FileMaker Pro 12
adds new support for saving PDF documents. QA reports can be reviewed and printed directly.
MDB Database Solution
SQPlot as Graphics Browser
Another possibility is to update
and edit Access-compatible .mdb files with Scantraq BASIC. While this requires programming
effort beyond that required for our FileMaker solution, it offers ultimate flexibility
for organizations committed to MS Access databases.
The relevant Scantraq BASIC
code is surprisingly straightforward with relatively few new keywords. An
example with documented code is provided with Scantraq. The example installs the
MS database engine and does not actually require MS Access (recommended).
Finally, MS Access itself can be
controlled from Scantraq BASIC.