We upgraded our accounting software to Great Plains 2015 from Great Plains 2010. I want to be able to query the SQL tables directly, create some relationships between tables. I was able to do this in GP2010. When I try to do it, I do not get the datatables. The Great Plains Administrator is trying to help me, but he does not know FileMaker Pro. We are using Ver17.
This is the ODBC connections I have on my computer. The SQL Server Native Client 11.0 are for the GP2015, Ver10 is for the old GP2010.
I have a blank table, that I want to create the TOs for the data I need.
I open Manage External Data Sources. Click New
I am only see three sources. The two GP2015 I am seeing are the two created weeks ago, when we upgraded. The two I created today are not showing. Any thoughts or suggestions from ODBC experts?