If you can create a sql statement which generates a table, you can connect it to Tableau.
I was under the impressions that views are also shown in the connection-dialog, but if not, a statement like this should work:
select * from VIEW
(or, better, only the columns you really need...)
You should be able to use views as well, but you need to let us know which database you are using!
Johan de Groot : Thanks for your inputs. I used the trip you provided and its still not working. This is the eror I am getting :
[MySQL][ODBC 5.3(w) Driver][mysqld-5.5.31-0ubuntu0.12.04.2-log]View '<MyDB>.<My_View_Name> references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them
eric.mcdonald, I am using MySQL as my source database.
1 of 1 people found this helpful
You need to test that your login user can see this view. You shoudl do this using your normal MySQL development tool. Login as this user and select from the view.
Yep--looks like the user doesn't have access to the DB/view
You mentioned you can view the tables. Is the view created by you (same mysql user), of by someone else?
It is probably a problem with user-rights, just like Eric and Matthew are suggesting.
Thanks all for your thoughts on this. It was an issue at my end which I resolved and all is working fine now!!!
Thanks for your time and sorry for the false alarm