Integrate Sugar with external database

Recomendation as per best practices is to configure a WebLogicHook after_save from Sugar to a layer at external DB.

But if this is not an option so you can configure a custom db instace which points to external DB and send data from a LogicHook after_save.

We have do that for SugarCRM MySQL to External Oracle and MySQL.

The code may be something like that:

$adapter = null;
$driver_list = DBManagerFactory::getDbDrivers();

dbconfig = array(
	'db_host_name' => 'external_db_hostname',
	'db_user_name' => 'external_db_user',
	'db_password' => 'external_db_password',
	'db_name' => 'external_db_name',
	'db_type' => 'external_db_type', // oci8
);

if(isset($driver_list[$dbconfig['db_type']])) {
	$adapter = $driver_list[$dbconfig['db_type']];
	$adapter->connect($dbconfig, false);
}

Regards

Hi Andre,

Is there a list of available db_type values somewhere?

Thanks

Hi Andre,

Is there a list of available db_type values somewhere?

Thanks

Hello Polys,

Nice to find you in the Club

Probably the list of values depends on the list of drivers available https://support.sugarcrm.com/Knowledge_Base/Platform_Management/Determining_Which_Database_Sugar_is_Running/

Please note, that according to Sugar Cloud Policy there is a restriction for Sugar Cloud instances, that "Outbound HTTP connections must have timeouts under 1 second."

AFAIK, SugarCRM strongly suggests a middleware approach - before implementing outbound connections for production, I would suggest checking with Sugar Support whether limitations on other types of outbound connections for the Cloud instances.

LBDataBridge webservice fits the recommendations as middleware for Sugar integrations.