So far in this blog, we’ve mentioned a couple of ways that Legato can improve or replace existing functionality and add new features entirely to GoFiler through the use of hooks that can happen pre- or post-process on a GoFiler function or by hooking a script to custom menu items. Now we’ll talk about a third method of enhancing GoFiler’s functionality.

One of the most powerful tools in Legato is the ability to utilize an ODBC Connector to pull information from a database. ODBC (Open Database Connectivity) is a standard interface included in Windows that lets you connect to any type of database. Other applications (such as GoFiler through Legato) can talk to the database using this ODBC interface as an intermediary. This week’s blog post will be discussing ODBC, what it is, how to set it up, and what it can do for you. Next week we will explore an example where Legato actually uses it.