06-25-2021 08:29 AM
06-25-2021 08:30 AM
Found this ...
Azure Databricks to Microstrategy JDBC/ODBC Setup Tips
Purpose
This is a quick reference for common Microstrategy configuration tips, tricks, and common pitfalls when setting up a connection to Databricks:
Networking
For Azure, we recommend engaging with your relevant Azure SA overlay resource as there are common Azure networking configurations that might be getting in the way.
Common things to consider:
Chances are there might be networking configs that need to get established to enable said connectivity from MSTR to the control plane’s ODBC/JDBC endpoint.
Setup
Once that’s set and connectivity has been confirmed (e.g. by pinging the Databricks endpoint):
Spark Server Type: SparkThriftServer
Host: demo.cloud.databricks.com (no http/s here)
Port: 443
Database: default
Mechanism: User Name and Password
User Name: token
Password: your-PAT-here
Thrift Transport: HTTP
Hit HTTP Options button, HTTP Path: /sql/protocolv1/o/0/your-cluster-name
Hit SSL Options: Enable SSL (ON)
Other tips
06-25-2021 08:30 AM
Found this ...
Azure Databricks to Microstrategy JDBC/ODBC Setup Tips
Purpose
This is a quick reference for common Microstrategy configuration tips, tricks, and common pitfalls when setting up a connection to Databricks:
Networking
For Azure, we recommend engaging with your relevant Azure SA overlay resource as there are common Azure networking configurations that might be getting in the way.
Common things to consider:
Chances are there might be networking configs that need to get established to enable said connectivity from MSTR to the control plane’s ODBC/JDBC endpoint.
Setup
Once that’s set and connectivity has been confirmed (e.g. by pinging the Databricks endpoint):
Spark Server Type: SparkThriftServer
Host: demo.cloud.databricks.com (no http/s here)
Port: 443
Database: default
Mechanism: User Name and Password
User Name: token
Password: your-PAT-here
Thrift Transport: HTTP
Hit HTTP Options button, HTTP Path: /sql/protocolv1/o/0/your-cluster-name
Hit SSL Options: Enable SSL (ON)
Other tips
Join our fast-growing data practitioner and expert community of 80K+ members, ready to discover, help and collaborate together while making meaningful connections.
Click here to register and join today!
Engage in exciting technical discussions, join a group with your peers and meet our Featured Members.