Microsoft CRM connection to Oracle EBS
Currently what we do is that I create a duplicate copy of the Baan ERP table and then I have a database trigger created. If anything changed in the erp master table there the trigger will push all the changes to the copy table. And CRM gets the data and process it all through the copy table without having to touch the erp master table.
Now that we are going to Oracle EBS. I understand that Oracle EBS does not allow any kind of database triggers. How can we get a connection to extract data and maybe intergated to Microsoft CRM?