Import from SQL

[spongebob]

Hi.

My client will install a Filemaker Server 11 under Windows Server.

The Database hosted on the server will import data from a windows SQL Server (a different computer) regularily into its database with a server side script on the FM Server.

Question: Do we need the normal version of Filemaker Server for that or the Filemaker Server ADVANCED version?

I always thought that the non advanced version can also get stuff out of an sql database?

Or am I mistaken?

thanks

Spongebob

[Russell Barlow]

Hi.

My client will install a Filemaker Server 11 under Windows Server.

The Database hosted on the server will import data from a windows SQL Server (a different computer) regularily into its database with a server side script on the FM Server.

Question: Do we need the normal version of Filemaker Server for that or the Filemaker Server ADVANCED version?

I always thought that the non advanced version can also get stuff out of an sql database?

Or am I mistaken?

thanks

Spongebob

http://www.filemaker.com/support/technologies/odbc.html

Reading that, it sounds like the Advanced version of Server is needed for LIVE links to an ODBC compatible database. I believe if your using server side scripting, this would be required.

If the importing was being done by the client, you do not need Server Advanced.

I may be wrong, but thats how I am interpreting the above link.

[bcooney]

FMSA is required to use FM as an ODBC data source. You're doing the opposite. FM is the client to the ODBC source. For that, you do not need FMSA.

Your other option, rather than import, is to set up a live connection to the ODBC source using FM's ESS technology.

[spongebob]

Great thanks, indeed, the source is SQL and Im only importing via a script once a day into Filemaker.

So I will get the NON Advanced version, thank you!