At its SAS Users Group International (SUGI) conference in San Francisco, SAS will roll out a new customer data integration server and detail new features in its enterprise data integration server, said Jim Goodnight, CEO of the Cary, N.C.-based company. SAS will expand the data-quality features in the enterprise data integration server for profiling, monitoring and cleaning data, he said.

"It's a shame to wait until people want to use data in a warehouse before cleaning up the data," Goodnight said. "It should be cleaned up in the operational system."

The new customer data integration tools will be designed to allow companies to synchronize, consolidate and manage customer information from across an enterprise, according to SAS.

Debbie Weisensee, senior business analyst and manager for a BI project at McMaster University in Hamilton, Ontario, said her organization has been using the SAS data-integration server as part of an ongoing effort to build an enterprisewide data warehouse. The university did an assessment of data quality at the beginning of the project and changed some data definitions to ensure that they were consistent across its campus. However, some records come out of transactional systems with missing fields or other problems and have to be rejected before being added to a data mart, she said. Now the university has to do some extra programming to check for certain data-quality requirements. Weisensee said she is interested in learning more about the new features in the integration server to possibly eliminate some of that programming.

In addition, the university in September will be rolling out SAS performance management software to create scorecards, another project where the quality of the data in the warehouse will be critical, she said.