Hi,
I am writing to request support with establishing a real-time connection between our FileMaker database and our Oracle database. We have a Manufacturing Execution System (MES) built on FileMaker, and we need to access its data in near real-time from Oracle.
I have been exploring various options, including the ODBC driver (HSODBC), but I have encountered challenges in achieving a stable and efficient real-time connection. I am seeking guidance on the recommended approach for this integration and would like to learn from other users' experiences.
Specifically, I would appreciate it if you could provide information on the following:
- Best practices: What are the recommended methods and configurations for connecting FileMaker and Oracle in real-time or near real-time?
- Alternative solutions: Are there other tools or technologies that might be better suited for this integration?
- User experiences: Have other users encountered similar challenges? If so, what solutions did they implement?
- Troubleshooting: Are there any known issues or common pitfalls to watch out for when setting up this connection?
I have attached a detailed log of my recent attempts to connect FileMaker and Oracle, which includes error messages and configuration details. This may provide further context for the issues I am facing.
Thank you for your time and assistance. I look forward to hearing from you and learning from your expertise.
ems_agt_8380.txt