Re: FileMakerPro to postgreSQL

Yes filemaker can use ODBC but not as a live data source as you would use
access as a frontend. You can use ODBC to import the data to a Filemaker
database and display/edit it there and then export back through ODBC.

If they use Filemaker to enter all the data (none is entered from the web
site) then you can setup a script to export the data through ODBC to update
the website. Either one record at a time after it is entered or as a batch
one or more times a day.

If information is entered into the website then you will also need a script
to import the data from the website database.

On 18/9/2006 11:58, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> brew(at)theMode(dot)com writes:
>> ... My biggest concern is the existing FileMakerPro clients. How much work
>> would it be to connect the existing FMP clients to the postgreSQL database
>> using ODBC? Is this a viable temporary step or could it be permanent?
>
> If they can speak ODBC, then in theory you can easily connect them to PG
> that way. There's a fair-size gap between theory and practice, however
> --- for example, the clients might be depending on some nonstandard SQL
> syntax. The only way to really check this out is to test the clients
> against PG and see what comes up. See the pgsql-odbc list archives for
> some examples of gotchas.
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>

--

Shane Ambler
Postgres(at)007Marketing(dot)com

Get Sheeky @ http://Sheeky.Biz