Looking to see what the best way to implement this
@jprouty.jcius.com
Welcome to community!
You should write custom code for access to external DB. I think that it can be called using mechanism logichook or shedule. Look at the documentation:
Intro Logic hooks allow you to hook into various events in SuiteCRM to fire custom code. This can allow you to, for example, make a call to an external API, or to create a new record if certain events occur.
Types Logic hooks can occur in three...
Intro Scheduled tasks are performed in SuiteCRM by the scheduler module. Jobs are placed into the queue either through the defined scheduled tasks or, for one off tasks, by code creating job objects. Note that both scheduled tasks and using the job...