If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Tools for Database Comparisons

Started by beerguy82, 29 Dec 2008 09:57:27 AM

Previous topic - Next topic

beerguy82

Does anyone know a good tool for comparisons of databases by a threshold level?  Here is a little background:

Our company tracks our product depletions from our distributors by SKU.  The data is very accurate but not very robust.  Because of this we also buy robust data from a vendor.  This data is not always accurate.  Currently we do a manual comparison of distributor level data and look for differences over a certain percentage.  This is very time consuming and not all that helpful.  We would like to do this at a SKU level with some sort of tool that will run off-hours and throw SKU level exceptions into a seperate table for follow-up. 

I've searched quite a bit and found plenty of programs that will look for exact matches, but nothing so far that will allow a threshold before reporting an exception.  Does anyone know anything that can do this?  I'm not a database wizard, so I might be missing something there too.  Can this easily be implemented using SQL? 

Thanks!