topic Re: Connect Databricks with SSAS multidimensional Project in missing-QuestionPost

Connect Databricks with SSAS multidimensional Project

Mehala — Thu, 15 Jun 2023 11:43:12 GMT

Hi,

I just wanted to connect Databricks with SSAS multidimensional Project/

want to use Databricks connection string and provider.

Is that possible to do in SSAS multidimensional Project?

Which Provider I need to use?

Or Is there any other workaround to achieve this scenario?

@Hubert Dudek ,@Werner Stinckens , @Aviral Bhardwaj , @Omkar G , @Taha Hussain , @Adam Pavlacka , @Ananth Arunachalam , @Vidula Khanna , @Jose Alfonso , @Kaniz Fatma

Re: Connect Databricks with SSAS multidimensional Project

-werners- — Thu, 15 Jun 2023 11:55:33 GMT

If I look at supported data sources for SSAS multidimensional, I do not see Databricks or ODBC/JDBC, so I'm afraid it's not possible.

Re: Connect Databricks with SSAS multidimensional Project

Mehala — Thu, 15 Jun 2023 12:00:46 GMT

But I can see ADO.NET Provider for databricks in SSAS multidimensional project, but it is not working

@Werner Stinckens

Re: Connect Databricks with SSAS multidimensional Project

-werners- — Thu, 15 Jun 2023 12:04:06 GMT

if you mean this:

https://marketplace.visualstudio.com/items?itemName=CDATASOFTWARE.DatabricksADONETProvider&ssr=false#overview

last update: 2021...

Re: Connect Databricks with SSAS multidimensional Project

Mehala — Thu, 15 Jun 2023 12:29:18 GMT

yes

Re: Connect Databricks with SSAS multidimensional Project

-werners- — Thu, 15 Jun 2023 12:44:10 GMT

since it hasnt been updated since 2021, my guess is that this will not work anymore. Databricks has made some serious changes the last years. It is very doubtful a 2yo driver will still work.

At the moment the way to go is:

use partner connect (you can use powerbi instead of SSAS of possible, works like a charm)
use ODBC/JDBC

Maybe MS themselves come up with a driver (which I doubt as they are not really investing anymore in their 'legacy' data products), or some 3th party driver (if it exists).

Re: Connect Databricks with SSAS multidimensional Project

Mehala — Thu, 15 Jun 2023 12:52:44 GMT

also I cant able to find any 3rd party driver to connect databricks with ssas multidimensional project.

Re: Connect Databricks with SSAS multidimensional Project

-werners- — Thu, 15 Jun 2023 14:11:30 GMT

I am not surprised as SSAS (multidimensional) is used less and less. Powerbi/Fabric more and more. And you will see connectors for those.

So I'm afraid you are stuck.

Re: Connect Databricks with SSAS multidimensional Project

Mehala — Thu, 15 Jun 2023 14:16:27 GMT

yeah may be, any other workaround?

Re: Connect Databricks with SSAS multidimensional Project

-werners- — Thu, 15 Jun 2023 14:36:25 GMT

you could write the data processed by Databricks into a datasource supported by SSAS multidimensional. Not optimal but at least you can reach the data.

Or stop using SSAS 🙂

Re: Connect Databricks with SSAS multidimensional Project

Anonymous — Fri, 16 Jun 2023 03:32:51 GMT

Hi @Mehala M

We haven't heard from you since the last response from @Werner Stinckens , and I was checking back to see if her suggestions helped you.

Or else, If you have any solution, please share it with the community, as it can be helpful to others.

Also, Please don't forget to click on the "Select As Best" button whenever the information provided helps resolve your question.

Re: Connect Databricks with SSAS multidimensional Project

Mehala — Fri, 16 Jun 2023 04:29:50 GMT

As per the requirement, I need to use databricks in ssas multidimensional project, i don't have any other option

@Werner Stinckens , @Vidula Khanna

Re: Connect Databricks with SSAS multidimensional Project

-werners- — Fri, 16 Jun 2023 14:09:21 GMT

I mentioned it before:

move the output of the databricks notebook to a SSAS supported datasource.

F.e. an on-prem MS SQL Server.

You can do this with Azure Data Factory f.e.