Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


FMPA sync behavior

Posted on 2011-04-30
Medium Priority
Last Modified: 2012-05-11
I have a FMPA 11 db with several tables that mirror their counterparts in an Oracle enterprise data warehouse. I am using FMPA as a simpler, more efficient method to view, insert, append, and delete Oracle records (over which I have those privileges) than writing lengthy, detailed  SQL queries against  Oracle. When I use Manage>Database>Sync, what are the sync limitations? I.e.:

If I have setup unique identifiers, does Sync setup need to be repeated with each sync, or does one setup allow unlimited syncs on the same relationship?
How long should a modification in FM take to propagate to Oracle after a sync?
Is this a safe and reliable method to append existing records?
I have the experience that the Oracle side tends to repopulate FM after a sync if I have deleted FM records. Am I doing something wrong that can be corrected?

Question by:MarkJulie
  • 2
LVL 25

Accepted Solution

Will Loving earned 1500 total points
ID: 35498084
The "Sync" button in Manage -> Database -> Sync is only for synchronizing field schema between FileMaker and the ODBC source, it does not synchronize data. So, for instance, if after you add the external data source table to FileMaker's relationship graph you then either add new fields to the external db or 'delete' a field in an external database within FM, those new or 'deleted' fields will appear in the FileMaker 'shadow' table of your external data source.

To synchronize data between FM and an external data source generally requires scripting and a well-thought out strategy.

For more on this, go to Help -> FileMaker Pro Help and search for the help article called "Updating data between FileMaker and ODBC data sources". There is also a FileMaker Knowledgebase article with general tips on syncing to be found at:


Author Comment

ID: 35692621
The article was helpful but somewhat bypasses my concern. I have one table that allows me to upload, modify and delete FM records that get mirrored in Oracle. The second that was setup the same way via ODBC behaves erratically. The message I get is that the working table is a fluke, so I will close the question in the absence of better advice.

Author Closing Comment

ID: 35692675
The solution was complete in the issue it attempted to address. The behavior I experience in FM is more robust than the answer I received, but I was told that syncing is possible or easily achievable between FM and an ODBC data source.

Featured Post

Restore individual SQL databases with ease

Veeam Explorer for Microsoft SQL Server delivers an easy-to-use, wizard-driven interface for restoring your databases from a backup. No expert SQL background required. Web interface provides a complete view of all available SQL databases to simplify the recovery of lost database

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  â€¦
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
Suggested Courses
Course of the Month13 days, 17 hours left to enroll

580 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question