The SQL Query Tool offers free access to Exact Online administrations and allows for direct querying of company information, including general ledger transactions. Results can be reported in various formats such as PDF, SQL, CSV, Excel and XPS.

With the Invantive Query Tool, you can extract, analyze and report business data, such as sales leads, project execution, general ledger transactions, and accounts payables. This software allows you to optimize your Business Intelligence with Exact Online, enabling you to make the right business decisions based on solid data.
The Invantive Query Tool offers all the functionalities required to turn your business data into real-time intelligence. It enables you to automatically analyze your business activities, compliance and business rules, uncovering threats and opportunities that you might otherwise miss. You can connect in real-time to Exact Online corporate data for both on and off database reporting, and share your reports in PDF, SQL, CSV, Excel and XPS formats.
The best part is that the Invantive Query Tool directly connects to Exact Online, so there's no need for programming, coding or Excel downloads. You can also open SQL scripts from the file system or a document management system.
The Invantive Query Tool supports a range of platforms. Before you start using it, please consult the minimum system requirements for full details.
Version 2016R1: N/A