Data Integration Export by EndUsers and SSO
Situation: Data Management is currently used to allow 5 dedicated endusers to export Data for their respective entity for 15 different scenarios (categories) and access the export file from process details in data management.
Users have role user and run data integration; they run a groovy rule, which uses an API connection (other web service provider) (with their username and native OCI password for the connection). Reason: normal users are only able to access the exported files, if they were generated by their username (defined by in the connection).
So far, we were very happy with the Groovy-Businessrule solution, as the timerange (months and years), the Scenario and the merge/replace setting were defined in the businessrules - we had only 5 different Groovy-Businessrules, the 5 users were able to export exactly their required datasets and were only allowed to make the relevant selections (Year, Scenario).