Populate MySQL and Oracle at same time?

[leowolff]

Hello, we have another system that will need to load the clients registered in the accounts module on Sugar, right now he loads it from another oracle source, but we want to change it to Sugar soon. One idea given by our IT guy was to make Sugar to save the info on both tables when a new account is created, I mean, once account saved button is clicked it will populate the MySQL account table and an Oracle account table, is it possible?

Btw, we dont have the source of the system that need to read the info, for this reason we are trying to force Sugar to save in the same place.

[Angel]

Yes, it is possible to do that.

Perhaps the most transparent way of accomplishing the task would be to create an after_save logic hook that runs custom code that copies the data into the Oracle system upon the record being added into Sugar.

See the developers site for further information on logic hooks: http://developer.sugarcrm.com

A brief example of one can also be found on my blog: http://cheleguanaco.blogspot.com/200...k-example.html