Just so we're clear, these two tables exist in different databases on different servers?
In your shoes, I'd use the functionality that's built right into SQL Server to deal with this. It'll be faster and easier.
- SQL Server allows you to "link" one server to another
- Because you can do this, it is easy to write a query / view in SQL Server that will bring both tables from different servers together like this:
SELECT tramaID, estacionID.....FROM SQLServer1.DataBaseName1.dbo.Table1
SELECT tramaID, estacionID....FROM SQLServer2.DataBaseName2.dbo.Table1
You can drop this into a SQL Server view, and then connect Tableau to the view just as if it is a table. It'll give you ALL your rows with a single connection.
Hope this helps
Thanks Russell for your answer..
All my database are in diferent Servers so if i try made a view it will not work....
1 of 1 people found this helpful
This will work, but you must "link" the SQL Servers together - essentially telling each SQL Server about the others
Take a look at this command:
thanks man ..
now time to work.. let me do the link
It works slow because i have 13 data base.. but i think i will going to use extracts..