Oracle <--> Filemaker

[Mark Stuller]

Hello

We are going to take the plunge and setup a sync between our Oracle tables and 'shadow' FileMaker tables and we're seeking input.

One thing we are wondering about is a 'one-way' sync. We don't want changes to be sync'd back to Oracle. The bigger issue is that we don't want deletions in the Oracle table to be deleted in the FileMaker table. There often are children to these records we don't want deleted or orphaned.

As well, are there any gotchas we should consider? I've read the Advanced topics and feel mostly comfortable but you never know what you don't know!

Thanks, Mark

[Jesse Barnum]

Hi Mark!

You should set up a one-way sync with Oracle as the hub and FileMaker as the spoke. This will work just fine, except for the 'no deletions' part. By default, MirrorSync will always delete records in the spoke if they are deleted in the hub. The best (only) way to fix this is to sync using a privilege set in FileMaker that does not allow deletions.

[Mark Stuller]

Thanks Jesse. Sounds good.