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:

• Microsoft SQL Server
• Oracle
• IBM DB2
• MySQL
• PostgreSQL
• Apache Derby, H2, HSQLDB

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

• The database has a JDBC compliant database driver.
• The database supports SQL-92.

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:

• Quick Start wizards. A very useful facility to get your users up-and-running as quickly as possible. They function as both a shortcut to get started and as a way to learn by example.
• Contact Data enrichment and suppression. This covers functions that allow you to identify deceased people in your database or people who have moved to new addresses, subscribed to do-not-mail registries and more.
• Email and Phone correction. These two functions allow you to verify the validity of email addresses and phone numbers, and to ensure a proper formatting of these. They also provide additional information about the line-types or phone numbers, flag email addresses with common spelling mistakes and more.
• National Identifier check. A set of transformations that validate and extract information from social security numbers, company registration numbers etc.
• Exportable Data Quality KPIs/metrics. Analysis results can be exported to produce machine-readable files with Data Quality KPIs.
• An easy to use installer application that lets you decide the functions that you need without having to deal with external plugins etc.
• Pluggable security layer in DataCleaner monitor - use your LDAP or other security backend to control credentials and user roles.
• Multi-Tenancy in the DataCleaner monitor - make separate workspaces for separate teams, customers or other groupings.

For more information, see the Quadient 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.