rudym88 Posted September 25, 2016 Share Posted September 25, 2016 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 Link to comment Share on other sites More sharing options...
Devin Posted September 25, 2016 Share Posted September 25, 2016 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. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 2762 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now