DataCleaner and Microsoft SQL Server

Compliancy

 Microsoft SQL Server is a supported DataCleaner database. DataCleaner has been tested on SQL Server 2005.

Configuration

• Register sqljdbc.jar extracted from  Microsoft SQL Server 2005 JDBC Driver 1.2 in the file menu of DataCleaner-GUI.
• Edit the datacleaner-config.xml configuration file and insert this bean definition (replace the values with your own connection information):

<bean class="dk.eobjects.datacleaner.gui.model.NamedConnection">
	<property name="name" value="MSSQL Database example" />
	<property name="driverClass" value="com.microsoft.sqlserver.jdbc.SQLServerDriver" />
	<property name="connectionString" value="jdbc:sqlserver://localhost:3341;databaseName=my_database" />
</bean>

Note: To use your Windows credentials for authentication against a MS SQL database, you need to also extract sqljdbc_auth.dll and add the following to the datacleaner.cmd:

-cp <driver location>\sqljdbc_auth.dll -Djava.library.path=<driver location>

and add integratedSecurity=true to the connection string, like this:

<bean class="dk.eobjects.datacleaner.gui.model.NamedConnection">
	<property name="name" value="MSSQL Database example" />
	<property name="driverClass" value="com.microsoft.sqlserver.jdbc.SQLServerDriver" />
	<property name="connectionString" value="jdbc:sqlserver://localhost:3341;databaseName=my_database;integratedSecurity=true" />
</bean>

Related links

• DataCleaner Features