On the off chance you’ve been hiding under an old Microsoft Access box for the last couple weeks, let me be the first to tell you that FileMaker now supports direct links to SQL databases. In other words, you can use table from a [MySql], [Oracle], or [Microsoft SQL Server] database right in FileMaker with no synchronization, no imports, and *no messy SQL programming*. This is A Big Dealâ„¢ and many of you are justifiably very excited about it.
And you probably have one burning question: “How the heck do I set this thing up?” The sad truth is that, for reasons well beyond FileMaker’s control, setting up a connection to a SQL database is the opposite of simple. Here’s the skinny on how to get your FileMaker database talking to a SQL database in as few steps as possible.