Do the users REALLY need realtime data ? (as in "up to the second") ... most businesses are "OK" with refreshes every 1 or 4 or 12 hours.
If they really want up to the second data, how many new records are created per minute ?
Would it be easy to have the old data in a certain place (extract ?) and the new data in a live connection .... again, this depends on your dashboard design and what you're really trying to do.