Suggest an idea
Suggest an idea
What would make Nectari Software more useful to you?
11
New workflow/Data Pipeline system to have action executed following a sequence for the DataSync/Olap
datasync
Under review
November 15, 2022
It would be fantastic in the DataSync if we can have a kind of workflow or Data Pipeline to define sequences on some action.
As an example we could have :
Sequence 1 : a file is drop in a folder
Sequence 2 : a Synchronization is started and bring the data in SQL
Sequence 3 : On the completion of sequence 2, a Migration start and move from this SQL table to something else
Sequence 4 : Execute Olap 1
Sequence 5 : Execute Olap 2
etc...
3 Comments
Rakavy Ravisingam
2 years, 125 days ago
Status updated to 'Under review'
Reply
Alberta
2 years, 112 days ago
It is necessary to plan cubes refresh in a certain order, so that the update of a particular cube is not performed before the end of another, otherwise the information will be lost.
SEI allows only time scheduler and there is no possibility to take action if the update of a cube goes wrong or does not finish on time.
For example, the update of the UDM cubes must be planned in a certain order (first the UDM Dim cube, then the Staging cubes and finally all the others), but in case a cube goes into error or does not finish before the next ones are executed , there is no way to either verify or finish subsequent schedules.
The possibility of scheduling refresh of multiple cubes with a single job would be welcome.
SEI allows only time scheduler and there is no possibility to take action if the update of a cube goes wrong or does not finish on time.
For example, the update of the UDM cubes must be planned in a certain order (first the UDM Dim cube, then the Staging cubes and finally all the others), but in case a cube goes into error or does not finish before the next ones are executed , there is no way to either verify or finish subsequent schedules.
The possibility of scheduling refresh of multiple cubes with a single job would be welcome.
Reply
Guy
2 years, 112 days ago
"OLAP Manager Schedulation" (suggested by Alberta Magliano on 2022-07-14), including upvotes (1) and comments (0), was merged into this suggestion.
Reply
Thanks for your feedback