By design, the Query Tool is designed not to run from the command line, since it is a GUI application. There are various alternatives for unattended processing using a time-based schedule or another schedule:
- Invantive Data Hub/Data Replicator
- Invantive Bridge Online with Bridge Online Consumer
- Invantive Bridge Online with Microsoft Integration Services
Invantive Data Hub and/or Invantive Data Replicator
Most users that load data into a local SQL Server database use Invantive Data Hub or the enterprise-variant Invantive Data Replicator. Invantive Data Hub connects to all sources and targets at the same time and using existing Invantive SQL-statement the data is streamed in a highly parallel fashion from sources to targets. A sample of a SQL-query to insert data in a new table is:
create or replace table targettable@sqlserver
as
select *
from exactonlinerest..ItemsIncremental@eol
An example can be found on Copy Exact Online to SQL Server.
The Invantive Data Hub and Invantive Data Replicator products require a separate license, with similar costs for similar volumes. Invantive Query Tool comes bundled with Data Hub and Data Replicator.
Invantive Bridge Online with Bridge Online Consumer
For programmers, the use of the OData4 connector Invantive Bridge Online may provide a simple way to exchange data from a local server. People have managed to use Google Functions, Azure Functions, Python and C# to download data from Exact Online through the Invantive Cloud into their local SQL Server instances. Sample code and executable can be found on:
Invantive Bridge Online is available with almost all Invantive subscriptions.
Note that it is also possible to use Invantive Cloud as a proxy for Invantive Data Hub as described on Store Exact Online data in an on-premise SQL Server through Invantive Cloud.
Invantive Bridge Online with Microsoft Integration Services
It is also possible to consume Invantive Bridge Online from the OData4 consumer of Microsoft Integration Services running on-premises. There is no guide specifically for Microsoft IS, but it highly resembles the staps for Azure Data Factory shown on Hoe verbind ik Exact Online met Azure Data Factory? (Dutch) or Connect Azure Data Factory to Exact Online, 180 days free.