DataCleaner and MySQL

Compliancy

MySQL is a supported DataCleaner database.

Configuration

• Register the  MySQL Connector/J driver 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="MySQL database example" />
 <property name="driverClass" value="com.mysql.jdbc.Driver" />
 <property name="connectionString" value="jdbc:mysql://localhost:3306" />
 <property name="catalog" value="my_database" />
 <property name="username" value="username" />
 <property name="password" value="password" />
</bean>

Related links

• DataCleaner Features