Why FileMaker? Pt.3

I’ve been working with FileMaker for over 20 years and the question that always arises is ‘Why do you use FileMaker?’ or ‘Is FileMaker the right platform to develop our database on?’.

This is part 3 in a series of blogs where I try and answer that question as best I can. Here are the links to the earlier parts of this thread: Part One ; Part Two.

Part 3: Integration.

We know it can handle the capacity, so what about the ability of FileMaker to ‘play well with others’. The last thing you want to do is design your database system to be an island, it needs to talk to other applications and perhaps work on multiple platforms. Again FileMaker fits well into most environments. From a desktop and server level FileMaker is designed to run cross-platform on both Windows and Macintosh operating systems. But it’s openness doesn’t stop there. FileMaker is designed to be as open as possible which is why it can export and import data in a variety of standard formats such as csv, tab delimited, Microsoft Merge and Microsoft Excel. Additionally FileMaker has adopted two main industry standards for external connectivity, XML and SQL.

FileMaker can export XML as standard and can also directly import XML, whilst allowing you to parse the data through an XSLT (style sheet). This can be particularly useful when dealing with online web services.

When you need to deal with other database systems, from accounts packages through to high-end enterprise level systems written in Oracle or Ms SQL Server, then ODBC / SQL connectivity is essential. FileMaker has two levels of support for ODBC, at a basic level you can run SQL queries on almost any ODBC data source, with the appropriate DSN drivers. A more advanced functionality is available if you want to connect to MySQL, Oracle or Ms SQL Server, called ESS or External SQL Source functionality.  This allows FileMaker to act as a front-end interface to any of these back-end systems, allowing you to embed a SQL table from any of the mentioned sources directly into the relational structure of FileMaker.  This offers an unprecedented level of integration and functionality.

So whether you just want to import a list of names in CSV, save your data out to Excel for reporting or integrate with high-end SL database systems, FileMaker offers the flexibility to provide an all round solutions.

Over the next few weeks I’ll be covering other areas of why FileMaker is a great database development platform for SME systems. So keep tuned for more instalments.
Paul de Hallé

Paul de Hallé

Paul de Hallé is the CEO and founder of Linear Blue, having set up the company in 1999 to focus on intuitive database solutions and web integration. Paul is a FileMaker Certified developer; and has also been a key player in the implementation of the FileMaker Certification program since it's inception with FileMaker 7. A regular guest speaker at FileMaker Business Alliance & Technet meetings in the UK and the FileMaker Developers Conference in the USA, along with contributing to various technical publications around the world.

More Posts - Website - LinkedIn

Leave a Reply