PALO XMLA is an Palo Enterprise feature? Saiku AnalyticWebFrondend (Pentaho) connection to PaloOLAP-Server

    PALO XMLA is an Palo Enterprise feature? Saiku AnalyticWebFrondend (Pentaho) connection to PaloOLAP-Server

    Hello everyone,

    there is a very nice OpenSource-Tool for OLAP-Webanalytics (Pentaho-family) called: Saiku (analytical-labs.com/)
    I tried it on Linux and MacOS. Its an easy download and run like Palo. (Demo: demo.analytical-labs.com)

    It has an simple ConfigFile for DataSource-Connections
    here: .../saiku-server/tomcat/webapps/saiku/WEB-INF/classes/saiku-datasources/README

    Per Default for Palo it sais: (HELP: docs.analytical-labs.com/DataSources.html)
    # XML/A (PALO)
    # ----------------------------------------------
    # type=OLAP
    # name=xmla
    # driver=org.olap4j.driver.xmla.XmlaOlap4jDriver
    # location=jdbc:xmla:Server=http://localhost:4242/
    # username=joe
    # password=password

    For Me this means:
    type=OLAP
    name= OffenerHaushalt
    driver=org.olap4j.driver.xmla.XmlaOlap4jDriver
    location=jdbc:xmla:Server=http://192.168.0.61:7777
    username=admin
    password=admin

    But it does not work.
    It sais: "Loading datasources..." for 60sec after login into Saiku, but with no result
    The cube-sections stays empty...

    It sais in Logfile: "catalina.out"
    • java.lang.RuntimeException: org.olap4j.OlapException: error discovering metadata
    • Caused by: org.olap4j.OlapException: error discovering metadata
    • Caused by: java.net.SocketException: Unexpected end of file from server
    Anyone is experienced here, and able to give a quick reply?
    1.) Port 4242 seems to be an old Port it is now 7777, right?
    2.) I also tried 192.168.0.61:7777/xmla with no success
    3.) I also added: "Properties: Catalog = OffenerHaushalt"

    As here are no mistakes, I found here, that PALO XMLA is an Palo Enterprise feature???
    forums.pentaho.com/showthread.…ction&p=237563#post237563

    I just found a new JavaAPI Release (17 Jan 2013) of olap4j.org, does this help?
    Or maybe the JPalo Tool? (Palo Java API jpalo.com/en/palo_java_api.html)

    I am not shure how to go on here. It seems so simple, but maybe only with PALO XMLA as an Palo Enterprise feature...

    Thanks for any advice
    Cheers
    Hi Gretto,

    XMLA daemon is part(and was always) of a premium "Third 3rd party connectivity" package. You can download current premium version from jedox.com and test it for 30 days free of charge. Make sure you select Advanced Setup, then later Jedox 3rd Party Access (ODBO/XMLA). Port 4242 is default value for XMLA daemon (can be changed during setup).
    Mit freundlichen Gruessen/ With kind Regards / Meilleures salutations

    Vladislav Malicevic
    VP Development & Support
    Jedox AG