Posted on April 6th, 2021
In this step-by-step walkthrough example, a database is created and populated with data on Amazon's Aurora Serverless Cloud Database Platform. Then, Interzoid’s Cloud Data Connect Product is used to generate a "Company Name Match Report" from the data by directly connecting to the Aurora 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.