12-18-2023 03:24 PM - last edited on 12-21-2023 09:25 PM by JackLacava
Hi All,
We are using FdxExecuteDataUnit to export data to SQL tables for consumption by downstream systems. Is it safe to run FDX queries while consolidation/Data Loads is in progress ?
Regards
Sridhar
12-19-2023 03:04 AM
Hi Sridhar,
I assume you want to export data after it has been calculated / consolidated as otherwise your data export may not include the complete and processed data set. It seems to be more a matter of process rather than "technically" safe. Ideally this is embedded as a proper process in the workflow, or by using Task Manager.
For example like this:
Load --> Process (e.g. consolidate) --> Confirm ( Certify) --> Export
12-19-2023 10:00 AM
Hi Henning,
Thanks for the response, The audience who eventually have access to this job has no access to workflows, we just wanted to give them access via dashboard to click a button which calls Data Management job that executes FDXExecuteDataUnit and exports data to a table.
12-20-2023 02:43 AM - last edited on 12-21-2023 09:27 PM by JackLacava
Hi Sridhar,
regardless of how they get the data, they still depend on the data being available properly in my view (without knowing your process, of course).
How about instead of giving the 'audience' access to a dashboard with a button, automate this? Not sure how this data needs to be exported, but typical ways to address this are to create scheduled (overnight) jobs with task scheduler. This can be e.g. daily, weekly,...
Or you could embed it as part of the process, e.g. once a period or a certain workflow step is closed, the export file will be created.
The file can then just be pushed into a directory where your users need it.