Microsoft SQL Server

A distinct database schema is required.

Follow the same steps as for creating the ConSol CM database (see section Microsoft SQL Server). Use as database name cmrfdatabase and user cmrf.

No additional setting is necessary.

Special notes for Microsoft SQL Server

It is necessary to grant the DWH user database access to database medium master (role public and role SqlJDBCXAUser).

For the data transfer with the DWH the option responseBuffering=full must be added to the JDBC connection. Add this option to the end of the JDBC URL in the file cmDb-ds.xml. It should like as follows (replace the URL and the database name in red with your configuration):

jdbc:sqlserver://localhost:1433;SelectMethod=cursor;databaseName=cmdatabase;responseBuffering=full;