Invantive`s free SQL Query Tool for Exact Online helps gather real-time business intelligence across the entire enterprise. You are able to access important and crucial company information easily. The data can be stored in the cloud storage space provided by the developers Exact Online. The data can be harvested by generating SQL queries on this data as you would with a local database. There is no need for additional programming, coding or downloads to Excel sheets. You simply use the SQL expertise you already have. Business data for correct decision making can be easily organized. Corporate data such as sales leads, project execution, general ledger transactions and accounts payables, etc. can easily be extracted, analyzed and executive reports generated. All you need is the query tool provided. To connect the query tool to the Exact Online cloud destination, you’ll need a username and a password.
Analysis of important facets of business can be managed easily. These can cover not only the business activities, but also regulatory requirements and monitoring of business rules. Threats and opportunities analysis becomes that much easier with the access to enterprise wide data. Connection to the database makes it possible to report based on database data as well as off database data. Reports can be shared in standard formats including PDF, SQL, CSV, Excel and XPS formats with information from Exact Online. Once you are connected with the cloud, you just need to open SQL script files from the file system or a document management system. This is a very good product.