Systems and methods for normalizing data having disparate formats

Abstract

In some aspects, the techniques described herein relate to a method including: executing a first query, at a predefined time interval, against a target datastore for insight records related to an entity identifier; storing results of the first query as a record set, wherein the record set includes one or more existing insight records, and wherein each existing insight record includes connection information for connecting to a corresponding insight datastore; executing insight retrieval logic for each insight record in the record set, wherein the insight retrieval logic executes a second query against the corresponding insight datastore and retrieves a new insight value from the corresponding insight datastore; persisting the new insight value in a new insight record in the target datastore; and sending the new insight record as a communication to a recipient.