Our reports are currently running off a data warehouse. The data is accessed via JDBC. We want to move all of our data to SSAS. However, as far as I can tell JDBC does not interface with MDX, only SQL and stored procedures. How can I access my SSAS data via JDBC?
Thanks
It is not possible to access data in SSAS with JDBC directly. It is possible to set up linked server in SQL Server to SSAS, and then access that linked server through JDBC. But this is very non-optimal solution (if it will even work).
No comments:
Post a Comment