Subtitles of the Movie

In this movie, we'll conclude our discussion of the configuration of FileMaker Server 9 and FileMaker Server 9 Advanced. You'll notice we're in the configuration area and we're now at the ODBC and JDBC level. We're looking at the console running on OS X Server connected to FileMaker Server 9 Advanced running on the same machine. And we have in the ODBC JDBC connectivity a simple option to enable this connectivity and the first thing that we should know about this is that this requires the Advanced version of FileMaker Server 9 in order for this capability to be used. When we check this option, what we're doing is allowing other programs, such as spreadsheets, word processors, reporting tools and other daemons and services to connect to FileMaker data hosted by FileMaker Server Advanced using either ODBC or JDBC. There's an ODBC plug-in and a JDBC plug-in that comes with FileMaker Server 9 Advanced and they have to be installed in the appropriate extensions directory in that FileMaker Server library at the root level that we've seen in other movies. What we need to do here, though, is to distinguish and differentiate carefully between this capability where FileMaker Server and FileMaker Pro are the source of the data and the new external sequel server capability in FileMaker Pro 9 and FileMaker Server 9. The new ESS capability is a situation where FileMaker Pro is accessing data in a foreign, hence the phrase external, database system such as Oracle or MySQL. Such a configuration for external sequel sources can be managed by FileMaker Server, but it should not be confused with this ODBC and JDBC capability. FileMaker Server 9 and FileMaker Server 9 Advanced both support the configuration for external sequel sources and, in fact, by configuring the connection to come through the server, administrators are spared the task of having to install the various sequel drivers on all of the particular workstations. This capability, however, which required ODBC and JDBC connectivity is for the use of FileMaker Server as a source, whereas the external capability is for FileMaker to be a consumer of the external data. They are in essence mirror images of one another and there is extensive documentation that comes with the FileMaker Server product on the ODBC JDBC capabilities, as well as documentation from FileMaker Inc. related to the external sequel sources capability and I recommend a review of these particular documents if you or your administrators are thinking about using these particular functions. So let's review briefly what we've learned in this particular movie. We've learned that we can enable connectivity by ODBC or JDBC to databases hosted by FileMaker Server for the consumption of that FileMaker data by other applications such as spreadsheets, word processors, reporting tools and other services or daemons and that we distinguish this capability in FileMaker Server 9 Advanced from the new external sequel sources capability in FileMaker Pro 9 and FileMaker Server 9 and that capability is supported both in FileMaker Server 9 and in the Advanced version. But we distinguish that from the capability of FileMaker Server to be the source of such data. he Advanced version. But we distinguish that from the capability of FileMaker Server to be the source of such data.