Real time data in dashboard

Real time data in dashboard

Hello.

I would like to trace and display real time events.

I will have a datamart (SQL) and I would like to acquire data in near real time from my SQL datamart. The best I can do in term of time interval is with every 'N' minutes where the lowest N is 15 minutes. It's far to long !

Is there any workaround to shorten this time ? editing a CRON ? Or something else ?

Regards