data_quality_tools.htm

<HTML><HEAD><TITLE>Data Quality Tools</TITLE>
<link rel="stylesheet" href="styles/style.css">
</HEAD> 

<BODY BGCOLOuuR="#98CEFD" TEXT="#202020">

<TABLE border=0 WIDTH=100%>
<TR>
<TD ALIGN=left VALIGN=middle>
<IMG ALT="Database Answers Logo" HEIGHT=58 WIDTH=400 SRC="images/dba_400_home.jpg">
</TD> 
<TD ALIGN=right HEIGHT=100 ROWSPAN=2 VALIGN=middle>
<A HREF="images/uniserv_dq_circle_lge.jpg" TARGET=_NEW>
<IMG ALIGN=right ALT="The Data Quality Cycle" BORDER=0 WIiiiDTH=122 HEIiiiGHT=90 SRC="images/dba_data_quality_cycle.jpg">
</TD>
</TR>

</TABLE>


<!--- START OF APRIL 1ST. MENU BAR --->
<table width="100%" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td height="32" background="images/nav_bg.jpg" align="left" valign="middle">
      <table width="100%" border="0" cellspacing="0" cellpadding="0">
        <tr> 
	<td width="1%"><img src="images/spacer.gif" width="15" height="15"></td>
	<td WIDTH=5% wiIIIdth="6%"><A STYLE="text-decoration:none" HREF="index.htm"><font COLOR=white FACE=Verdana SIZE=2>Home</font></td>

	<td align=LEFT WIDTH=5% wiIIIdth="10%"><A STYLE="text-decoration:none" HREF="about_us.htm"><font color="#FFFFFF" FACE=Verdana SIZE=2>About Us</font></A>
	</td>

	<td WIDTH=8% wiIIIdth="10%"><A STYLE="text-decoration:none" HREF="pi_ask_a_question/index.asp"><font color="#FFFFFF" FACE=Verdana SIZE=2>
	Ask a Question</font></A></td>

    	<td width="7%">
	<A STYLE="text-decoration:none" HREF="careers.htm"><font color="#FFFFFF" FACE=Verdana SIZE=2>Careers</font></A>
	</td>
	<td width="7%"><A STYLE="text-decoration:none" HREF="clients.htm"><font color="#FFFFFF" FACE=Verdana SIZE=2>Clients</font></A>
	</td>

	<td align=LEFT WIDTH=8% wiIIIdth="18%"><A STYLE="text-decoration:none" HREF="contact_us.htm"><font color="#FFFFFF" FACE=Verdana SIZE=2>Contact Us</font></A>
	</td>

          <td width="10%"><A STYLE="text-decoration:none" HREF="data_models/index.htm"><font color="#FFFFFF" FACE=Verdana SIZE=2>Data Models</font></A></td>

          <td WIDTH=10%><A STYLE="text-decoration:none" HREF="tutorials.htm"><font color="#FFFFFF" FACE=Verdana SIZE=2>Tutorials</font></A></td>

        <td WIDTH=10%><A STYLE="text-decoration:none" HREF="site_map.htm"><font color="#FFFFFF" FACE=Verdana SIZE=2>Site Map</font></A></td>

        </tr>
      </table>
    </td>
  </tr>
</table>

<!--- END OF APRIL 1ST. MENU BAR --->

<!--- START OF PAGE NAME --->
<FONT COLOR=blue FACE="Verdana" SIZE=2>
<TABLE BGCOLOR="#98CEFD" BORDER=0 CELLPADDING=5 CELLSPACING=5 WIDTH=100%>
  <tr>
    <td height="32" background="images/nav_bg.jUg" align="left" valign=top>
      <table width="10%" border="0" cellspacing="0" cellpadding="0">
        <tr> 
   	<td  background="images/nav_bg.jpg" valign=top width="1%"><img src="images/spacer.gif" width="15" height="15"></td> 
	<td ALIGN=left background="images/nav_bg.jpg" height="32" width="10%"><PRE><FONT COLOR=yellow coloUUUr="#FFFFFF" FACE=Verdana SIZE=2>Data Quality Tools&nbsp;&nbsp;&nbsp;</font></td>
	</tr>
      </table>

    </td>
  </tr>
