Oracle Essbase data connection

[Anthony]

Hi team telerik - is there currently a way to connect telerik reports / report server to Oracle Essbase?

 

I require some kind of data adapter that can leverage EssBase data for reporting in our reports as we are moving away from OBI in the upcoming months; this would be a great help in our migration over to Telerik reports.  Can somebody advise or suggest a good approach to achieve this?

Thanks,

Anthony J Brown

Senior Developer

HSS

[Stef]

Hello Anthony,

Since there is not existing converter for OBI reports, my recommendation is to recreate each required report on demand and to keep both reporting solutions until you are ready to recreate all reports.

About connecting to EssBase:

1. You can create a data access layer and data model which pull and load data in standard .NET objects. Then you can consume the .NET objects via ObjectDataSource component e.g. Connecting Telerik Reporting to OData feeds(data service).
2. You can create a data access layer that gets data in CSV format. CSV content and files can be used in reports through the CsvDataSource component;
3. You can test the available .NET data providers by Oracle and the SqlDataSource component that operates with 2-dimensional data.

MDX queries are supported only through Microsoft Analysis Services.

Regards,
Stef
Progress Telerik