We are investigating the External Table feature to handle some special tables outside of TX, but still be able to utilize these for down-stream TX based processing.
We would like to orchestrate the updates of these table from TimeXtender, but it seems like pre- and post execute scripts are not allowed on these tables.
Can you confirm that pre- and post scripts are not available for external tables, alternatively provide a work-around to enable these. (It seems like a strange design choice to remove these hooks for this feature).
Also, I find the schema option page grayed out on the table settings for an External table, would be nice to be able to put the generated views in some meaningful containers (not dbo).
Thanks in advance.
Best answer by Christian Hauggaard
View original
