Vision • Experience • Commitment

BackgroundBackground

Background

Alan Miles has provided a wide range of computer related products and services as an innovator, developer and IT Manager for small to medium businesses.
Automated WeighingAutomated Weighing

Automated Weighing

Automated Weighing - various applications in dairy and meat industries. Automated milk powder weighing and packaging applications. Convenient weighing, grading and record keeping in meat processing.
BizTermBizTerm

BizTerm

BizTerm™ is a telnet terminal emulator compatible with Windows 7 specifically designed for Pick Systems® D3® multidimensional database.
CrusaderCrusader

Crusader

Crusader is an integrated Enterprise Resource Planning (ERP) and financial management solution.
Dough ConsistencyDough Consistency

Dough Consistency

Dough Consistency Controller that automatically adjusts for water content in bread dough.
EDI ServerEDI Server

EDI Server

Business to business electronic document exchange including e-mailed purchase orders, invoices and statements, and various graphically printed documents.
Email ServicesEmail Services

Email Services

An e-mail services facility that allows e-mails to be scheduled on a regular basis, to deliver a wide range of reports.
Enterprise ExplorerEnterprise Explorer

Enterprise Explorer

Enterprise Explorer™ is a business intelligence tool that is intuitive, flexible, comprehensive, and quick to use.
Environmental MonitorEnvironmental Monitor

Environmental Monitor

Environmental Monitoring used in coolstores and greenhouses.
MVMirrorMVMirror

MVMirror

MVMirror is a real-time bidirectional gateway between D3 and SQL Server databases.
Older ProjectsOlder Projects

Older Projects

Summary of early projects and clients
Production MonitoringProduction Monitoring

Production Monitoring

This system was an early and very successful attempt to automate specific manufacturing business processes and monitoring not just the rate of production, but the reasons for and period of down-time.
Timber TreatmentTimber Treatment

Timber Treatment

Automation of a timber pressure treatment plant for the preservation of timber.
Energy ManagementEnergy Management

Energy Management

Automated control of energy usage to reduce cost while maintaining asdequate environmental conditions and production processes.
Energy Management Brochure 1Energy Management Brochure 1

Energy Management Brochure 1

Energy Management Brochure Page 1
Energy Management Brochure 2Energy Management Brochure 2

Energy Management Brochure 2

Energy Management Brochure Page 2
Energy Management Brochure 3Energy Management Brochure 3

Energy Management Brochure 3

Energy Management Brochure Page 3
Energy Management Brochure 4Energy Management Brochure 4

Energy Management Brochure 4

Energy Management Brochure Page 4
Energy Management Brochure 5Energy Management Brochure 5

Energy Management Brochure 5

Energy Management Brochure Page 5
Energy Management Brochure 6Energy Management Brochure 6

Energy Management Brochure 6

Energy Management Brochure Page 6

MVMirror

MVMirror is a real-time bidirectional gateway between D3 and SQL Server databases. Many clients have this service installed to provide ancillary functionality for Crusader that is supported from SQL Server.  In one case it serves as the interface between Crusader and an automated courier labelling and manifest system.

Many legacy systems are implemented using the D3® (Pick®) multidimensional database.  Being multidimensional provides many advantages, however since data is stored in a non-relational format it can be quite difficult for these systems to be integrated with Windows technology.  For many businesses who rely on a D3® database, sophisticated reporting and interfacing to other systems will be difficult, if not impossible.

MVMirror™ is designed to overcome this difficulty by providing a two-way link between the relational and non-relational world.  Using MVMirror™, selected D3® files can be replicated to tables in a relational database.  Any time data changes in the D3® file, the changes are automatically transmitted to the relational database.  If the relational database is Microsoft® SQL Server®, changes can be reflected in both directions.

With MVMirror™ it is possible to integrate products such as Microsoft® Reporting Services™, Microsoft® CRM™ and Microsoft® Analysis Services (or any other product which expects an ANSI SQL interface) with systems running on D3®.  Other systems that are designed to work with SQL Server can share their data with a D3® application, providing seamless operation.

How does it work?

Triggers on the D3® database (and SQL Server, if that is the relational database being used) record changes made to data.  A special process running on the D3® database is used to translate those changes into commands - either SQL commands if the changes have been made on the D3® database, or D3® FlashBASIC™ operations if it is the SQL Server database which has changed.  The process then executes those commands to ensure that the data in both databases is the same.

When setting up MVMirror™, it is necessary to create a set of “data definitions” which are used when translating between databases.  These definitions can also be used to specify what happens when changes occur to both databases at the same time.  Rules can be used to ensure one database takes priority over the other, or to combine the changes and apply them to both.

Software made in New Zealand

Copyright © 2020, Amba Limited, Whanganui, New Zealand. All Rights Reserved.