DataCleaner and Oracle

Compliancy

Oracle is a supported DataCleaner database.

Configuration

• Register the Oracle "thin" JDBC driver in the file menu of DataCleaner-GUI.
  • You can download the driver at the  Oracle SQLJ/JDBC page.
  • Make sure to select the driver that fits with your oracle server version.
• 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="Oracle database example" />
  <property name="driverClass" value="oracle.jdbc.OracleDriver" />
  <property name="connectionString" value="jdbc:oracle:thin:@host:port/service" />
  <property name="username" value="username" />
  <property name="password" value="password" />
</bean>

Note: If you're using Oracle 8.x or earlier versions, please replace the driverClass property above with this value: oracle.jdbc.driver.OracleDriver?.

Related links

• DataCleaner Features