I’m considering using Metabase and my organization is pretty tied into Azure. Curious to hear if there are people using Metabase predominantly with Azure services and if there are any nuances to keep an eye on.
At first glance, running Metabase from a Docker image seems like it would make the most sense and
we would be connecting to an Azure SQL Server. Would be really cool if we could connect to Data Lakes and Data Warehouses though.
You should be able to connect without any problems to Azure SQL Server - the past two years, Metabase has been using the Microsoft JDBC driver, which is compatible with Azure too.
As for “Data Lake” and “Data Warehouse”, I’m not sure what type of connection they use.
Metabase currently “only” has about 15 drivers, so if those cannot connect, then you’re at a loss.
Has anyone managed to connect to Azure SQL? I’ve had a lot of trouble and just wondering if its possible. If so, can you post a screenshot of the configuration? I just get timeout errors no matter how I try to configure the Additional JDBC connection string options
Figured it out! My issue was: you have to manually enter the port number, "1433". Leaving the default does not connect to Azure SQL. Other settings here:
@briandouglasbdc Great that you found a solution. When leaving the field Port empty, then it allows use of Dynamic Ports on SQL Server, but I don’t think Azure SQL has that option, so you need to define a port in that case.