Standardize Inconsistent Cloud Data

This browser-based data engineering tool enables you to run data inconsistency analysis 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). Simply provide the connection string from your data source's database, table name, and column name(s). The Standarize Column Name is the column for which algorithms will be applied to identify inconsistently represented data and provide standardization suggestions. Data will be retrieved, and the report generated and displayed for your use and analysis. You can also generate SQL Insert scripts for the creation of a new standardization table, 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 Standardization Algorithm Type:

City Data

State Data

Country Data

*Database Connection Type (Select):

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

*Table Name ("CSV" if CSV):

*Standardize 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 Standardization Suggestion Report (most users)

Generate Insert SQL Script for Standardization Suggestions for All Records (advanced)

Create New Table in Source Database with Standardization Suggestions (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 City Data Standardization

API used for State Data Standardization

API used for Country Data Standardization

            
        Standardization (showing all three report types):

        SF -> San Francisco
        San Fran -> San Francisco
        SAN FRANCISCO -> San Francisco

        Calif. -> CA
        California -> CA
        Califonia -> CA

        US -> United States
        USA -> United States
        Amer. -> United States


        Appending of Standard (including in new table):

        Arizona,AZ
        Ariz.,AZ
        Arzona,AZ

Return to Platform Home