Im currently using Denodo Express to test different functionalities. One of the functionalities is exportng a CSV file about changes in the underlying databases for my base views. I created a "database changes" view in the VDP by using stored procedures in Denodo which shows me if changes have happened by running the view.
In the Scheduler Administration Tool I did the following:
Within the "Extraction section" I defined the following:
Data source: vdp
Parametereized Query: SELECT table_name, field, type, old_type, modification, depth FROM stageproject.database_change
Within the "Exporters section" I chose CSV and used the following options:
Filter sequence: None
Output file: C:\Program Files\Denodo Platform\work\scheduler\data\csv\databaseRefresher.csv
Overwrite old file: overwrite old file
Include Header ticked, and left the rest of the options default.
The job runs fine however it does not output any CSV file. I assume something is wrong with my pathing and I don't know why, I'd like to see this CSV file.
Thanks in advance!