Video: Matching Organization Name Data Using an API from Within PostgreSQL - All Automated, No Coding.

Posted on April 19th, 2021

In this step-by-step walkthrough example, a database is created and populated with data within PostgreSQL. Then, Interzoid’s Cloud Data Connect Product is used to generate a "Company Name Match Report" from the data by directly connecting to the PostgreSQL database and calling the Company Name Matching API sequentially for each record in a batch-like process. Finally, algorithmically-generated similarity keys are appended to the database table with automated database SQL "INSERTS" for the purposes of matching data with other data sources, even where company name data is inconsistent - all automated and without any coding.

Click here to view the video.

Creating a Database on PostgreSQL, then Matching/Appending Data

Cloud Native Data Engineering: Solutions for Databases

Create new, better, higher-value data based on your existing data
More Info...

API Examples for Better Data

Company Name Matching

Person Name Matching

Street Address Matching

Website Performance

Global Phone Appending

Email Validation

Free Data Engineering Trial Credits

Register for an Interzoid API account and receive free trial credits. See how your strategic data assets can be improved.

Automate API Integration into Cloud Databases

Run live data quality exception and enhancement reports on major Cloud Data Platforms direct from your browser.
More Info...

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 Info...