DevCon 2015: Introduction to SQL and ODBC for FileMaker Developers - Greg Lane

Document created by communitymanager on May 27, 2015Last modified by mark_baum on Sep 3, 2015
Version 7Show Document
  • View in full screen mode

Greg Lane (Skeleton Key)

Session Description

The FileMaker Platform includes a rich set of SQL related features for sharing data with other applications and database systems. This session is intended for any FileMaker developer who needs to gain a fundamental understanding of ODBC, SQL, and ESS and how these technologies can be used to make your organization’s data more valuable. We’ll unravel the acronyms and demonstrate practical examples of how to access information in other database systems from FileMaker and how to access information in FileMaker from other systems. Learn the pros and cons of each of the different SQL related capabilities FileMaker has to offer.

What you should know

This session assumes no prior knowledge of ODBC or SQL. Experience with FileMaker Pro (including managing databases, managing accounts, and writing scripts) is recommended.

Products & Technologies

  • xDBC
  • FileMaker Server
  • FileMaker Pro
  • FileMaker Pro Advanced

What You Will Learn

  • The fundamentals of ODBC, SQL, and ESS and when each of the technologies can be used
  • See specific examples that show how to configure and use each of FileMaker’s ODBC technologies
  • How to use each of the basic SQL statements
  • Explore techniques using the ExecuteSQL function to simplify your relationship graphs


View Session Recording