We are rewriting a .NET application with MDX, Microsoft.AnalysisServices.AdomdClient. In Java it is not easy to connect to Microsoft SQL Server Analysis Services, SSAS. We have 5 big MDX queries. Maybe to use this, as I understand, in this case XML/A HTTP access for SQL Server Analysis should be configured correctly. But it is not configured yet. Could you please advise what case is appropriate:
- JDBC + rewrite MDX to SQL
- olap4j + configure XML/A HTTP access for SQL Server Analysis
- or any other good way
And how about performance?