Jump to content

ODBC


rudym88

This topic is 2766 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

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

This topic is 2766 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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.