I think you've answered your own question:
But its not supported.
Note: If the connector you want is not available from the Connect list, cross-database joins are not supported for the combination of sources that you want to join. This includes connections to cube data (e.g., Microsoft Analysis Services), some extract-only data (e.g., Google Analytics, and OData), and Tableau Server data sources. Instead of joining tables, consider using data blending. For more information, see Blend Your Data.
You need to find a way to push everything into the same extract or, make everything live as right now what you're trying to do is not supported.
Can you suggest any solution?
My Extract is connecting to Teradata which takes 45 min. to refresh and is scheduled once daily. It needs to JOIN on ID to live sql server data to filter dashboard through out day since SQL data is transactional and changing through out day.
Somebody suggested connect to TDE and do cross join with SQL server data. But I don't any way to schedule refresh of TDE unless I publish it to server.
Have you tried this:
- Create the Teradata source in tableau desktop
- Cross join it to your live data source
- Extract the Teradata source, leave the live source
- Publish to Tableau Server
Does it work?
I cannot extract teradata source and leave live connection at the same time
with cross join
Please demonstrate your exact steps with screenshots.
This is my Teradata data source which is set as an extract. How do I make
live SQL connection here and make a JOIN with extract?
*Visit our website Gupta Accountancy
<http://www.guptacpas.com/taxcenter2.php> for FREE Tax saving
information. Visit our website Gupta Accountancy
strategies for business owners.*
image.png 48.1 KB
Did you figure it out? I have a same scenario:
Need to Join Live Excel and Extract Teradata and schedule a refresh on Teradata extract while leave excel to live