Connect Databricks with SSAS multidimensional Project

[Mehala]

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​ 

[-werners-]

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.

[Mehala]

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

@Werner Stinckens​ 

[-werners-]

if you mean this:

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

last update: 2021...

[Mehala]

yes

[-werners-]

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).

[Mehala]

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

[-werners-]

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.

[Mehala]

yeah may be, any other workaround?

[-werners-]

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 🙂

[Anonymous]

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.

[Mehala · Accepted solution]

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

@Werner Stinckens​ , @Vidula Khanna​ 

[-werners-]

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.