Building a custom Tableau® Connector for Claris® FileMaker® enables faster, more reliable and more flexible connections between Tableau and FileMaker datasources, compared with the legacy Web Data Connector.
For a number of Beezwax client projects, we’ve installed and deployed a Tableau Connector (aka “TACO”) for FileMaker. The TACO was built using the Tableau Connector SDK (provided by Tableau) to connect to datasources on FileMaker Server. The TACO method uses JDBC rather than the FileMaker Data API for the connection between FileMaker and Tableau, and in our testing the performance of data extracts was up to 10 times faster.
Continue reading “A fast, flexible Tableau Connector for FileMaker”
Let’s talk about Claris® FileMaker® and transactions! Vincenzo Menanno discusses what transactions are, how they relate to FileMaker data operations (creating, updating, and deleting records), database normalization, and how to use transactional concepts to improve FileMaker performance, especially over a wide area network (WAN).
Continue reading “The Value and Benefits of Transactions with Claris FileMaker”
We are pleased to release bBox version 0.98, with with new image file functions and M1/Apple Silicon support.
Some of the changes in version 0.98 are:
- M1/Apple Silicon binary
- Ubuntu compatible version (in addition to CentOS)
- updated to libxml2 version 2.9.12
- added bBox_GraphicsMagick function & script step
- added bBox_Sips function & script step
- modifications to several functions & script steps to add parameters
- fixed template text used in several functions & script steps to better describe parameters
- limit POSIX commands to 3 cores
- new mode to combine stderr with stdout
Continue reading “bBox for FileMaker v0.98 with M1, GraphicsMagick & Sips”
When the Apple silicon Macs with M1 chips came out, I read and watched many of the reviews. Most of them had great things to say about the promise of Apple’s new M1 chip…I was impressed. When I finally received my Apple M1 MacBook Pro, and started to use it…I was amazed.
Back in 2020, FileMaker Pro 19.2 wasn’t optimized yet for Apple silicon processors, but ran fine under Rosetta emulation. On my M1 MacBook Pro, it already felt much faster than running FileMaker “natively” on an Intel-based MacBook…I was astonished.
Today, I’m running the just-released Claris FileMaker® 19.3, with native support for Apple’s M1 chip, on a new MacBook Pro. It is, in a word: Astounding!
Continue reading “FileMaker Performance on Apple M1 | Astounding!”
Everything about the M1 Apple silicon leaves you simply delighted and surprised. It’s like the first time you drive a super-charged Tesla and feel the rush of powerful acceleration OR I imagine it’s like when Han Solo first blasts the Falcon into light speed: it must be experienced to be believed.
Continue reading “InspectorPro 7.2 for FileMaker – Faster on M1!”
This blog post is the second of a three-part series about the FileMaker OData API, introducing a demo file with more than 40 examples plus helpful tips, along with Q&A. Part one of the series highlighted some of the key features of the API which make it an exciting addition to the FileMaker platform. As a follow-up, this post will cover the basics and dig into the nuances of using OData with Claris FileMaker.
Continue reading “OData for FileMaker – Examples, Tips and Nuances”
This blog post is the first in a three-part series about the FileMaker OData API, highlighting key features that make it an exciting addition to the Claris FileMaker platform.
Continue reading “OData for FileMaker – New Player in an Old Game”
FileMaker 19 introduced a couple of important new features related to using the FileMaker Data API. Here, we’ll cover an overview of the new authorization endpoint,
Validate Session, API versioning updates, as well as a new script step,
Execute FileMaker Data API.
At the end of this article, you’ll find the demo file for learning more and trying out various REST and cURL functionality with FileMaker’s Data API. Enjoy!
Continue reading “Using REST and cURL with FileMaker’s Data API”
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”
Continue reading “bBox for FileMaker v0.95 Now Available”
On our FileMaker Cloud for AWS servers, which are currently CentOS 7.6 based, we are typically installing the Zabbix monitoring agent. With one exception, installing the Zabbix agent is a relatively quick and easy procedure.
Although not required, installing the agent allows gathering more data on your servers than a Zabbix server alone.
Continue reading “Installing the Zabbix 4.2 Monitoring Agent”
Combining functions, features, or steps in creative new ways can deliver productive results. I was thrilled to discover in FileMaker 18 that the new file-based script steps give us the ability to perform imports natively on FileMaker Server, with no configuration or changes needed.
Continue reading “Imports without Tariffs. Natively, with FileMaker Server.”
Well, here we are again! With the release of FileMaker 18 we get the third version of the FileMaker Data API. This version brings an iterative advancement in features while maintaining the core functionality that was introduced with V1 of the API in FileMaker Server 17.
I’m following suit with an iterative advancement of my previous blog posts about the Data API (here and here).
NOTE: We’ve updated this series of blog posts and demo files to cover FileMaker 19:
Using REST and cURL with FileMaker 19’s Data API Continue reading “Using REST and cURL with FileMaker Server 18’s Data API”
“Hey Siri…Ask FileMaker…”
This story started when we explored iOS Shortcuts to the FileMaker Data API. As we continue to automate tasks by mixing together iOS apps, content on mobile devices and web APIs plus FileMaker, let’s add to our workflow using one of the most powerful functions available to iPhone and iPad users: Siri.
Continue reading “Using Siri with FileMaker, via iOS Shortcuts”
Introducing Admin FM – the Zapier integration for accessing the FileMaker ® Admin API in an easy, customizable way. Built using Node.js, this version of Admin FM is currently a beta version, but it allows you to access most of the functionality that the FileMaker Admin API allows.
Continue reading “Introducing Admin FM – the FileMaker Admin API for Zapier”
We support quite a few macOS systems that are bound to an AD (Active Directory) domain. Occasionally, one, two, or perhaps several would lose the ability to authenticate users with AD credentials. Often this was with one of the FileMaker Servers, where external authentication was being used for either user access or FMS Admin Console access. I’ve explored ways to fix this, without restarting or disrupting other services.
Continue reading “AD-bound macOS systems not authenticating? Restart opendirectoryd”
Continue reading “bBox for FileMaker v0.90 Now Available”
Now that the FileMaker Data API has been officially released (with FileMaker 17), it is time to share an update on Tableau-to-FileMaker integration. I originally wrote about integrating Tableau and FileMaker to create a match made in data heaven. I’ll also be speaking on “FileMaker + Tableau” at FileMaker DevCon 2018.
Continue reading “FileMaker to Tableau | The Learning Journey”
If you have a FileMaker server that you want to ensure high availability, Amazon’s AWS Route 53 service has some functionality that you’ll want to know about. For this post, I’m going to show how you can set up monitoring and alarms for the XML interface on FileMaker Server.
Continue reading “Monitor FileMaker Server XML connectivity with AWS”