Hallo Denodo Team,
Our customer requires that we schedule Denodo Jobs (VDPCache) using an external tool (IBM TWS). I understand, from the documentation and the knowledge base (where I found a question about Tidal) that in order to do this we should open a JDBC connection to Denodo and have Denodo execute a VQL query for each cached view. Is this the only way? Wouldn't it be possible to create a Job within vdpadmin (or the scheduler administration tool) and launch it from outside with a command line?
Perhaps using Stored Procedures in conjunction with a JMS Listener?
Thank for your attention