Intelligent Search Technology Extends Microsoft SSIS Data Cleansing Functionality
Intelligent Search Technology now provides SSIS users with a flexible and efficient way of cleansing their data directly within their SSIS solutions.
White Plains, NY (January 23, 2007) — Intelligent Search Technology today announced availability of its
Data Quality (DQ) solution for SQL Server 2005 Integration Services (SSIS). This solution extends the
data cleansing capabilities of SSIS by providing powerful components that utilize the intelligence of IST’s NameSearch® engine. The DQ components available at this time are SSIS Deduplication, Merge-Purge,
and Address Correction. These components integrate directly into the SSIS data flow engine, allowing
users to seamlessly utilize IST’s advanced data matching technology within their SSIS solutions.
The Deduplication transformation component uses the NameSearch algorithms for advanced searching
and matching to filter duplicate records from a single data stream. The user can customize the deduplication process by selecting match criteria, weight factors, score thresholds and match algorithms. The match
criteria can include any combination of personal names, corporate names, addresses, dates, numbers and other alphanumeric sequences. Duplicate records are filtered into a separate table where they are grouped together based on their duplicate identifiers. Users may also choose to remove duplicate records.
The Merge-Purge transformation component allows merging of two data streams by creating full records
from partial duplicates while simultaneously filtering duplicate records. Similar to deduplication,
merge-purge derives results by searching and matching on different combinations of match criteria.
The output is stored in a master table containing deduplicated records from both data sources.
The Address Correction component corrects addresses according to U.S. Postal Service™ standards while flagging or filtering incorrect addresses. Additionally, this component will provide possible alternative addresses when the input address is ambiguous.
The combination of the SSIS flexibility and ease of use with NameSearch’s data cleansing intelligence
offers users an extremely powerful and efficient solution for solving data quality issues during the data integration process.
IST is proud to partner with Microsoft on its SSIS Data Quality initiatives. With this set of components, IST continues to solidify its position as the leading provider of database integrated searching and matching solutions.
About Microsoft SSIS
Microsoft SQL Server 2005 Integration Services (SSIS) is a platform for building high performance data integration solutions, including extraction, transformation, and load (ETL) packages for data warehousing. Integration Services includes graphical tools and wizards for building and debugging packages; tasks for performing workflow functions such as FTP operations, for executing SQL statements, or for sending e-mail messages; data sources and destinations for extracting and loading data; transformations for cleaning, aggregating, merging, and copying data; a management service, the Integration Services service, for administering Integration Services; and Application Programming Interfaces (APIs) for programming the Integration Services object model.
For more information about SSIS Data Quality, please visit:
http://msdn2.microsoft.com/en-us/library/aa964137.aspx
About Intelligent Search Technology
Founded in 1993, Intelligent Search Technology, Ltd. (IST) has devoted its resources to the development
of high performance, multicultural identity search and matching software. IST is a privately-held company.
Its highly acclaimed identity search and matching engine, NameSearch®, adds intelligence to applications requiring efficient and accurate retrieval of identity data regardless of variations. With the development of MerlinMerge® SpeedPro (duplicate detection, merge-purge software), CorrectAddress® (address verification and correction software) and ISTwatch® (OFAC compliance and terrorist searching software),
IST has solidified its position as the technological leader in the search and matching industry.
