Frequently Asked Questions (FAQ)

1. Interoperability and Connectivity

1.1. Can DataCleaner interact with more than one data source (database, file, etc.)?

Yes. Usually a job in DataCleaner has just one source but it can incorporate other sources (e.g. via a 'Table Lookup' or by using a 'Composite datastore') or other destinations (e.g. via 'Insert into Table' or similar components).

1.2. Can I use DataCleaner with [my relational database brand]?

Our database connectivity layer is based on Apache MetaModel. This means that a lot of data sources are supported. We specifically test these brands:

Furthermore the layer is designed so that if the following two criteria are met, we generally support your database:

Even if these requirements are not fully met, we encourage you to try it out. The connectivity layer is quite flexible and tolerant towards minor issues in e.g. the driver's JDBC compliancy or minor SQL-92 incompatibilities.

1.3. Does DataCleaner run in virtualized environments (such as VMware)?

Yes. Our only requirement is that Java 7 or later is installed.

1.4 Which Operating Systems does DataCleaner run on?

We ensure that DataCleaner is working on Windows, Linux and Mac OS X. Furthermore any Operating System with full Java support should work.

Note that we have a few tips for installing on Mac OS X.

2. Commercial Editions

2.1. What are the functional differences between community and commercial editions?

There are multiple functional differences. Here are the primary ones:

For more information, see the DataCleaner product page.

2.2. Why should I buy a commercial edition of DataCleaner?

If you're using DataCleaner for commercial reasons then it's really the only right thing to do. The commercial editions are quality assured and tested in a more mature way. With the commercial editions you get more functionality and a support organization that will help you if there should be any troubles.

2.3. Can I get support for the Community Edition?

No, when using the Community Edition you have to rely on the community for help. This often works, but you need more patience and you cannot hold anyone accountable for fixing your issues.