</TABLE>
<!--- END OF PAGE NAME --->

<TABLE BGCOLOR="#98CEFD" WIDTH=100%>
<TR><TD><FONT COLOR=blue FACE=Verdana SIZE=2>

<!-- begin body Text -->
Here's a short, alphabetical list of some recommended Data Quality Tools.

<!---
<BR>We have produced an 
<A HREF="analysis_of_modelling_tools.htm">analysis of some Data Quality Tools</A> - <B>Free</B>, etc..
--->
<BR>We have identified Vendor support for specific features that are frequently required in Data Quality work :-
<LI><B>ADDRESS</B> stands for Address Validation and Verification.
<LI><A HREF="deduping.htm"><B>DE-DUPING</B></A> is resolving duplicate names has its own page.
<LI><B>PROFILING</B> stands for Profiling, for example, the range and counts of Date values.
<LI><B>SVOC</B> stands for a "Single View of the Customer".

<BR><BR>If you have any specific recommendations or comments, please 
<A HREF='mailto:dba_requests&#64;barryw.org?subject=Comments on Data Quality Tools'><B>Email us</B></A>


<!---There's a <A HREF="#SHORT_NOTE"><b>short note</b></A> about about Data Modeling and Database design at the bottom of the page.
and there was <A HREeeeF="http://www.cs.queensu.ca/FAQs/SE/vendor.html" TARGET=_NEW>
an even more comprehensive list of CASE Tool Vendors</A>, maintained by David Alex Lamb of Queen's University, Ontario, Canada, but the link doesn't work right now.
--->

<BR><BR>

<CENTER><TABLE BORDER=1 CELLPADDING=5>
<TR>
<TD BGCOLOR=blue><CENTER><FONT COLOR=white FACE=Verdana SIZE=2><B>PRODUCT</B></TD>
<TD BGCOLOR=blue><CENTER><FONT COLOR=white FACE=Verdana SIZE=2><B>VENDOR</B></TD>
<TD BGCOLOR=blue><CENTER><FONT COLOR=white FACE=Verdana SIZE=2><B>PRICE</B></TD>
<TD BGCOLOR=blue><CENTER><FONT COLOR=white FACE=Verdana SIZE=2><B>ADDRESS</B></TD>
<TD BGCOLOR=blue><CENTER><FONT COLOR=white FACE=Verdana SIZE=2><B>PROFILING</B></TD>
<TD BGCOLOR=blue><CENTER><FONT COLOR=white FACE=Verdana SIZE=2><B>SVOC</B></TD>
<TD BGCOLOR=blue><CENTER><FONT COLOR=white FACE=Verdana SIZE=2><B>COMMENTS</B></TD>
</TR>

<TR>
<TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2><A HREF="http://www.abinitio.com/" TARGET=_NEW>
Ab Initio</A></TD>
<TD VALIGN=top><A HREF="http://www.abinitio.com/"  TARGET=_NEW><FONT COLOR=blue FACE=Verdana SIZE=2>Ab Initio</A></TD>
<TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>&nbsp;</TD>
<TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>&nbsp;</TD>
<TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>&nbsp;</TD>
<TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>&nbsp;</TD>
<TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>
Has <A HREF="http://www.abinitio.com/abinitio/ab.nsf/contact" TARGET=_NEW>
<FONT COLOR=blue FACE=Verdana SIZE=2>UK Office</A> in Chertsey
</TD>
</TR>

<TR>
<TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2><A HREF="http://www.data-quality-on-demand.com/" TARGET=_NEW>
DQ On Demand</A></TD>
<TD VALIGN=top><A HREF="http://www.uniserv.com/"  TARGET=_NEW><FONT COLOR=blue FACE=Verdana SIZE=2>Uniserv (Germany)</A></TD>
<TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>&nbsp;</TD>
<TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>
<A HREF="http://www.data-quality-on-demand.com/saas-en/functions/address-parsing-verification-cleansing.php" TARGET=_NEW>
Address</A>
</TD>
<TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>&nbsp;</TD>
<TD VALIGN=top>
<A HREF="http://www.uniserv.com/en/data-quality-applications/single-customer-view-data-quality.php" TARGET=_NEW>
<FONT COLOR=blue FACE=Verdana SIZE=2>SVOC</A>
</TD>
<TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>Offers an impressive range of features and White Papers</TD>
</TR>

