when creating a task in Orchestrate there is no possibility to add ETL tasks.
Currently I'm in need to create a weekly process where first we run SRCECC (full)-this was also requested in other ideas - and sequentially run ETL tasks.
I'd see that as baseline functionality to automate transformation - and control dependencies (results from one ETL job needed for another one).
Rebuilding ETL sequence by adding all SQL task might be a technical workaround but very cumbersome, error prone and some changes to the ETL job would need to be applied manually to the SQL task sequence...not really something we should do.
I'd see that as baseline functionality to automate transformation - and control dependencies (results from one ETL job needed for another one).
Rebuilding ETL sequence by adding all SQL task might be a technical workaround but very cumbersome, error prone and some changes to the ETL job would need to be applied manually to the SQL task sequence...not really something we should do.