SQL Server to FileMaker Server 13

Discussion created by paul_tuckey on Mar 2, 2014
Latest reply on Mar 3, 2014 by lkeyes

Hi Forum


I have a project coming up where I need to update a file hosted on FileMaker Server 13 (running on OS X 10.9) with data coming from MS SQL Server via ODBC.


To achieve this is it practical to use FileMaker Server 13s native ODBC capability where Im using FMS13 as a datasource, or will I need a more exotic configuration using the Actual SQL Server ODBC drivers and adding an External SQL Source in the relationship graph.


Preferably I would prefer the former where I hope I can use the basic SQL INSERT INTO, SELECT, UPDATE and DELETE commands to update a FileMaker table as this negates the need for additional drivers (on OS X).


Any advice and guidance as ever much appreciated.