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

Video: Enriching International Phone Numbers Within PostgreSQL - All Automated, No Coding.

by Interzoid Team


Posted on April 28th, 2021


Video: Enriching International Phone Number Data in PostgreSQL

In this step-by-step walkthrough example, a database is created and populated with sample data using Postgres version 13.2 (works the same with previous versions). Then, Interzoid’s Cloud Data Connect Product is used to append and enrich the international telephone sample data by directly connecting to PostgreSQL and calling Interzoid's Global Telephone Information API sequentially for each record in a batch-like process. This includes geographic data such as country, region, and city. It also provides data points such as language spoken, is it a mobile phone, and estimated wealth category. The data is inserted into a PostgreSQL table to make it easy to use within any database application, for queries, joins, exporting, etc. - all automated and without any coding. The end result is better and more valuable data assets via the bridging of Cloud database platforms and APIs, providing a better data foundation for analytics, data science, artificial intelligence, machine learning, marketing, CRM, and any other data-driven initiative.

Click here to view the video.


Creating a Database on PostgreSQL, then Enriching International Telephone Data

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