Accessing usage and inventory data from the on-prem PostgreSQL db

piotr.wroblewski

Accessing usage and inventory data from the on-prem PostgreSQL db

Can we have the `public.consolidated0yyyy_mm_dd` usage-type tables populated on scheduled basis?

Are those tables including ALL of the PEs used across the firm? If not, can we schedule a run for all of the PEs we’re subscribed to.

What is the period covered in each consolidated usage table (e.g. 1 month, MTD, 1 day?)?

Gurpreet

Hello @piotr.wroblewski,

What product are you referring to? The realtime feeds provide streaming data which can be consumed from an API only.

piotr.wroblewski

https://community.developers.refinitiv.com/discussion/comment/123112#Comment_123112

This for the deployed infrastructure with edge, ads, and adh onsite

Gurpreet

https://community.developers.refinitiv.com/discussion/comment/123113#Comment_123113

I am not aware of any of these products using Postgres database. In general realtime streaming data does not mix well with traditional databases, due to the extremely high data update rates.

Jirapongse

@piotr.wroblewski

If this is about the Postgres database used by a DACS server, please contact the DACS support team via MyAccount.