Yes you can and it's really good. Only problem, of course, if finding your way around the Sage tables. Just install the Sage ODBC link and you're away.
If you find any sources of info about Sage table structure, please post the link!
Thanks for that! Much appreciated. I figured it could but thought I'd check just to be sure.
We have built a project management solution for one of our clients, which includes recording the job costs and generating monthly invoices as PDFs. They would like us to develop a solution that lets them easily add the data from these invoices into their Sage Accounts.
I have seen that some FileMaker solutions (e.g. http://www.filemaker.co.uk/solutions/customers/stories/unicol-engineering-manufacturing-database/ ) have used ODBC to interact with Sage - but I am yet to find anywhere that gives details regarding the configuration between FileMaker and Sage. I can't even find anywhere specifying version numbers!
I have setup the ODBC data source on the Server as a System DSN and tested it using Excel. However when I attempt to add it as a data source to FileMaker I receive the following error:
ODBC Error: Cannot find all files in data path
The driver returned invalid (or failed to return)
[Microsoft][ODBC Driver Manager] Driver's
SQL SetConnectAttr failed
[Microsoft][ODBC Driver Manager] The driver doesn't
support the version of ODBC behaviour that the
application requested (see SQLSetEnvAttr)
I would be very grateful if somebody knows a solution to this error? (e.g. I've configured it wrong) or can suggest/recommend an alternative solution for to integrate FileMaker with Sage.
Windows Server 2008 R2 Standard (64-Bit)
FileMaker Server Advanced 11 / FileMaker Pro 11v3
Sage 50 Accounts Professional 2012 (22.214.171.124)
Sage ODBC Line 50 v 18