I’m using the latest version of TDP(32 bit) and TICand I’m trying to set up an automation that does a transform and clean step and subsequently use the results in another query.
Now from TDP I can publish the data from the T&C step as dataset on TIC but I can’t seem to be able to do that when I use that T&C element in an automation. The “export to…”. box with the Local storage and Intelligence central buttons are visible but greyed out. Funnily I see the same grey-out in the instruction video : https://www.quest.com/video/overview-of-automation-in-toad-data-point8129260/ . Is there a way to “unlock” this box for the T&C/Clean element for automations.
Alternatively, is there another way to publish the results of the T&C step as View or refreshable dataset? Exporting as .xls or .cvs does not meet my needs as I can’t use these files as tables in my queries when they’re published on TIC. As of now it seems that any cascading report that involves a transform and clean step cannot be crafted as automation that is executable from TIC.