We use service accounts to connect Tableau to our databases that mostly reside on Netezza server. Earlier, multiple connections per datasource per workbook were allowed but after CyberArk integration with Tableau Server, we are not able to publish dashboards that have more than one connection per data source due to security issue. Only one connection per datasource is allowed. The data resides on two different databases which are on the same Netezza server. We've tried using custom SQL in Tableau which has union-ing the tables from the 2 databases and qualifying them with full names . While that works fine in Aginity (SQL client) but when we put it as a Custom SQL query in Tableau, it allows us to login to one database and throws error on tables from the other db. Cross joins is not an option either since that approach limits extract creation and some constructs and filterign within Tableau becomes limited. Any suggestions on how to resolve this issue? TY
I can't think of the correct term in Netezza, but (in Aginity) you login to database A and you can use database B in the join as well.
Then you can move the custom SQL to Netezza, and it joins the 2 databases together and there's only 1 connection in Tableau.
