Is it not possible to create a view (or execute a view) that is based on a third party connection?

I have the third party database and table connections created. But there isn't a way to create a view.

I want to create a view so I can put a gadget on the desktop for users based on the information in the view.

Also when creating a gadget, it appears that the only objects that can be worked with are the primary Sage CRM default objects, not the secondary objects (which is where the 3rd party datatable resides)

Any suggestions? Thoughts?