Check out our High Performance Batch Processing API: Match and Enrich Data Using CSV/TSV Files as Input Data to our APIs Learn More

Using Interzoid Cloud Data Connect with RapidAPI to Find Matching Company Names in Cloud Databases

by Interzoid Team


Posted on May 12th, 2021


Interzoid Cloud Data Connect with RapidAPI to Find Matching Company Names in Cloud Databases

If you are using Interzoid APIs through the RapidAPI Marketplace (meaning your endpoints and your billing occurs through RapidAPI), then here are instructions for using these endpoints through Interzoid's Cloud Data Connect product.

Using the Interzoid's Company Name Matching Advanced API via the Cloud Data Connect product allows you to execute the API in batch mode right out of the box without any programming, using a relational table or view (or equivalent) as the input data source. Each record in the source table (or view) is sent to the API sequentially, with your choice of generating a Match Report, displaying matching keys, or inserting similarity keys into a new table with the corresponding company name.

Storing the similarity keys in a table allows for SQL queries or matching within the database (or other data source if using ODBC) for customized usage.

Using the Interzoid Cloud Data Connect product through RapidAPI requires a RapidAPI API key obtained by selecting a freemium subscription to Interzoid's Company Name Matching Advanced product on the RapidAPI Marketplace.

After obtaining your RapidAPI API key, you must download Interzoid's Cloud Data Connect product for your operating system. It is available here for Windows, Linux, Apple Mac/Darwin, and Solaris.

Then, from the command line where the binary executable is located, run a command like the following examples (connection strings vary by data source):


To create a company name match report for a PostgreSQL database (also including AWS Aurora/RDS/Redshift, etc.):

$ izdc -function=companymatch -target=postgres -rapidapikey=YourRapidAPIKey
        -dsn=postgres://postgres:yourpassword@localhost/yourdatabase?sslmode=disable -algo=wide -table=companies
        -column=company

To create a company name match report for a MySQL database (also including AWS Aurora/RDS/Redshift, MariaDB, etc.):

$ izdc -function=companymatch -target=mysql -rapidapikey=YourRapidAPIKey
        -dsn=root:password@tcp(localhost:port)/database -algo=wide -table=companies -column=company

To create a new table containing similarity keys within a PostgreSQL database (also including AWS Aurora/RDS/Redshift, etc.):

$ izdc -function=companymatch -target=postgres -rapidapikey=YourRapidAPIKey
        -dsn=postgres://postgres:yourpassword@localhost/yourdatabase?sslmode=disable -algo=wide -table=companies
        -column=company -keysonly=true -gensql=true -createtable=true -newtablename=YourNewTable

To create a company name fuzzy match report from a Snowflake table:

$ izdc -function=companymatch -target=snowflake -rapidapikey=YourRapidAPIKey
        -dsn=user:yourpassword@yourinstance/yourdatabase/public -algo=wide -table=companies -column=company

To create a new table containing similarity keys within Snowflake:

$ izdc -function=companymatch -target=snowflake -rapidapikey=YourRapidAPIKey
        -dsn=user:yourpassword@yourinstance/yourdatabase/public -algo=wide -table=companies -column=company
        -keysonly=true -gensql=true -createtable=true

Create a new table containing company name similarity keys in CockroachDB:

$ izdc -function=companymatch -target=cockroachdb -rapidapikey=YourRapidAPIKey
        -dsn="postgres://userid:password@free-tier.gcp-us-central1.cockroachlabs.cloud:port/defaultdb?sslmode=require&options=--cluster=clustername"
        -table=companies -column=company -gensql=true -createtable=true

To run a match report from a CSV file:

$ izdc -function=companymatch -target=csv -csvfile=c:\data\10comps.csv -csvcolumn=1 -algo=wide
        -rapidapikey=YourRapidAPIKey

To run a match report from an Access database file (may need curly braces around the driver name):

$ izdc -function=companymatch -target=odbc -dsn="Driver=\Microsoft Access Driver (*.mdb,
        *.accdb);Dbq=C:\documents\yourdata.accdb" -rapidapikey=YourRapidAPIKey -algo=wide -table=companies
        -column=company

You can also view the Interzoid Cloud Data Connect product documentation for more information.

If you have questions or need assistance with these and other data platform sources, contact us through RapidAPI's support feature or email us at support@interzoid.com

High-Performance Batch Processing: Call our APIs with Text Files as Input.
Perform bulk data enrichment using CSV or TSV files.
More...
Available in the AWS Marketplace.
Optionally add usage billing to your AWS account.
More...
See our Snowflake Native Application. Achieve Data Quality built-in to SQL statements.
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...
Try our Pay-as-you-Go Option
Start increasing the usability and value of your data - start small and grow with success.
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...