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

piotr.wroblewski · 2024-12-02T10:53:10+00:00

There was an error rendering this rich post.

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?)?

Find more posts tagged with

sql

refinitiv-realtime

Accepted answers

All comments

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

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

Gurpreet

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.

EXPLORE OUR SITES