Our Works

Back to projects

Trialto Employee Portal

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:

    • data files provided in different formats, for different time periods, from many different sources
    • data files in different formats (tab delimited, comma delimited, fixed-width, etc.)
    • pricing data pulled from Excel spreadsheets

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

Other Works