Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: SimbaO2X provider & Excel

  1. #1

    Default SimbaO2X provider & Excel


    I am trying to connect Excel to Mondrian using SimbaO2X provider.
    Simba was successfully installed but when I try to connect nothing happen

    when I press the "Connexion" button I get nothing


  2. #2
    Join Date
    Jun 2007

    Default Trying myself

    I will let you know - I am trying myself and have in an in with some people at Simba. I will let you know what I find.

  3. #3
    Join Date
    Sep 2009


    Have you installed the license file for simba o2x? It must be locate in the winnt/system32 folder or equivalent.

  4. #4


    Worked well for us, although I had to open up the Xmla stuff on the Pentaho platform to bypass the authentication.
    This is a signature.... everyone gets it.

    Join the Unofficial Pentaho IRC channel on freenode.
    Server: Channel: ##pentaho

    Please try and make an effort and search the wiki and forums before posting!
    Checkout the Saiku, the future of Open Source Interactive OLAP(

  5. #5
    Join Date
    Aug 2010


    One possibility for this type of issue with Excel 2003 specifically (which appears to be your version in the screenshot above) is two different versions of the MS .NET framework on your PC.
    The work around for this is described in the ".NET Framework Dependency" section of the improved User Guide just released with SimbaO2X 4.3 here:
    The new user guide has more helpful instructions on installing, on all the various Windows operating system variants, the licence key used with the SimbaO2X evaluation version. And making your first connection with different versions of Excel.
    Note also that Version 4.3 additionally handles 64-bit ODBO, and thus 64-bit Excel 2010. It is also significantly faster on queries returning large numbers of returned cells.

    Hope this helps. Sincerely,
    Russ Tront, Simba Technologies.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.