Forum Stats

  • 3,838,631 Users
  • 2,262,385 Discussions
  • 7,900,715 Comments

Discussions

Querying OLAP cubes Oracle from ASP.NET MVC

3809176
3809176 Member Posts: 4
edited Oct 15, 2018 9:48AM in OLAP

Hi,

we have an asp.net mvc web site with sql server database.

We need to query some OLAP cubes Oracle with millions of records for create ad-hoc reports.

What is the best way for make report at runtime without stress the web server?

Is it possible do OLAP queries via Oracle Developer Tools for Visual Studio and Oracle Data Provider for .NET?

What performance recommendations you suggest to me?

Thanks in advance

Answers