O'Reilly logo

FileMaker® 12 Developers Reference: Functions, Scripts, Commands, and Grammars by Scott Love, Dawn Heady, Bob Bowers, Steve Lane

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 19. JDBC/ODBC and External SQL Connectivity

A FileMaker system can act as a data source for external access via Open Database Connectivity (ODBC) or Java Database Connectivity (JDBC). Likewise, using the external SQL sources (ESS) feature, FileMaker solutions can gain direct access to data in certain SQL-based database systems. FileMaker also supports the ability to import records from an ODBC data source and to execute SQL statements against remote data sources using the Execute SQL script step.

This chapter discusses how to make a FileMaker database available for external access from ODBC or JDBC. It also covers how to set up a Data Source Name (DSN), on both the Mac OS and Windows, for use with the ESS, Import ODBC, and Execute SQL ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required