CODEWITHSUNDEEP
tableau-api
Prashant Jha
Prashant Jha

Reputation: 33

Connecting two different database in Tableau

I want to connect two database and establish a relationship between them in tableau. One from sql sever and another from Microsoft excel sheet. How to do that?

I have goggled a lot for that but could not get a suitable answer.

Upvotes: 2

Views: 2099

Answers (2)

Bryan
Bryan

Reputation: 3451

You are speaking about Data Blending -

And for connecting cross database data

Cross Database Querying is a Flagship Upgrade to Tableau 10.0

enter image description here

However, you cannot use cross-database joins with these below connection types:

Tableau Server
Firebird
Google Analytics
Microsoft Analysis Services
Microsoft PowerPivot
Odata
Oracle Essbase
Salesforce
SAP BW
Splunk
Teradata OLAP Connector

enter image description here

Upvotes: 2

user4628965
user4628965

Reputation: 21

You just need to connect to each database separately and make sure they have the same column names. When creating a sheet when you switch between datasources you will see a chain on the linked fields.

Do note that this is not properly joined but is just blended data, it would be best to create another table in your sql database for the excel sheet.

Upvotes: 0

Related Questions