Orchestrate - Add ETL tasks/steps

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.

  • Sara
  • May 8 2024
  • Attach files
  • Arthur Wirthensohn commented
    8 May 09:42am

    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.