Mopping Up Dirty Data
RSA Security, like countless other companies, found out the hard way about the perils of dirty data. The security-software firm had just installed customer-relationship-management software from Siebel Systems in 2001 to make it easier for its 300-person sales force to sell authentication products to enterprise and electronic-commerce customers.
Problem was, the Siebel application was fed by several incompatible systems, each with its own way of identifying customers. And RSA had no wayshort of manually going through every recordof being sure salespeople were being given complete and correct information on all customers. If, for example, the companys order-entry system reported information on a customer named James Smith, and the Web server had information on a Jim Smith, the Siebel system probably wouldnt catch on that the two Mr. Smiths were really one customer.