Connect to a Database without Specifying a Table [Video]

Posted by on Nov 26, 2012

Do you find it slightly frustrating in Tableau when connecting to your database that you must specify a table? What if your server address is ‘AGST-11DS.eu11-amazonsomethingorother.aws.com’, are you really going to type that out every single time you want to create a new connection? You could have a little text file on your desktop acting as your database directory from where you copy the address from before pasting it into Tableau. But that’s not very Tableau is it? That’s not putting you connection right at your fingertips.

Thankfully with a little easy xml editing you can create your own tds file which takes you to your database but stops short of connecting to a table. And here’s how:

Easy right? Don’t have SQL? Give it a try with any of Tableau’s connection types and post a comment of how you got on.

Craig Bloodworth

CTO
Tableau Zen Master 2012 - 2014

Latest posts by Craig Bloodworth (see all)

2 Comments

  1. Nice share, Zen Master! One thing I add in some of my training – IF you have multiple databases on a single Server, you can keep copying the updated .tds file, changing only the ‘formatted-name=’ and ‘dbname=’ variables, to create a series of datasources, quickly. Hmmmm… Thinking next step might be a batch file – Server as parameter, to do them all.

  2. Great tip Craig. Thanks so much for sharing it. That’s a real time saver!

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>