Home 
Myriad SQL from Orcus
The SQL module provides outstanding depth of reporting.
Drills down to any data field within the whole of Myriad to offer comprehensive and customised bespoke reporting.
SQL dramatically increases the quality and quantity of information available for an expansive range of business purposes.
“Myriad SQL is incredibly powerful; there appears to be no limits to the options for bespoke data retrieval.”
Del Owen, Fountain Timber
Click here to download SQL sales sheet PDF.SQL (Structured Query language) is a standard computer language which is used to retrieve data from within databases like that at the heart of Myriad.
Myriad SQL extends the boundaries of the system by assisting in the compilation of SQL queries. These SQL queries will interrogate data within the system, format columns, and perform mathematical calculations.
The results provide the basis for making a huge array of business decisions.
Informative
The various Myriad modules capture a vast amount of data. Much of this data can be analysed using the pre-defined tools within the system. What SQL allows is the flexibility to ask any questions of the data, in order to add more depth to the standard reports.
Each separate SQL query that is created can be saved and stored for future use. This allows exactly the same report to be run as and when required without the need to rewrite it.
SQL queries have the capacity to be incredibly advanced. Depending on the level of user knowledge and how sophisticated a query needs to be, Orcus support staff are able to write queries to meet any objective.
The only limit to what can be discovered from the data by running an SQL query is imagination.
The most common uses of an SQL query within Myriad are to discover sales patterns, cross-selling opportunities, responses to promotional activities, and patterns of stock movements.
