Our Help desk need real time data from the database to support their business. I heard from NewScale that, data was encrypted and it is not accessible from Database. Is there a way we can get the real time data in Request Center? If not, how do you guys publish real time metrics in Request Center?
Yes, there are some metrics available in reporting. But it is not real time. Since ETL is taking more time we can not run every 15 min. So the customer wants real time data every15 min to publish their reports. We are ok to provide the database access, but this is not help since data was encrypted.
To answer your second question. "How do you publish real time metrics in RequestCenter?"
We do that through KPIs. KPIs are accessible from the dashboard tab of Reporting module. These can be configured to be real-time.
Here is the description of KPI from the online help.
"Key Performance Indicators (KPIs) are pre-defined, best practice metrics that help you monitor and manage service reliability, effectiveness, and efficiency. KPI reports can be run, saved and printed from
You could potentially query or run reports against the transactional db as well. The views that the ETL jobs use are exposed there. That could of course potentially impact performance to the production transactional database though.