Forum Discussion
Integrating Tableau to a Azure Internal Database
Hi everyone, I wanted to ask if it's possible if I can connect Tableau to an internal database that I'm planning to build. Not just Tableau but Monday.com too. And yeah, I know I need to build the database first, and sort everything out first, but it's for my presentation. I would really be grateful if someone can answer this and show me a bit of how I can do that. Do I need some token from tableau or something?
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.
4 Replies
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.
Yes, you can configure authentication (SQL credentials, Azure AD, or service principal) for Tableau, and use API tokens or OAuth for Monday.com. help.tableau.com/current/pro/desktop/en-us/examples_azure_sql_database.htm, developer.monday.com/api-reference
Awesome, thanks so much!
