Sounds like a great case for scheduled job in SuiteCRM, you can write your own code to fetch the info from the other DB and create new records in SuiteCRM.
OR
Is your other system capable of generating a webhook? You could build a custom entry point to accept the webhook everytime a add/edit or delete is done in the other database.
Yep no problem you just have to write your logic which records to pick to create and/or update or delete on the SuiteCRM side.
You’ll have to code some logic to maybe get records since the last sync. and/or compare records that have changed since the last sync and then deal with either updating the bean, deleteing the bean or creating a new bean.
Here is an example I tried on my local system to add a scheduler and a job to delete table entries. Please change the code and SQL if required to insert records from a db into suite db table.
Create a new file at custom/Extension/modules/Schedulers/Ext/ScheduledTasks/scheduledtasks.ext.php
<?php
$job_strings[] = 'cleanDBRecordsScheduler';
function cleanDBRecordsScheduler(){
global $sugar_config, $timedate;
$GLOBALS['log']->debug('----->Scheduler fired job of type cleanDBRecordsScheduler()');
$db = DBManagerFactory::getInstance();
$query = "DELETE FROM sugarfeed";
$GLOBALS['log']->debug("----->Cleaned up records as per query $query");
$db->query($query);
return true;
}
Create a new language file and add a key at custom/Extension/modules/Schedulers/Ext/Language/en_us.cleandbrecords.php
<?php
$mod_strings['LBL_CLEANDBRECORDSSCHEDULER'] = 'Clean OLD DB Records – CUSTOM';
From admin->repair->quick repair and rebuild
Create a new Scheduler Record and select the newly added job. Please select the new JOB from the drop down list.