Filemaker and SQL

[Chris Wood]

Does anyone know of a way to pass data from a FilemakerPro v5 database to a web site using SQL without using Java applets.

Thanks in advance

Chris

[Kurt Knippel]

What do you mean? What do you need to do?

Do you mean SQL as in Structured Query Language, or as in SQL Server?

Filemaker can make data available to web pages via Web Companion and Filemaker Unlimited.

[Chris Wood]

CaptKurt,

Thanks for the reply. Here is the fuller story.

We maintain specification data on several thousand models of construction machine (like Caterpillar). Our databases contain up to 100 pieces of data on each model. So we have someting like 500,000 pieces of data. We are investigating two methods of on-line delivery of data. In both cases the user would be able to select a product type then select 3 or 4 models to compare.

Firstly is our own website based on Filemaker.

The second has been instigated by a client who will run his own website based on SQL server. For their system they require each piece of data to be a separate record, tagged with ID's for product type, attribute, unit of measurement and so on. I can do all of that in Filemaker and could output it in various ways (Excel or Access).

The question is whether or not there are methods of sucking that sort of data into SQL Server direct from Filemaker.

Regards,

Chris

[Kurt Knippel]

There are tons of ways to accomplish this. You could export the data from Filemaker and import into SQL Server; you could access the data via Web Companion in the same way that a web page would do; you could get data from Filemaker Unlimited v6 Web Companion via XML; you can use one of the many SQL plugins to retrieve data from Filemaker Pro.

None of these way use the actual Filemaker Server, since it is designed to serve to Filemaker, while Filemaker Unlimited is designed to make Filemaker's data accessible to the outside world.