I would like to be able to sync certain tables from a remotely hosted database into a Wordpress database, these tables are not containing any related Wordpress content. These tables contain simple warranty lookup info that returns a simple yes/no if a specific serial number of a product is past the warranty date. I have SSH and privileges set up for this and my IP is whitelisted.
On the management side, the user enters this data into an internal system that pushes the information to their server hosting the database.
My goal is not to disrupt the system they are using and simply use a form on the site to access the lookup feature with the imported data from the external database. I hope this makes sense.
I appreciate any help or guidance in this.