ODBC write to FM table

[PBHolt]

We have an SQL database that stores shipping information from FedEx. Everytime a shipment is generated, the SQL table in the database is updated with that shipment's information. Once the data appears in the SQL table, is there a way to write the data from the SQL table to a table in FM as they appear in the SQL table?

Update on 02/24/2006: Found a topic about this very thing and all signs point to "not really". I read about a "robot" machine that Wim Decorte suggested and will look into that a little more.

Still will leave this topic open in case someone gets a spark of brilliance.

Edited February 24, 2006 by Guest

[Reed]

How is the data put into the SQL database? Whatever application does the INSERT INTO... command, could be set up to do the same SQL statement to a filemaker server via ODBC at the same time. You would have to basically mirror every database action for the SQL database onto the filemaker database this way.

That said, I use the "robot" machine that Wim suggested to sync our SQL server machine to my FM Server every 15 minutes... The data that I use doesn't really need to be updated any more frequently than 1 hour. (1 workday is fine in most cases...)

[PBHolt]

The data is written to the SQL database via a VB script that is created by a program run by the FedEx computer. Once a package is shipped, it is written to the SQL table. Subsequently, I would want that record written to a table in FM, in real time.

How have you setup your "robot" machine?