Hi Ben -
Tableau has the ability to connect directly to your data source (acting as client-server interface you mention). It can also create and use a local, in-memory store with incredibly fast response time against your data.
You can "mix and match" these modes, too. Pretty cool stuff.
More information can be found here: