paul_tuckey

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.

 

Paul

Outcomes