Cloud Data Matching

This browser-based matching tool enables you to run data quality match reports from database tables existing in the Cloud on the major Cloud Data Platforms (or any other database that you can access via the Internet). CSV files are supported as well. Simply provide the connection string from your data source's database, table name, and column name(s). The Match Column Name is the column for which the selected matching algorithm will be applied to identify inconsistently represented data and duplicate data candidates. Data will be retrieved, the appropriate matching algorithm will be utilized, and the reports generated and displayed for your use and analysis. You can also generate SQL Insert scripts with the similarity keys appended to apply your own matching and merging logic, or write results to new tables in the source database through the connection. This is an easy step to take in improving the usability and value of your important data assets. A free usage tier is available.

Report Setup:

*Interzoid API License Key: Login or register to obtain

Select Matching Algorithm Type:

Company and Organization Names

Individual Names

Street Addresses

See example reports based on matching algorithm types

*Database Connection Type (Select):

*Select Database Connection String (use full URL if CSV, use full URL if CSV, such as "https://dl.interzoid.com/csv/companies.csv"): Sample connection strings

*Table Name ("CSV" if CSV):

*Match Column Name (Column # if CSV, first column = 1):

Optional Reference Column Name (to include on report):

New Table Name (only if writing results back to database):

Select Report Type:

Display Match Report of Duplicate Candidates (most users)

Generate Similarity Keys Only for All Records (advanced)

Generate Insert SQL Script for Similarity Keys for All Records (advanced)

Create New Table in Source Database with Similarity Keys (advanced)

Additional Information:

Login to www.interzoid.com to obtain your API Key. It is how we track usage. If you do not yet have one, register for a free trial at www.interzoid.com/register-api-account.

Sample SQL Scripts in case you need sample/test data for a test drive.

How to use CSV files for data processing within Interzoid Cloud Data Connect.

API used for Company/Organization Name Matching

API used for Individual Name Matching

API used for Address Matching

Sample Match Reports

            
        Sample Matches (showing all three report types):

        G.E.
        Gen Electric
        General Electric

        Bill Jameson
        William R. Jamison

        500 Browne lane suite #100
        500 Browne ln suite 100
        500 brown lane ste 100


        Similarity Key Appending (including in new table):

        Apple International,k2HDzRo6pObj5PkfW5sskHTHESF7AQ
        apple inc.,k2HDzRo6pObj5PkfW5sskHTHESF7AQ
        The Apple Store,k2HDzRo6pObj5PkfW5sskHTHESF7AQ
        Apple Corp,k2HDzRo6pObj5PkfW5sskHTHESF7AQ
        Apple USA,k2HDzRo6pObj5PkfW5sskHTHESF7AQ

        7-11,Rf6RCPXSmrZOp8FKRSjQuRvfzO3ef
        7-eleven,Rf6RCPXSmrZOp8FKRSjQuRvfzO3ef
        Seven Eleven Stores,Rf6RCPXSmrZOp8FKRSjQuRvfzO3ef

Return to Platform Home