Systems and user interfaces for dynamic access of multiple remote databases and synchronization of data based on user rules

摘要

A computing system is configured to access a plurality of remote databases in order to identify data inconsistencies between the remote databases and provide user interfaces to a user in order to initiate communication via one or more APIs to certain remote databases indicating updates that reconcile said data inconsistencies.

主权项

1. A computing system configured to access a plurality of remote databases in order to identify data inconsistencies between the remote databases and provide user interfaces to a user in order to initiate communication via one or more APIs to certain remote databases indicating updates that reconcile said data inconsistencies, the computing system comprising:
one or more storage devices configured to store electronic software instructions; and one or more computer processors in communication with the one or more storage devices, the one or more computer processors configured to execute the stored electronic software instructions to cause the computing system to automatically:
access, over a network, first user information stored in the one or more storage devices, the first user information including indications of each of a plurality of remote databases having data regarding a first user, the first user information also including:
a plurality of data fields; anda corresponding plurality of master data values associated with respective data fields;access a first remote database of the plurality of remote databases via an application programming interface in communication with the first remote database over the network;determine first remote data associated with the first user stored in the first remote database;compare the first remote data to the first user information by comparing a plurality of master data values in the first user information to corresponding remote data values of remote data fields;identify a particular master data value in a particular data field that does not match a corresponding remote data value in an associated remote data field;generate an interactive user interface for transmission to a remote user computing device, the interactive user interface including authentication prompts usable to authenticate an identity of the first user;receive input from the remote user computing device;compare the input from the remote user computing device to expected authentication information associated with the first user;in response to determining that the expected authentication information matches the input from the remote user computing device, authenticate the first user;generate a second interactive user interface for transmission to the remote user computing device, the second interactive user interface including:
the particular master data value;the corresponding remote data value; anda first interactive user interface control usable by the first user to instruct the computing system to update the particular master data value with the corresponding remote data value from the first remote data;in response to receiving an indication via the second user interface that the first user selected the first interactive user interface control, update the particular master data value in the first user information with the corresponding remote data value from the first remote data;identify a subset of the plurality of remote databases that each do not include the corresponding remote data value, said identifying comprising, for each of the plurality of remote databases:
accessing the remote database using security protocols and/or communication protocols, over the network;determining a remote data value in a remote data field corresponding to the particular data field in the remote database;determining whether the corresponding remote data value is included in the updated master data value; andif the remote data value is not included in the updated master data value, including the remote database in a subset of remote databases for which updates are available;generate a third user interface for transmission to the remote user computing device, the third user interface including:
an indication of the subset of remote databases for which updates are available; anda second interactive user interface control usable to select one or more of the subset of remote databases; andin response to receiving an indication of a selected one or more of the subset of remote databases from the remote user computing device, for each of the selected one or more remote databases:
determine security protocols and/or communication; andusing the determined security protocols and/or communication protocols, transmit the updated master data value to the selected remote database in order to initiate an update at the selected remote databases.