I am trying to get Pentaho to work with SQL Server storing the 'hibernate' and 'quartz' tables. The problem is that there are no .sql files for SQL Server in the /biserver-ce/data directory and that there is no sqlserver.hbm.xml mapping file in the pentaho-bi-platform-repository-3.0.0-STABLE.jar.

For the first problem, I can probably write new .sql scripts to create those parts of the databases as needed. For the second problem I do not know how to make a .hbm.xml file that would work with SQL Server. I tried using some of the existing files with no luck - the first problem being the size defined for the "data" varbinary column for example.

Has anyone created the .sql files and the .hbm.xml mapping file to work with SQL Server?