Solution for Mondrian and Sybase ASE 12.5

[mizar_sf]

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=u serPass;Jdbc=jdbc:jtds:sybase://xxx.xxx.xxx.xxxort/dbName;JdbcDrivers=net.sourceforge.jtds.jdbc.Drive r;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).

[jhyde]

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

[jhyde]

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