data engineering apis
AI-Powered Data Quality


Check out our new Cloud Data Connect Wizard!

Try our Cloud Data Connect Wizard (free-tier available)...In just a few easy clicks you can connect to Cloud databases, CSV/TSV text files, and Excel spreadsheets - all in the Cloud or local files. Run match reports, identify inconsistent/non-normalized data, find redundant data, append similarity keys, create new tables with similarity keys, and more.


...

Company & Individual Name Matching

The step-by-step wizard leverages our data matching API Products. Utilize Generative AI-enhanced algorithms to quickly identify inconsistent, redundant, and otherwise problematic data.

Learn More About APIs...
...

Supported Databases and File Types

The wizard application connects through native drivers for all the major Cloud database types. It also works with various file types, both local and URL accessible, for CSV, TSV, and Excel files.

Learn More About Data Sources...


Launch Data Matching Wizard

Incorporate these capabilities as part of a workflow using our APIs/SDKs, including scheduled runs, ongoing processing, or as part of a data pipeline. See: Data Matching Workflow Guide.

Check out a quick step-by-step example of the Cloud Data Connect Matching Wizard. See: Wizard Tutorial.

Looking for the classic matching application? See: Cloud Matching Application.


Frequently asked Questions (FAQs)


What is the Cloud Data Connect Wizard?
The Cloud Data Connect Wizard is a tool that simplifies the process of connecting to various data sources, such as cloud databases, CSV/TSV text files, and Excel spreadsheets, allowing users to run match reports, identify data inconsistencies, and more, all through a user-friendly, step-by-step interface.

How does the matching report feature work?
The matching report feature analyzes data to identify similar entries based on generated similarity keys, helping users find inconsistent, non-normalized, or redundant data effectively.

What types of data sources can I connect to with the Cloud Data Connect Wizard?
Users can connect to top cloud databases like PostgreSQL, MySQL, AWS RDS/Aurora, Azure SQL, Google Cloud SQL, Snowflake, and others, as well as CSV/TSV text files, Parquet files, and Excel spreadsheets, either stored in the cloud or locally.

How can I connect to a database or file in the Cloud?
Users can connect to databases or files by providing the necessary connection information or URLs, following guided steps within the Wizard to ensure secure and correct access.

What is a similarity key, and how is it used in data matching?
A similarity key is an identifier used to group similar data entries, aiding in the detection of duplicates or inconsistencies within or across datasets, thereby facilitating data normalization and deduplication.

Can I create new tables with similarity keys using the Wizard?
Yes, the Wizard allows users to create new database tables with similarity keys, enabling the establishment of links between related data entries for enhanced matching and analysis.

What algorithms or technologies power the Cloud Data Connect Wizard?
Behind the scenes, the Wizard employs our SmartMatchAI technology, which leverages Generative AI-enhanced algorithms, Machine Learning, data content type-specific advanced algorithms, relevant knowledge bases, and more to optimize the data matching processes.

Is there a free tier available for the Cloud Data Connect Wizard?
Yes, there is a free tier available for the Cloud Data Connect Wizard, which provides free, fully-functional access for the first 1000 records of any dataset, ideal for users to get started and evaluate the product's capabilities.

How does Interzoid's pricing model work?
Interzoid uses a credits-based system, where each API call deducts a credit from your balance. Credits are purchased monthly or annually, with annual subscriptions offering a cost benefit.

Is there an option for deploying the Interzoid Generative-AI powered API matching system on my own Cloud infrastructure?
Yes, you can deploy the entire Interzoid API matching system on AWS EC2 in your own Virtual Private Cloud (VPC) using a pre-built Machine Image via the AWS Marketplace, without requiring API keys and billed hourly rather than per-API-call.

What is an API key, and why do I need it for the Cloud Data Connect Wizard?
An API key acts as a license key, tracking usage and providing authentication for the user. It is essential for accessing and utilizing the Wizard's features securely.

What are the options for Cloud database connections?
To connect to a Cloud database, users can provide their database connection details via connection strings, facilitating a secure link to their cloud-hosted data for analysis.

How can I process local or cloud-stored text and Excel files?
The Wizard allows users to browse and connect to local files or input URLs for cloud-stored files, ensuring versatile access to data sources for analysis.

What types of reports can I generate with the Wizard?
Users can generate match reports, view data clusters, and analyze similarity keys, among other options, to understand and improve their data quality comprehensively.

In what formats can I view the match results?
The Wizard provides results in various formats, including text files, JSON, and HTML, catering to different user preferences for review and further analysis.

How can the Wizard aid in improving data quality?
By identifying duplicate, inconsistent, or non-normalized data, the Wizard helps users enhance data accuracy, reliability, and usability, contributing to better data management practices.

Can I use the Wizard for company and individual name matching?
Yes, the Wizard is equipped to handle company and individual name matching, utilizing its algorithms to identify and group similar names efficiently.

How can I incorporate the Wizard into my existing data pipeline?
Users can integrate the Wizard into their data pipelines through APIs/SDKs, enabling automated data quality checks and improvements within their established data processing workflows.

What scheduled or ongoing processes does the Wizard support?
The Wizard can integrate into scheduled runs or ongoing processing workflows, offering automation and regular data quality checks as part of a comprehensive data strategy.


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?

Start Here
Terms of Service
Privacy Policy

Use the Interzoid Cloud Connect Data Platform and Start to Supercharge your Cloud Data Now: connect.interzoid.com
API Integration Code Examples and SDKs: github.com/interzoid
Documentation and Overview: Docs site
Interzoid Product and Technology Newsletter: Subscribe
Partnership Interest? Inquire