data engineering apis

Introducing Interzoid's "Cloud Data Connect Matching Wizard"

by Interzoid Team


We have just introduced our Cloud Data Connect Matching Wizard. In just a few easy clicks, you can connect to top Cloud databases, CSV/TSV text files, and Excel spreadsheets. You can run match reports, identify inconsistent/non-normalized data, discover hard-to-find duplicate data, append similarity keys for increasing match rates across datasets, create new database tables with cross-referenced similarity keys for smart matching, and more (free tier available to get started).

The Cloud Data Connect Matching Wizard is built on top of our APIs, which in turn is built upon our SmartMatchAI matching technology. This state-of-the-art matching technology utilizes Generative AI, Machine Learning, specialized algorithms, and extensive knowledge bases to identify and discover inconsistent, matching, and otherwise redundant data either within or across datasets.

You can point it to popular databases such as PostgreSQL, MySQL, AWS RDS/Aurora, Google Cloud SQL, Azure SQL, Snowflake, Databricks, and many more. With text files or Excel files, you can access them over the Cloud (stored in AWS S3 for example), or they can be accessed from your local machine.

Here are the easy steps you can take using the Interzoid Cloud Data Connect Wizard to access, match, and otherwise discover data quality issues practically anywhere. Stop spending weeks and months trying to do it manually or with outdated, expensive, and unwieldy tools.


Step 1 - Provide your API key.

Your API key is essentially a license key. It is how we track usage. Log in to your Interzoid account to get your unique key, or register for free to get one.


Provide your API key to track your usage

Step 2 - Choose your data source, either a database or file type.

Select the data source type of the data that you want to analyze.


Choose your data source to improve its data quality

Step 3 (Database) - Set up Cloud database connection information.

If you are connecting to a database in the Cloud to analyze a SQL table, provide your database connection information here. You also have the option of providing a connection string.


Connect to a Cloud SQL database and identify inconsistent, matching data

Step 3 (File) - Browse for your file to process.

If instead of a database, your data is in a text file (CSV, TSV) or Excel file, either locally, or stored somewhere on the Cloud, provide the filename here. You can browse for it if it is on your local machine, otherwise provide the URL of the file's location (such as in AWS S3, for example):


Connect to a CSV file, TSV file, or Excel Workbook and identify inconsistent, matching data

Step 4 - Choose your report type (more options are available for databases than files).

In this example, these are the choices for a CSV text file. A Match Report analyzes all the data in the file. The Wizard then provides a report clustering all organization names or individual names that are similar as determined by having the same generated similarity key:


Choose your match report type

Step 5 - Verify settings and run:


Confirm your matching settings

Step 6 - View the results:

There are multiple ways to view the results. Here, match clusters from the analyzed CSV file are shown in a downloadable text file, along with the similarity keys used to algorithmically cluster them. These keys are generated using our SmartMatchAI technology as described above. These results can also be provided in JSON for programmatic purposes, as well as HTML.


Using Generative AI your match report is provided showing the data quality issues

It's really that simple! Ready to try?

Check out our New Cloud Data Connect Data Matching Wizard!
Identify inconsistent and duplicate data quickly and easily in data tables and files.
More...
Connect Directly to Cloud SQL Databases and Perform Data Quality Analysis
Achieve better, more consistent, more usable data.
More...
Launch Our Entire Data Quality Matching System on an AWS EC2 Instance
Deploy to the instance type of your choice in any AWS data center globally. Start analyzing data and identifying matches across many databases and file types in minutes.
More...
Free Usage Credits
Register for an Interzoid API account and receive free usage credits. Improve the value and usability of your strategic data assets now.
Automate API Integration into Cloud Databases
Run live data quality exception and enhancement reports on major Cloud Data Platforms direct from your browser.
More...
Check out our APIs and SDKs
Easily integrate better data everywhere.
More...
Example API Usage Code on Github
Sample Code for invoking APIs on Interzoid in multiple programming languages
Business Case: Cloud APIs and Cloud Databases
See the business case for API-driven data enhancement - directly within your important datasets
More...
Documentation and Overview
See our documentation site.
More...
Product Newsletter
Receive Interzoid product and technology updates.
More...

All content (c) 2018-2023 Interzoid Incorporated. Questions? Contact support@interzoid.com

201 Spear Street, Suite 1100, San Francisco, CA 94105-6164

Interested in Data Cleansing Services?
Let us put our Generative AI-enhanced data tools and processes to work for you.

Start Here
Terms of Service
Privacy Policy

Use the Interzoid Cloud Connect Data Platform and Start to Supercharge your Cloud Data now.
Connect to your data and start running data analysis reports in minutes: connect.interzoid.com
API Integration Examples and SDKs: github.com/interzoid
Documentation and Overview: Docs site
Interzoid Product and Technology Newsletter: Subscribe
Partnership Interest? Inquire