This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I am researching on tools and the information that could enable me to establish a connection with Essbase cubes from within Alteryx. Does anybody have any experience to share or guidance to provide around the approaches that I could take to try and establish connections to Essbase from Alteryx.
I have done some reading so far on the tools that Alteryx provides for such use cases and some reading on the capabilities that Essbase has to enable integration with 3rd party apps.
Essbase provides JAVA APIs for 3rd party apps integration. However, based on my email exchanges with Alteryx Customer Support Team, it seems that those JAVA APIs cannot be consumed directly by Alteryx since some custom API development is needed before Alteryx can consumer those and connect to Essbase. I am currently looking at Essbase Webservices to see if those could be used by Alteryx for connecting with Essbase.
Please provide your thoughts on how to go about this use case and the approaches that I can take to address this requirement.
I didn't pursue this project and hence don't have any suggestions for you. In case you haven't looked at all the replies to this thread, there are few suggestions from one of the Alteryx Community members that might be worth a try.
The Finance function across most organizations are Essbase users and also rely heavily on Alteryx for it's data handling capabilities. I think it would serve the interests of the broader Finance community if Alteryx were to start offering some native capabilities to connect to Essbase instead of the current custom development approach. In case, if others also share the same thoughts, it would be worthwhile to highlight this pressing need to the Alteryx Designer Product Management team.
I have started with suggestion 2 from @MichaelCh, however I use Oracle PBCS (cloud version of hyperion), I am pretty sure Oracle PBCS leverages Essbase but I have no idea if I can connect it to with a Python tool using https://github.com/jasonwjones/essbasepy
So I wanted to see if you had got it to work before spending/wasteing too much time on it.