Current setup

Due to the limitations to access data across different databases we created a snapshot table in the production database WINFACT.FDB

The RDBMS to access the whole database is the DBeaver application. However other than with SQL-Server it is not or at least not intuitively possible to schedule the execution of a script in there. Therefore the scheduling was done with the windows task scheduler on the server directly which executes a batch file that then calls the sql file to insert any new values in the snapshot table.