ODBC

[rudym88]

Good morning,

Having absolutely no knowledge on ODBC integration with Filemaker I am seeking help for the community gurus. I put together a database to keep track of printing jobs and so far its working fine for us. The issue I have now is that some of the data we enter in FM comes from out ERP (sage 200 4.3) and I would like to create a lookup that would retrieve this data via ODBC.  We use filemaker server and FM 2013 for the end-users.

 

I have the following questions.

1 - do I have to installed the Sage client on the server or do I have to have on each user?

2 - when I configure the ODBC do I configure it on each client or only on the server t retrieve the data from sage?

 

Any pointers to ingrate with Sage would be greatly appreciated.

 

Thanks in advance for your assistance.

 

RudyM

[Devin]

I'm not familiar sage, Your going to need to know what DB it's running and version so that you can have the correct version of driver installed on the Filemaker side.

You also may want to look and see if they have an API for integrating. Using the API can be a safer way to integrate.