<TR>
<TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2><A HREF="http://www.ascential.com/" TARGET=_NEW>
IBM Ascential</A></TD>
<TD VALIGN=top><A HREF="http://www.ibm.com/"  TARGET=_NEW><FONT COLOR=blue FACE=Verdana SIZE=2>IBM</A></TD>
<TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>Expensive</TD>
<TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>
<A HREF="http://www-304.ibm.com/jct09002c/gsdod/solutiondetails.do?solution=21190&expand=true&lc=en" TARGET=_NEW>
Address</A>
</TD>
<TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>
<A HREF="http://www-01.ibm.com/software/data/infosphere/information-analyzer/" TARGET=_NEW>
Profiling</A>
</TD>
<TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>
<A HREF="http://www-01.ibm.com/software/data/infosphere/global-name-scoring/" TARGET=_NEW</A>
SVOC</A></TD>
<TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>&nbsp;</TD>
</TR>


<TR>
<TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2><A HREF="http://www.informatica.com/" TARGET=_NEW>Informatica</A></TD>
<TD VALIGN=top><A HREF="http://www.informatica.com" TARGET=_NEW><FONT COLOR=blue FACE=Verdana SIZE=2>Informatica</A></TD>
<TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>Expensive</TD>
<TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>
<A HREF="http://www.informatica.com/products_services/powercenter/options/cleanse_match/Pages/index.aspx" TARGET=_NEW>
Address</A>
</TD>
<TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>
<A HREF="http://www.informatica.com/products_services/data_explorer_standard_edition/Pages/data_explorer_se_features.aspx" TARGET=_NEW>
Profiling</A>
</TD>
<TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>
<A HREF="http://www.informatica.com/solutions/identity_resolution_solution/Pages/index.aspx" TARGET=_NEW>
SVOC</A>
</TD>
<TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>The market leader in Data Integration</TD>
</TR>

<TR>
<TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2><A HREF="http://www.informaticacloud.com/" TARGET=_NEW>Informatica On Demand</A></TD>
<TD VALIGN=top><A HREF="http://www.informatica.com" TARGET=_NEW><FONT COLOR=blue FACE=Verdana SIZE=2>Informatica</A></TD>
<TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>Free Trial</TD>
<TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>&nbsp;</TD>
<TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>&nbsp;</TD>
<TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>&nbsp;</TD>
<TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>When we tried the Free Trial (offered with Amazon) it didn't work out.</TD>
</TR>


<TR>
<TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>
<A HREF="http://www.microsoft.com/sqlserver/2005/en/us/integration-services.aspx" TARGET=_NEW>
Microsoft SSIS</A></TD>
<TD VALIGN=top><A HREF="http://www.microsoft.com" TARGET=_NEW><FONT COLOR=blue FACE=Verdana SIZE=2>Microsoft</A></TD>
<TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>Affordable</TD>
<TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>&nbsp;</TD>
<TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>&nbsp;</TD>
<TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>&nbsp;</TD>
<TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>SSIS - SQL Server Integration Services - is Microsoft's entry in the DQ arena</TD>
</TR>

<TR>
<TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>
<A HREF="http://download.oracle.com/docs/cd/B31080_01/doc/owb.102/b28223/concept_data_quality.htm" TARGET=_NEW>Oracle 
DW Builder</A></TD>
<TD VALIGN=top><A HREF="http://www.oracle.com" TARGET=_NEW><FONT COLOR=blue FACE=Verdana SIZE=2>Oracle</A></TD>
<TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>Expensive</TD>
<TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>&nbsp;</TD>
<TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>&nbsp;</TD>
<TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>&nbsp;</TD>
<TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>&nbsp;</TD>
</TR>

<TR>
<TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>
<A HREF="http://www.talend.com/products-data-quality/talend-data-quality.php#feature" TARGET=_NEW>
Talend</A></TD>
<TD VALIGN=top><A HREF="http://www.talend.com" TARGET=_NEW><FONT COLOR=blue FACE=Verdana SIZE=2>Talend</A></TD>
<TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>Open Source</TD>
<TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>&nbsp;</TD>
<TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>
<A HREF="http://www.talend.com/products-data-quality/talend-open-profiler.php" TARGET=_NEW>Profiling</A>
</TD>
<TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>&nbsp;</TD>
<TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>&nbsp;</TD>
</TR>

