How to fetch fields from AAS data model in java?

Question

Hello there,
I am Nilesh, exploring Azure analysis service for my project.

For that,
I have created demo azure free account and able to create demo AAS and integrate it with SSMS/Excel to check the imported data model with its fields.
I have also checked few endpoints access using tokens and I am able to get response successfully with 200 code, tried with postman.

To get token: https://login.microsoftonline.com/23b103f9-76a9-4b74-9391-ae5b94842b23/oauth2/v2.0/authorize
https://login.microsoftonline.com/23b103f9-76a9-4b74-9391-ae5b94842b23/oauth2/v2.0/token

Service : POST/GET <SERVER-NAME>/models/AdventureWorks/refreshes

Now,
I need to fetch the fields from data model of AAS and its raw data using java.
Please help with providing possible ways for same so that I can check it for my project integration

Thanks,
Nilesh

Answer 1

@Nilesh Prajapati Thanks for using Microsoft Q&A !!

As discussed over here AAS does not support java natively and so you need to use .NET Core to wrap around it or you can use a custom JSON proxy wrapper that can be integrated with Java. Sample code for the wrapper is found here. You can try using the suggested methods and check if able to fetch the required information.

----------

Please do not forget to "Accept the answer" wherever the information provided helps you to help others in the community.

Answer 2

Hi @Nilesh Prajapati ,

I do not know how to do it in Java, but there is DMVs you can query to get tabular scheme. Please check:
https://learn.microsoft.com/en-us/analysis-services/instances/use-dynamic-management-views-dmvs-to-monitor-analysis-services?view=asallproducts-allversions