How to establish an ODBC Connection

I am very new to Great Plains Dynamics and am trying to figure out my tools.

The two previous software systems I have used allowed the IT Department to establish an ODBC Connection so I could query our data rather than have to use the canned reporting tools.

What is my best option using GP Dynamics? Is there a document on how to establish the connection? I can see it from within Excel Query but I do not know the password. Any ideas would be appreciated.

We are running the newest version 2013

Thanks!

hi,

follow http://www.azurecurve.co.uk/2012/09/how-to-create-an-odbc-for-microsoft-dynamics-gp-2010/

regards

p.s.: this is the NAV forum. :wink:

for GP forum follow http://dynamicsuser.net/forums/TopicsActive.aspx?ForumID=&GroupID=6

Thank you! I appreciate the response and the help.[:D]