Use Python and ODBC to run super fast statistical analysis on FileMaker

Discussion created by mikebeargie Expert on May 11, 2017
Latest reply on May 12, 2017 by mikebeargie

One of our members at COFMUG gave this great presentation last month and I wanted to post it here as a resource to share.


In the demo, he shows how to setup an ODBC DSN, then utilize python to load data from FileMaker. Once loaded, he can instantly perform numerous high-level aggregate functions and statistics on the entire data set.


Python is on the fringe for FileMaker developers, but it's a great simple language to learn that is a good addition to anyone's toolkit.



COFMUG April 2017 - Use Python to perform statistical analysis on FileMaker data! - YouTube




Message was edited by: Mike Beargie - Corrected YouTube video link.