Thank you everyone. I know that here I am trying to let "Import" do something it is not designed to do. The business case here is that I have data store in SQL editor component. Ideally, data here will be pushed from SQL Editor to the Origin "Import" because I would like to leave Origin "Form" as another way for user to input manually. An alternative is to use another dimension such as UD, but I would not want to create a new member if not 100% necessary.
Kai
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.)
