den 2017-08-15 17:20, skrev Mark Rotteveel mark@... [firebird-support]:

 

On 15-8-2017 15:36, Kjell Rilbe kjell.rilbe@...
[firebird-support] wrote:

> We're in need of a tool where we can author sequences of SQL queries
> against FB and non-DB commands like file operations etc. I'd like to
> call them "batch runs" to perform recurring tasks.


Sounds like you are looking for an ETL (Extract Transform Load) tool

In the past I have used Pentaho DI (also known as Kettle)
(http://www.pentaho.com/ and http://community.pentaho.com/) for
combining data from various sources. Note that there is an open-source -
free - community-edition, but it looks like they are progressively
moving to a walled-garden for support/information (or at least, making
it harder to find); see
http://wiki.pentaho.com/display/EAI/Latest+Pentaho+Data+Integration+%28aka+Kettle%29+Documentation
for documentation

It has a variety of tools: Spoon, a GUI to design a transformation or
job, and Pan (transformations) or Kitchen (jobs) to execute them from
the command line.

Thanks! I found that one yesterday but didn't have time to dig in thoroughly.

Anyone know if iCore might fit the bill?

https://www.icoresolutions.com/

Note: I can always create my own special tools to perform any operations not supporte by the batch run tool itself or by existing command line tools or commands. So, what I'm primarily looking for is a tool in which I can easily create scripts/lists of things to do, triggers/events, pre- and post conditions, logging and notifications to me or someone else.

Regards,
Kjell