The Trialto Wine Group is a premium Canadian wine agency. They represent wineries from around the world, and help those wineries sell their wine in the various Canadian provinces.
Claero was asked to build a data warehouse and a reporting engine to consolidate and store:
The original system was built in 2003 and it is still in use today – but it has been expanded to include Alberta, British Columbia, Manitoba, Saskatchewan, Ontario, and Quebec. It now includes several other modules including private order systems for ON and QC.PHP, MySQL, PDF generation, dynamic graph generation, queued batch job processing, automated website login and file download job creation, automated Amazon S3 file storage