I want to bring data from multiple data source in my tableau.
- DS webconnector 1 Table 1 1,table 2
- DS webconnector 2 table 1 ( this has the key to connect to table 2 above DS webconnector 1) and table 2
- DS webconnector 3 table 1 ( this has the key to connect to table 2 above DS webconnector 1) and table 2
- SQLStudio Table 1 )this has the key to connect to table 2 above DS webconnector 1) and Table 2
How can a connect all of them and then build a cross tab?
So I want to connect Jira Story ticketNumber to Link1+Linktype = Link1 +LinkType to Links. Then from there i want to connect Links on link1 = Ticket Number in Jira UAT.
I want to connect Jira Story ticketNumber to Link2+Linktype = Link2+LinkType to Links. Then from there i want to connect Links on link2 = Ticket Number in Jira Dev.
I want to now connect Jira Story with MSSQL on Ticket Number = Ticket Number.
Then build a dashbaord using all the data from these four sources.
Can some one guide me.
Thanks.
Hi @Sunita Dilwali ,
Unfortunately a WDC isn't that 'intelligent' to create multiple tables which can be joined inside of Tableau.
My suggestion is to create a script (e.g. Python) which fetches all the data and puts it into a database, so Tableau can connect to these tables.
A different option (more like a WDC) is using Table Table Extensions - if you want more 'live' data.
Kind regards,
Johan de Groot
