topic Access Databricks Delta table using SSRS without copying data to AzureSQL in Data Engineering

Access Databricks Delta table using SSRS without copying data to AzureSQL

MattM — Wed, 09 Feb 2022 09:11:01 GMT

We have our BI facts and dimensions built in as delta table in Datarbicks env and is being used for reporting by connecting PowerBI reports using datarbricks connection. We now have a need to use this data for another application utilizing SSRS reports. Is there a way to connect SSRS report to the data in the delta table without replicating the data to azure sql? We do not want to use Azure Synapse on top of it. While querying the parquet file format of the delta table might be one solution but is not the most elegant one.

Re: Access Databricks Delta table using SSRS without copying data to AzureSQL

Anonymous — Thu, 10 Feb 2022 15:36:49 GMT

Hi, @Matt M - Welcome back! I'm sure the community will respond soon. Thank you for your patience. 🙂

Re: Access Databricks Delta table using SSRS without copying data to AzureSQL

RyanD-AgCountry — Fri, 11 Feb 2022 14:20:48 GMT

I know we've been able to successfully connect Power BI Service to Databricks via the Simba Spark ODBC driver installed on a PBI Gateway server. I haven't gone into trying through our SSRS server yet. I suspect it is likely possible if network and drivers are configured correctly.

Re: Access Databricks Delta table using SSRS without copying data to AzureSQL

Chris_Grabiel — Wed, 16 Feb 2022 15:57:04 GMT

Like @Ryan Daly said, you can do this "natively" using Databricks SQL (since SSRS and other tools can "see" the SQL endpoint can communicate with it via ODBC (using the Simba Spark driver). We have integrated this way with PowerBI, SSIS, SSRS, desktop SQL IDEs, Tableau Desktop/Server, etc.

Re: Access Databricks Delta table using SSRS without copying data to AzureSQL

MattM — Wed, 16 Feb 2022 16:02:31 GMT

Thanks AgCountry FCS (Customer) and Chris Grabiel (Customer)

Re: Access Databricks Delta table using SSRS without copying data to AzureSQL

Anonymous — Wed, 16 Feb 2022 16:48:48 GMT

@Matt M - Would you be happy to mark whichever answer provided your solution as best so other members may find the solution more quickly?

Re: Access Databricks Delta table using SSRS without copying data to AzureSQL

Anonymous — Sat, 19 Mar 2022 11:18:40 GMT

https://buyusasmm.com/product/buy-google-5-star-reviews/

Re: Access Databricks Delta table using SSRS without copying data to AzureSQL

mvs — Wed, 22 Feb 2023 06:51:55 GMT

Could you please let me know how to configure the SimbaSpark ODBC driver with databricks

Re: Access Databricks Delta table using SSRS without copying data to AzureSQL

Haider93 — Fri, 11 Aug 2023 00:47:18 GMT

Hi @Chris_Grabiel , I was following the post as facing some issue while deploying the SSRS report to the desired SSRS server instance. I was able to retrieve the data in SSRS (visual studio) from data bricks using end point ODBC connector. However, when I am deploying the report to SSRS server there is error and when I check the SSRS server instance I can see that connection is unable to build. Although I have installed the same ODBC connector on server machine. I am using the connection string Dsn=eduschedargdevmanagedrgdbw01 on SSRS server. Looking forward to hearing from you soon. Cheers,