How to connect to Data bricks catalog database from Azure Analysis services

Question

Hi Friends, There is no native / default connecter from AAS to connect with Azure data bricks catalogue. But is there any work around to achieve this? Please let me know. Thanks in advance.

Answer 1

Hello Lakshmi Narayana Sarma Bhamidipati, After further research, I found out that we can connect to Azure Analysis Services using the Pyodbc library:

%python import pyodbc

driver = "{ODBC Driver 17 for SQL Server}" server = "your_server.database.windows.net" database = "your_database" username = "your_username" password = "your_password" analysis_services_database = "your_analysis_services_database"

connection_string = f"DRIVER={driver};SERVER={server};DATABASE={database};UID={username};PWD={password};"

conn = pyodbc.connect(connection_string, autocommit=True) cursor = conn.cursor()

query = f"SELECT * FROM {analysis_services_database}..." cursor.execute(query)

This was discussed on the databricks community forum in the below link.

https://community.databricks.com/t5/data-engineering/connect-and-process-azure-analysis-services/td-p/41181

Please try the solution and let me know.