Forum Discussion
Integrating Tableau to a Azure Internal Database
Yes, it is possible, but the exact design depends on whether the database is meant to be private inside Azure or reachable from the internet. Tableau can connect directly to Azure SQL or another supported database when networking, authentication, and firewall rules allow it. If the database is private, you normally use a private endpoint plus Tableau Bridge, a gateway, or another component that has network access to the database.
Monday.com is a little different because it usually integrates through APIs rather than direct database access. I would avoid giving SaaS tools direct access to the database unless you really need that. A cleaner presentation architecture is Azure SQL for the data, a small API or integration layer in front of it, and then Tableau or Monday.com connecting through the supported connector path.
Yes, it is possible, but the exact design depends on whether the database is meant to be private inside Azure or reachable from the internet. Tableau can connect directly to Azure SQL or another supported database when networking, authentication, and firewall rules allow it. If the database is private, you normally use a private endpoint plus Tableau Bridge, a gateway, or another component that has network access to the database.
Monday.com is a little different because it usually integrates through APIs rather than direct database access. I would avoid giving SaaS tools direct access to the database unless you really need that. A cleaner presentation architecture is Azure SQL for the data, a small API or integration layer in front of it, and then Tableau or Monday.com connecting through the supported connector path.
Oh! That's very helpful, thank you! That was what was on my mind before, and I've been trying to suggest that they not be too reliant on Monday.com, but it's the platform that they find the most comfortable with. Although I'm still going to build something for them and show them how it works, I think Monday.com would be great to use with outsiders, whilst the internal database should only be accessed by the team.
