Showing entries 1 to 1
Displaying posts with tag: mondrian jdbc dialect compatibility contributions (reset)
Adding support for a new database to mondrian

Mondrian supports a large number of back-end databases. So many in fact, that we rely on contributors to add the support, and we have tried to standardize the steps to support a new database.

I thought it might be worthwhile to reiterate those steps. The steps are:

1. Write a dialect class. The dialect must implement the Dialect interface, and will probably be a subclass of JdbcDialectImpl. The only prerequisites are that your database has a JDBC driver and supports SQL-92: SELECT .. FROM .. JOIN .. GROUP BY. Mondrian will glean as much information as it can, such as how your database quotes identifiers that contain mixed-case or spaces, from the JDBC driver. But you will need to override methods to provide information that the …

[Read more]
Showing entries 1 to 1