Database connectivity is flexible and easy within Hexatec SCAN1000 v5
This allows a wide range of options:
For general database access, the ADO and DAO connectivity options support a wide range of database types including, traditional databases such as:
- SQL Server
- Access
- DBase, Oracle, etc (via ODBC)
Other data sources include
- Excel
- Outlook
- text and csv files.
For examples of - database integration, take a look at the following case studies:
ADO (ActiveX Data Objects) supports fast, low overhead access to a wide variety of data sources. ADO database support offers optimised
connection to any data source, which has a corresponding OLEDB provider. This includes large client - server based databases such as SQL Server and Oracle,
along with a wide range of other options.
With ADO, databases are normally pre-created and then the project data is then linked to the database.
DAO (Data Access Objects) is an alternative data access system. DAO is normally used where smaller scale database
facilities are required. In this case the software can directly create Microsoft Access databases, based on project structure. It is not necessary to have a copy
of Access to use this facility.
Some applications require high levels of security or for system settings to be held in a central location. This is achieved using the
Security Database option. A common, shared database can
be created, which is used as a central depository for key parameters such as;
user name and password, calibration settings, alarm set-points, etc.
Event Logs are an easy way to process on-going system information, such
as: user-logs, alerts, system warnings, changed data values, etc. As well as storing event logs in
readable text files, or routing them to printers, they can be written to sequential tables in Microsoft Access databases.