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

Video created by mark_baum on Sep 3, 2015

    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 Materials