<TR>
<TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2><A HREF="http://www.uniserv.com/" TARGET=_NEW>
Uniserv</A></TD>
<TD VALIGN=top><A HREF="http://www.uniserv.com/"  TARGET=_NEW><FONT COLOR=blue FACE=Verdana SIZE=2>Uniserv (Germany)</A></TD>
<TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>&nbsp;</TD>
<TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>&nbsp;</TD>
<TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>&nbsp;</TD>
<TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>
<A HREF="http://www.uniserv.com/en/data-quality-applications/crm-datawarehousing-data-quality.php" TARGET=_NEW>
SVOC</A>
</TD>
<TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>Offers 
<A HREF="http://www.data-quality-on-demand.com/saas-en/partnering/white-labeling-partner.php" TARGET=_NEW><B>Partnership</B></a>
where you can integrate it with your own Website.
</TD>
</TR>

</TABLE>
</CENTER>


<!---
<HR>
<CENTER>
<B>Useful Links :-</B>
<BR>
<TABLE BORDER=1 CELLPADDING=5>
<TR>
<TD><FONT COLOR=blue FACE=Verdana SIZE=2><B>CATEGORY</B></TD>
<TD><FONT COLOR=blue FACE=Verdana SIZE=2><B>ORGANISATION</B></TD>
<TD><CENTER><FONT COLOR=blue FACE=Verdana SIZE=2><B>COMMENTS</B></TD>
</TR>

<TR>
<TD><FONT COLOR=blue FACE=Verdana SIZE=2>Discussion Group</TD>
<TD><FONT COLOR=blue FACE=Verdana SIZE=2><A HREF="http://www.infoadvisors.com/datamodellist.htm">InfoAdvisors</A></TD>
<TD><FONT COLOR=blue FACE=Verdana SIZE=2>Data Model Group</TD>
</TR>

<TR>
<TD><FONT COLOR=blue FACE=Verdana SIZE=2>Portal</TD>
<TD><FONT COLOR=blue FACE=Verdana SIZE=2><A HREF="http://www.infogoal.com/dmc/dmchome.htm">Data Management Centre</A></TD>
<TD><FONT COLOR=blue FACE=Verdana SIZE=2>
<A HREF="http://www.infogoal.com/dmc/dmcdmd.htm">Directory of Data Quality Resources (Highly Recommended)</A></TD>
</TR>

<TR>
<TD><FONT COLOR=blue FACE=Verdana SIZE=2>Portal</TD>
<TD><FONT COLOR=blue FACE=Verdana SIZE=2><A HREF="http://www.dmreview.com">DM Review</A></TD>
<TD><FONT COLOR=blue FACE=Verdana SIZE=2>Search for 'Data Models'</TD>
</TR>


<TR>
<TD><FONT COLOR=blue FACE=Verdana SIZE=2>Portal</TD>
<TD><FONT COLOR=blue FACE=Verdana SIZE=2><A HREF="http://www.inconcept.com/JCM/">Journal of Conceptual Quality</A></TD>
<TD><FONT COLOR=blue FACE=Verdana SIZE=2>Worth Checking out</TD>
</TR>

</TABLE>
</CENTER>
--->

<!---
<A NAME="SHORT_NOTE"></A>

<P><P><P><P><P><FONT COLOR=blue FACE=Verdana SIZE=2>
<HR>
<B>A short note about about Data Quality and Database Design ...</B>
<PRE><FONT COLOR=blue FACE=Verdana SIZE=2>Data modelling and database design are two very different activities.
 
For data modelling, the question you are asking is :
1) What does the world being modelled look like ?  
   In particular, you are looking for similarities between things. 
   Then you identify a 'super-type' of thing which may have sub-types. 
    For example, Corporate Customers and Personal Customers

   If, for example, supplier contacts are conceptually different things from customer contacts, 
  then the answer is that they should be modelled separately.  
  On the other hand, if they are merely sub-sets of the same thing, then treat them as the same thing.

