Apex Code Development You need to sign in to do that
Don't have an account?
Persistent Sys Get data from MS SQL server 2005 cube using MDX queries
Hello Experts,
Is it possible to issue MS SQL server MDX queries or thro' SSRS (Reposrting services) web services from within apex controllers, get data from back-end and show it in VF UI.
If yes, any benchmarks on performance bottlenecks?
If no, what is the best way to push cube data from SQL server to SF objects? Do we need to write a .NET component which reads data from MDX queries and write back using Force.com WS API.
Any examples/code snippets/pointers would be of great help.
Thanks.
Is it possible to issue MS SQL server MDX queries or thro' SSRS (Reposrting services) web services from within apex controllers, get data from back-end and show it in VF UI.
If yes, any benchmarks on performance bottlenecks?
If no, what is the best way to push cube data from SQL server to SF objects? Do we need to write a .NET component which reads data from MDX queries and write back using Force.com WS API.
Any examples/code snippets/pointers would be of great help.
Thanks.