You would have to write a views integration module to do this (expose the data) to your module. Normally I'd point you to the views 3 api documentation, but that doesn't appear to have been written yet. If you're interested in this approach you might try filing a support request asking how different the views 3 api is from the views 2 api which is documented.
You might also take a look at project forena, which is written as a more general report writing engine.
FULL DISCLOSURE: I'm the maintainer of the forena module.
________________________________
From: support-bounces@drupal.org [mailto:support-bounces@drupal.org] On Behalf Of Wipe_Out Sent: Friday, October 21, 2011 3:33 PM To: support@drupal.org Subject: [support] Accessing non-drupal tables with Views?
Hi,
I have a Drupal7 site that shares a database with another application.. I would like to use views to publish data from the applications tables to users..
Anyone have any ideas how to do this??
I have searched the internet but not found anything.. Certainly nothing for D7..
TIA