SQL Server no relation database
SQL and ODBC support
Since version 9, FileMaker has had the ability to connect to a number of SQL databases without resorting to using SQL, including MySQL, SQL Server, and Oracle. This requires installation of the SQL database ODBC driver (in many cases a third-party license per client driver) to connect to a SQL database. Through Extended SQL Services (ESS), SQL databases can be used as data sources in FileMaker's relationship graph, thus allowing the developer to create new layouts based on the SQL database; create, edit, and delete SQL records via FileMaker layouts and functions; and reference SQL fields in FileMaker calculations and script steps. It is a cross-platform relational database application.
Versions from FileMaker Pro 5.5 onwards also have an ODBC interface.
FileMaker 12 introduced a new function, ExecuteSQL, which allows the user to perform an SQL query against the FileMaker database to retrieve data, but does not allow data modification or deletion, or schema changes.FileMaker allows non-numeric characters to be stored in its "numeric" field type unless the field is specifically marked as strictly "numeric".
Through a third party, Actual Technologies, FileMaker 15 and forward ,also, support ODBC connectivity to IBM I 7.3 (AS/400), IBM Db2 11.1, and PostgreSQL 9.6.12. Using the Actual Adapter, these ODBC connections can also make ESS connections and be used as sources in the Relationship Graph.
no relation