Hi all
I was wondering if anybody has been able to get CMDBuild to work with Microsoft SQL server, and if so, how did you go about doing it?
I assume I need the Microsoft JDBC driver for SQL which I've put in "lib" directory but I'm not sure where to configure the connection string in the CMDBuild config files.
In doing this would I also need to manually configure the database schema or would CMDBuild automatically build this for me upon starting the Tomcat service?
Any help would be appreciated.
Cheers
Brady
Currently there is no way to use a database engine other than
PostgreSQL, and a porting to other DBMS is not scheduled.
CMDBuild
implements a custom ORM (Object-Relational Mapping) layer and uses features peculiar to PostgreSQL,
so supporting other DBMS would not be an easy task.
in particular CMDBuild allows you to specialize a class into subclasses, inheriting its attributes.
This is done using the object-oriented features of Postgres (native SQL syntax like "create table Table1 inherits Table2"), which are not present in other databases.
CMDBuild Team