Greentree SQL & Query Tools

A host of inbuilt reporting and analysis tools with open access for other reporting systems, such as Microsoft Reporting Services.

Greentree SQL offers a number of methods to support open access from ODBC through to populating a data warehouse in Microsoft® SQL Server in real-time.

This allows customers to centralise data from not only their Greentree software but also from other associated systems into a single SQL Server repository.

  • Pre-built maps – Populate Microsoft® SQL Server using Greentree data maps.
  • Mapping Wizard – Use Jade’s Relational Population Service (RPS) to map Greentree data to a SQL table structure.


Greentree Explorer is designed as a non technical query builder that allows you to build flexible searches, save these for future use, and retrieve and drill down into the data matching the query. This information can be launched in Microsoft Office Excel. Using the built in wizard, queries can also generate Greentree reports for future reuse or modification in the Report Designer.


Inspector is specifically designed to aid the more technical user in examining Greentree’s database and analysing information down to the lowest levels per item or transaction and includes capabilities for defining queries to pinpoint the required data for analysis.

Download SQL & Query Tools Brochure