Standard Workflows (Import > Validate > Load) can source data from any SQL table. Consider making it a Direct Load so that it skips all of the audit log and it should be pretty fast. It might be even easier to maintain than a BR depending on the complexity of the data.
Edit: SQL table with Import > Validate > Load is essentially what a good number of the register based marketplace solutions do (People Planning, Capital Planning, etc.)
Thank you! I know the example in People Planning. However, in my example, it could cause problem because import - validate - load always needs to be implemented at the very last step, because the processing bar will push all the way to the end, and completes the workflow. In my use case, user needs to save the data in the register, and then the data is supposed to go to the cube immediately. Then user need to go back and work on the register for another account, and save the data again. In other words, the work cannot be done in one saving, or it would be too much data entry in the register for one time. If I implemented the same as people planning, the workflow will be completed every time user saves data. In order to continue working on the register, user has to revert workflow to continue using register, which is very time consuming.
Thus, I am thinking of the way to push data direct to import without bothering the "import - validate- load". Hope this explains. Thank you very much db_pdx for your input.
Kai
I see now. With that iteractive cycle it makes sense why you might want to load just select cells in a rapid fashion. Sounds like Cristian's suggestion might be the way to go. Also, this sounds like a fun use case in OS!
I'll stop pushing the Import > Validate > Load after this last thought. You could always choose to separate the Import > Validate > Load from the SQL Table Editor. The table editor would live in Workflow profile or just 'Workspace' (as a dashboard) and then Import > Validate > Load would be a sibling workflow to this workspace. Your button would trigger the Import > Validate > Load harvest without needing to finalize your Workspace profile.
Good luck with the project! Cheers,
-db
Thank you Dave!
You can implement your custom import. You don't have to rely on the Automate load data process. There are a few posts here on how to automate an import/validate/load process on the forum. All you need to do is to use that code and create an event handler in PeoplePlanning for the after-saving event that will do the load. However, I do feel that it is a bit of an overhead to load data whenever the user makes a change.
