Jump to content

Import from SQL


spongebob
 Share

This topic is 4385 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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!

Link to comment
Share on other sites

This topic is 4385 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.