We've had this discussion several times over the last decade:
However, it seems that one can leverage BRM or HCI(on PO7.5) to get around this limitation.
I found these links that indicate that BRM can act as a datastore
Has anyone built a generic data store using BRM?
PO 7.5 comes with the HCI runtime + data store.
I'm not sure if this store is exposed to PI mapping runtime/adapters.
We could build setter/getter HCI interfaces that would allow PI to access the HCI data store.
I want to check if someone has already explored these options.
If so, please share your experiences. I'd really appreciate it 😊