From the course: FileMaker: Tips, Tricks, and Techniques
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Connecting via external SQL sources - FileMaker Pro Tutorial
From the course: FileMaker: Tips, Tricks, and Techniques
Connecting via external SQL sources
- ESS or External SQL Sources, is best described as a tool that allows FileMaker apps to access information stored in other database systems. It's not intended to increase the scalability of FileMaker apps. In fact, its existence means that we don't have to be concerned about the scalability of FileMaker apps, because FileMaker can connect persistently to enterprise level database stores. It's not meant that FileMaker should just exclusively be a "front end" without any of its own data, it's meant that you can integrate data from other sources live into the workflow of your existing FileMaker custom apps. It's really about integration, allowing seamless integration of FileMaker data and workflow with data stored in these SQL databases. ESS uses an ODBC connection via a DSN or a data source name that's already been set up on a FileMaker server. In a previous movie, I showed you how to set up a DSN on your local machine,…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.