I've connected straight to a view with no issues at all. I've run custom SQL and joins across several views as well.
What you are essentially asking for in a table is what your DBA is giving you in a view. View's are like a window to the table they are associated with. Connecting is as simple as connecting to any table in a database with Tableau. Your DBA might have to grant admin rights or some other security feature but it's all a pretty simple process. Here's a nice wiki on the subject of views: http://en.wikipedia.org/wiki/View_(database)
I should also add that I work almost entirely with views. It's great for simplifying the entire visualization build process because you get exactly what you asked for, no extraneous filtering/excluding required. Though, one downside I've come to realize is that your DBA controls the creation of the view and, if you need something changed/added/removed then its the normal rigmarole waiting for the DBA to make those changes. Those are just my thoughts on the subject. Maybe a DBA will join in and enlighten us why a view would make more sense than a table.
1 of 1 people found this helpful
I recognize this is old, but views show up under the Table heading along with tables. They are not separated, as with stored procedures. Hope this is helpful for future searchers.