Hi Amit,
we did a successfull test connecting the Tableau directly in the DW database. In this fashion we can define Tableau's models based on the DW schema. You also can use custom queries to "pre processing" the DW schema e generate custom data source on Tableau.
Att.