FMP as datasource

[youtz]

Hello,

I need to get some data from FMP7 to an oracle database, I was thinking of using ODBC but I can't make it work.

Is it possible to access the fmp7 data from ODBC without opening the files I want to access?

I installed the ODBC on the FMP server but it still doesn't work.

Has someone successfully accessed FMP7 data through ODBC ?

If not possible, is it possible to export data from FMP7 by batch (without human action)?

Thank you in advance for your help,

Olivier.

[Wim Decorte]

Welcome!

It can be done, so we need to figure out what is not working on your end.

FMP (as in 'not FMS') can be a data source only on the local machine. You can't make an ODBC connection to a copy of FM Pro from a remote machine.

If you need to touch FM data from a remote server you need to go through FileMaker Server Advanced. Regular FileMaker Server doesn't allow you to do it, you need Advanced. Then you need to install the FM ODBC drivers on the machine from where you want to pull FM data.

Let's take it from here: where are you in all of that?

[youtz]

We have file maker server 7 (not advanced).

We have 4 FMP7 clients.

I need to integrate regularly the data they are working with in an oracle application.

If needed the connection to filemaker data can be done on the server hosting FMS.

I tried to install an odbc connexion directly on the server but it also didn't work.

drivers : sequelink

server : localhost port : 2399

--> connection refused.

If I do the same on my computer and open the file with FMP it works.

---------

If it's easier, would it be possible to create a batch on the server to export the data to CSV or XML, I would then use an ETL to load it ?

Best regards,

Olivier

[Wim Decorte]

If you don't have FMS Advanced then intalling the ODBC driver won't help. Server won't allow any connections.

You can't do a batch process on the server either. You really need FileMaker Server Advanced for any kind of server-side interaction.

It works on your local machine because it's all local. FileMaker Pro allows for 5 local xDBC connections. None from a remote machine. So you could set up a "robot" machine for your purpose and run everything on that machine unattended.