cancel
Showing results for 
Search instead for 
Did you mean: 

SAP PI Local Data Store via BRM or HCI

HarshC
Active Participant
0 Kudos
369

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



Accepted Solutions (0)

Answers (1)

Answers (1)

HarshC
Active Participant
0 Kudos

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
Contributor
0 Kudos

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