Data360 Analyze

 View Only
Back to discussions
Expand all | Collapse all

Data3Sixty accessing a Essbase Cube and/or SQL Server Analysis Services cube

  • 1.  Data3Sixty accessing a Essbase Cube and/or SQL Server Analysis Services cube

    Posted 11-14-2019 15:22

    Any experience pulling data from Essbase cube or SSAS cube?  I am looking into the API for Essbase right now. I saw there is a jdbc node for Essbase but I have never accessed either from any tool but I have been asked  about configuring a node to do so. Any advice would be appreciated.



  • 2.  RE: Data3Sixty accessing a Essbase Cube and/or SQL Server Analysis Services cube

    Employee
    Posted 11-18-2019 10:23

    I've not found anyone that has directly extracted data from Essbase via the APIs and imported it into Analyze. Looking online too I cannot find a current/supported JDBC driver to extract data from Essbase or other OLAP data sources. There is the Jdbc4Olap project that is on SourceForge but that has not been updated in a very long time.

    An indirect method would be to export the data as Excel files and inport those, though that has the obvious limitations on maximum data per file and the overhead of creating the Excel file exports.