CODEWITHSUNDEEP
azureasp.net-coreazure-data-factoryazure-data-lakeazure-analysis-services
Kzryzstof
Kzryzstof

Reputation: 8382

How can I query data in an Azure Analysis Service from a ASP.NET Core application?

I have an cloud application that dumps all its data into an Azure Data Lake.

Using Azure Data Factory, I have built a pipeline that extracts and transforms the data from the lake and saves it in local .csv files.

These .csv files are accessible in an Azure SQL Data Warehouse as external files that are CTAS as proper SQL tables.

I have created an Azure Analysis Service instance that is hooked up to the warehouse, provides additionnal information out of the existing data and caches it.

Question

I want to make this data available from a Web API. I have created a ASP.NET Core application and I would like this application to connect the service to query the data.

Knowing that the client libraries (ADOMD) are all .NET Framework libraries that can't loaded in a .NET Core app, how should I do this?

Upvotes: 0

Views: 1557

Answers (3)

GregGalloway
GregGalloway

Reputation: 11625

There is now an official version of ADOMD.NET for .NET Core available. See another answer here for details.

Upvotes: 1

Benjamin
Benjamin

Reputation: 137

I tried the "Unofficial.Microsoft.AnalysisServices.AdomdClient" for getting data out of the cube via REST Api. It worked really well and the response time is great. I am just not confident that more advanced stuf (partition management. . .) will work with this package, since it does not seem to be developed regularly.

Upvotes: 0

Mohit Verma
Mohit Verma

Reputation: 5294

There are no official .NET Core-compatible ADOMD.NET yet:

https://github.com/dotnet/corefx/issues/20809

https://feedback.azure.com/forums/908035-sql-server/suggestions/35508349-adomd-core

You can try this unofficial port of "Microsoft.AnalysisServices.AdomdClient".

If your hosting environment is windows, you can create simple .NET Framework-based microservice that handles requests to SSAS from your main ASP.NET Core app

Upvotes: 1

Related Questions