Please Share your Product Ideas with us!

All ideas are welcome. Just because the Idea doesn't make it into the product immediately does not make it a bad idea.

Orchestrate Task Creation - Run Replication Multi-Select

When creating a task in Orchestrate, having a multi-select option for replications would be a great time-saving feature. Right now, each replication must be selected individually. If I want to schedule a refresh of a complete data source via Orchestrate, it will be a lot of searching, clicking, saving, etc... to build it.

  • Chris Dooyema
  • Jul 5 2023
  • Attach files
  • Admin
    John Munkberg commented
    6 Jul 02:57am

    Short term I think this would be nice. Be able to add 10 or 100 tasks to an orchestrate job. Or perhaps you just have a task that says "refresh all active" tables for a given Snapshot datasource. But really this feels like a feature of Cloud replication where you really just want to "schedule" SRCECC to be refreshed Friday at 5:00. There isn't really any need for a "Workflow" other than what might be created as a background background job to control and monitor the refresh of those tables. I see this more as a button in Replicate at the Source, Target, Group, or Replication level to allow a user to Schedule the refresh at that level. Orchestrate (maybe) is just the vehicle to execute and manage those tasks.

    Is there a need to construct a more complex Workflow where you Refresh 100 tables, then run a bunch of governance rules, run some SQL commands, etc. Such that you are truly constructing some complex workflow (I.e. series of tasks) in which case there is a 100 tables that need to be refreshed? I can't think of too many uses cases - but happy to discuss further.