AnsweredAssumed Answered

ODBC Connection to Great Plains SQL Data

Question asked by TKnTexas55 on Mar 21, 2017
Latest reply on Apr 17, 2017 by TKnTexas55

I have a number of solutions, working around the deficiencies of our accounting software-Microsoft Great Plains (v2010).  I have been using a number of GP-SmartLists to extract data and upload to my Filemaker files. After a presentation at a local FMPUG, I got authorization to use ODBC to connect. 

 

 

I did so, with the assistance of our Great Plains Administrator.  He uses Crystal Reports to connect to the files.  When we connected, we did not see the expected data tables.  We saw "something" but they were not data tables.  Has anyone else used FileMaker Pro to connect to Great Plains?  I have the ODBC 64bit driver on the System Tab

 

The GP Admin inserted his User ID and Password for the connection.  I am just sure where to go from here.  My Great Plains VAR says "I don't know FileMaker". 

Outcomes