A longtime enterprise client recently asked us to integrate a FileMaker Server with an Oracle server. 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.Continue reading “Connect FileMaker Server to Oracle Server and Oracle Cloud Using ODBC and TCPS”
Over years of reviewing Ruby code, the same things tend to come up over and over. In this post, I’d like to address some of the most common code smells I find when reviewing OOP code (and Ruby code in particular).Continue reading “Common Code Smells in OOP”
Besides using its own internal accounts, FileMaker Server supports centrally managed authentication using directory systems such as Active Directory. Using these systems can help control access to both FileMaker Server’s admin console and database files.
If you are using directory bound servers already, you’ll often want to add access to a FileMaker Server’s console using directory groups instead of adding in specific users. Previously this was easily done with either Workgroup Manager (no longer supported on macOS), or the Server application (still viable, but just in a vestigial form).
Here I’ll show how you can do the same thing using the dscl command.Continue reading “Use External Directory AD Group for FileMaker Admin Console Access on macOS”
Doing the simple is hard. Someone recently reminded me of this when discussing business workflow. Tasks like scheduling, calendaring, communicating and sending notifications are individually manageable, in a world where tools for these tasks exist online. Calendars, email, databases, Slack, and a collection of other apps and services make this possible.Continue reading “Claris Connect in action”
When I am working in the Bay Area, I often carpool to Beezwax’s Cupertino and Oakland offices with Vince Menanno, the creator and lead architect of InspectorPro. Over two years of commuting, I have been bugging him to add global search to InspectorPro, so FileMaker developers can search elements across the entire DDR for any solution. Vince must have gotten tired of my nagging, because at long last we can all enjoy this functionality, in InspectorPro 7.
Dear InspectorPro: Can you show me a report on the container fields used in my FileMaker solution, with a list of all externally-referenced vs. internally-stored (“embedded”) fields? Sincerely, Thanks in Advance-d.
Hello again from Tableau Conference 2019 in sunny Las Vegas! Here at Beezwax, we had 5 attendees this year with a diverse set of sessions between us. I wanted to give a rundown of what I went through and some of my takeaways.