I have created a data-loader script and saved as an idl-file.
Can I start this script with a command from a scrript in the Query tool?
No, there is currently no way to directly execute an IDL-file of Invantive Data Loader in the Invantive Query Tool or Invantive Data Hub.
As an alternative, a framework like:
bulk insert into <TARGETTABLE>
select ...
from <SOURCETABLE>
can be used.
There are currently no plans to add this functionality, since most users directly code their data loads in the Query Tool using synchronize
, create or replace table
and/or bulk insert
.