SAP PI Local Data Store via BRM or HCI

[HarshC]

We've had this discussion several times over the last decade:

1. PI doesn't have a local data store that developers can leverage.
2. Value Maps are severely restricted to be a real option.
3. Developers get around this limitation via custom solutions(ZTables/RFC/Files etc).

However, it seems that one can leverage BRM or HCI(on PO7.5) to get around this limitation.

BRM:

I found these links that indicate that BRM can act as a datastore

https://ideas.sap.com/D2451

Has anyone built a generic data store using BRM?

HCI:

PO 7.5 comes with the HCI runtime + data store.

Data Store Viewer - Advanced Adapter Engine - SAP Library

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

Thanks,

Harsh

[HarshC]

Update:

In case you are looking for custom solutions. This is an excellent blog series about it.

I'm hoping that we can use BRM and HCI to avoid custom tables in the Java DB.

Also, the solution should be generic. Like the HCI Data Store.

Thanks,

Harsh

[former_member607993]

Hello Harsh Chawla

Your valuable thoughts/suggestions on this please. Many Thanks in advance!

https://answers.sap.com/questions/12882619/how-to-store-and-retrieve-oauth-tokens-in-sap-po.html