Please note your specific Oracle server may require different values, additional parameters, or other modifications, but this guide should get you started and on the right path in partnership with your Oracle administrator.Ġ) First, you must install the Actual Oracle ODBC driver version 5.0.9 or later.Īn extra special thank you to Jonathan Monroe and our friends at ActualTech for the super quick turnaround in developing and releasing support for TCPS in the latest driver update.ġ) Manually edit the odbcinst.ini file: /Library/ODBC/odbcinst.iniĪdd the following line in the section, on a new line between Setup and LicenseKey.
We will, however, cover the basics of supporting TCPS with FileMaker Server.
This post will not look into the OSI model, the TCP/IP model, or SSL/TLS and assumes basic experience configuring FileMaker Server, installing Oracle clients, and setting up ODBC DSNs. I was pretty sure it had nothing to do with Talbot County Public Schools or the Tennessee Clinical Placement System, but digging a little deeper I discovered TCPS is an Oracle protocol to enhance security by running TCP/IP with SSL/TLS. Even after seventeen years as a CISSP, I had never run across the term. “What is ‘TCPS’?”, I asked myself, perhaps not in those exact words. As a bonus, we enjoyed working with Actual Technologies, who provide ODBC drivers for Oracle and other third-party databases, for use with FileMaker. With some research, and a little help, we not only figured out “TCPS”, but also set up the FileMaker-to-Oracle connection. However, this Oracle server-as does Oracle Cloud-required something called “TCPS”, which left us scratching our heads. No problem, right? This task requires some development to optimize the database schema and script the data sync, but using FileMaker and an ODBC driver to connect to Oracle is straightforward. A longtime enterprise client recently asked us to integrate a FileMaker Server with an Oracle server.
0 kommentar(er)
