Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Solution for Mondrian and Sybase ASE 12.5

  1. #1
    Join Date
    Apr 2006
    Posts
    7

    Default Solution for Mondrian and Sybase ASE 12.5

    I tried some solutions to get mondrian (i used 2.1RC) connected with a sybase ASE server. Finally i found this solutions :
    - Downloaded a jdbc3 compliant driver like jtds-1.2.jar from sourceforge.
    - Placed the driver in TOMCAT_HOME/common/endorsed
    - In configuration files like
    mondrian/WEB-INF/datasources.xml
    mondrian/WEB-INF/web.xml
    i modified the parameters line in this way:
    Provider=mondrian;jdbcuser=userName;jdbcpassword=userPass;Jdbc=jdbc:jtds:sybase://xxx.xxx.xxx.xxxort/dbName;JdbcDrivers=net.sourceforge.jtds.jdbc.Driver;Catalog=/WEB-INF/queries/myCatalog.xml
    (The datasources.xml doesn't need to be modified if you are only testing the db, but if you are using something like OPENI you have to).

  2. #2
    Join Date
    Nov 1999
    Posts
    1,619

    Default RE: Solution for Mondrian and Sybase ASE 12

    Thanks! I added the tips to install.html. (See the latest at
    http://perforce.eigenbase.org:8080/o...c/install.html
    .)
    If you have tips for other databases, please send them to me, and I'll be glad to post them.
    Julian

  3. #3
    Join Date
    Nov 1999
    Posts
    1,619

    Default RE: Solution for Mondrian and Sybase ASE 12

    By the way, are you using Sybase IQ? IQ's column-store architecture is pretty cool, and I suspect that it Mondrian + IQ would make a great pairing.
    Is anyone else out there using Mondrian + Sybase IQ?
    Julian

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 - 2017 Pentaho Corporation. All Rights Reserved.