AnsweredAssumed Answered

FileMaker as integration platform for multiple SQL & Oracle & FM database applications?

Question asked by tomwitom on Mar 20, 2016
Latest reply on Mar 20, 2016 by taylorsharpe

I consider using FM 14 as an integration platform for several database applications (SQL, Oracle, FM) in my company instead of Mule-type solutions. Tests show that ODBC works quite well and FM uses SQL tables as its own. The issue during tests so far was rather slow operations on large numbers of records, like sorting, summaries, calculations. When filtered however down to 100k - 200k records the speed was quite OK. Our consultant however recommends that we should use Mule or similar platform for the integration purposes, while FM only as a user-end app. He pointed also the FM does not support ACID, which may create an issue. Would be happy to read advise from whoever solved or is solving similar case.