This content has been marked as final.
Show 3 replies
-
1. Re: combining data sources from seperate SQL Servers
Mark Smith Nov 19, 2013 12:40 PM (in response to Christopher Parry)Maybe handle it in the datasource...server linking or openquery...
-
2. Re: combining data sources from seperate SQL Servers
Christopher Parry Nov 20, 2013 10:04 AM (in response to Mark Smith)Not really sure that’s an option at the moment.
Currently table is treating the tables as separate entities which all link into one project id table, this is making it impossible to hold all the data within one chart, and even when I split them I am unable to use common filters on the dashboard.
-
3. Re: combining data sources from seperate SQL Servers
Russell Christopher Nov 20, 2013 11:11 AM (in response to Christopher Parry)Hey Christopher -
Not sure you're going to be able to get this done in Tableau without using some sort of server linking. Since Tableau isn't an ETL tool, you'll have to rely on the database to do this work for you - which limits your capabilities to writing queries which get the job done.
So, you could:
- Write an SSIS package which dumps all the data from x tables into a single table & run it during your batch window
- Use Linked Servers / Open Query to write a SQL statement which does a UNION on each table on each server
I don't see many other options. Marks idea is probably the best.