Oracle Essbase data connection

2 posts, 0 answers
  1. Anthony
    Anthony avatar
    5 posts
    Member since:
    Aug 2016

    Posted 06 Jun 2017 Link to this post

    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

  2. Stef
    Admin
    Stef avatar
    3610 posts

    Posted 06 Jun 2017 Link to this post

    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
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
Back to Top