WebDirect unable to access databases on other servers

[dwjones]

WebDirect doesn’t allow relationships to databases on other servers, nor importing of data except via Excel. I have a Filemaker server in our DMZ – the idea is that users can update their personal details over the web. But as their personal details can change frequently in the master database on an internal server, there needs to be a way to automatically keep the DMZ database synced so that the up-to-date info is displayed.

 

Any ideas?

 

Thanks in advance.

David

[Ocean West]

Hi David,

 

how about MirrorSync server to server 

 

http://360works.com/filemaker-sync/

[dwjones]

Thanks Stephen, it looks like a good (but costly) solution. 

I'm still interested in any other techniques that people know of.

Regards

David

[dwjones]

Ok, how about this for an idea.

On the DMZ server, open the database (via Open Remote to localhost) using the installed Filemaker client and keep it permanently open. Use Install on Timer script to force synchronisation every hour or so.

 

Not ideal as it relies on the database remaining open, but it should work by my thinking. Any comments?

David

[Charles Delfs]

Good Day,

Have you made any progress with this issue?

 

I have a similar deployment where the main db is on server A and WD interface file is on Server B

 

 

Charles