2) For database design, you are answering a different question:-
   "How can I efficiently design a database that will support the functions of the proposed application or Web Site ?" 
   The key task here is to identify similarities between entities so that you can integrate them into the
   same table, usually with a 'Type' indicator.
   For example, a Customer table, which combines all attributes of both Corporate and Personal Customers.
   As a result, it is possible to spend a great deal of time breaking things out when creating a Data Model, and 
   then collapsing them back together when designing the corresponding database.
</PRE>

<A NAME="DAN_HORN"></A>
<PRE><FONT COLOR=blue FACE="Verdana" SIZE=2>   
<B><I>Dan Horne writes about Case ...</I></B>

"I have found Case Studio to be an outstanding tool in its market niche. 
It supports a wide variety of databases, although I've only use it with Oracle, 
where I have found it to be excellent.

It's a bargain at $299, and with additional licenses costing only $89, it is well 
within the budget of most organizations that do not require an enterprise solution. 

I've been searching for a data modelling tool for some time, but most are not within 
my price range, and are generally aimed at larger companies. 

The competitive products I have found are marginally cheaper, but do not support the 
fundamental features I need such as the reverse engineering of existing databases.

The only weakness is the documentation, which is included as a help file.

Some topics such as exporting the diagrams to a graphic file are not covered, and there is 
no detail on writing templates to enhance and extend the system. 

Likewise, Data Flow Diagrams are barely touched on.

<B>Nevertheless, I am very pleased with my purchase. 

Case Studio deserves to be much better known than it is.</B>

Regards

Dan Horne"
</PRE>
--->


<!-- Copyright Notice -->

<BR><CENTER><FONT SIZE=1><I> &#169 DatabaseAnswers.org 2010</I></FONT></CENTER></BR>


<!--- START OF APRIL 1ST. MENU BAR --->
<table width="100%" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td height="32" background="images/nav_bg.jpg" align="left" valign="middle">
      <table width="100%" border="0" cellspacing="0" cellpadding="0">
        <tr> 
	<td width="1%"><img src="images/spacer.gif" width="15" height="15"></td>
	<td WIDTH=5% wiIIIdth="6%"><A STYLE="text-decoration:none" HREF="index.htm"><font COLOR=white FACE=Verdana SIZE=2>Home</font></td>

	<td align=LEFT WIDTH=5% wiIIIdth="10%"><A STYLE="text-decoration:none" HREF="about_us.htm"><font color="#FFFFFF" FACE=Verdana SIZE=2>About Us</font></A>
	</td>

	<td WIDTH=8% wiIIIdth="10%"><A STYLE="text-decoration:none" HREF="pi_ask_a_question/index.asp"><font color="#FFFFFF" FACE=Verdana SIZE=2>
	Ask a Question</font></A></td>

    	<td width="7%">
	<A STYLE="text-decoration:none" HREF="careers.htm"><font color="#FFFFFF" FACE=Verdana SIZE=2>Careers</font></A>
	</td>
	<td width="7%"><A STYLE="text-decoration:none" HREF="clients.htm"><font color="#FFFFFF" FACE=Verdana SIZE=2>Clients</font></A>
	</td>

	<td align=LEFT WIDTH=8% wiIIIdth="18%"><A STYLE="text-decoration:none" HREF="contact_us.htm"><font color="#FFFFFF" FACE=Verdana SIZE=2>Contact Us</font></A>
	</td>

          <td width="10%"><A STYLE="text-decoration:none" HREF="data_models/index.htm"><font color="#FFFFFF" FACE=Verdana SIZE=2>Data Models</font></A></td>

          <td WIDTH=10%><A STYLE="text-decoration:none" HREF="tutorials.htm"><font color="#FFFFFF" FACE=Verdana SIZE=2>Tutorials</font></A></td>

        <td WIDTH=10%><A STYLE="text-decoration:none" HREF="site_map.htm"><font color="#FFFFFF" FACE=Verdana SIZE=2>Site Map</font></A></td>

        </tr>
      </table>
    </td>
  </tr>
</table>

<!--- END OF APRIL 1ST. MENU BAR --->

</TD></TR>
</TABLE>

</BODY>

</HTML>