Great Plains Relationship map

[waely]

Hi,
we running great plains 5.5 with sql server 6.5 and we're trying to find the tables relationship. I'm not sure if we ever had that when we installed the software years ago. we really need to know our tables structure if anyone has any idea....

any suggestions?
thanks

 

[winthropdc]

Look at the pdf ERWin Entity Relationship diagrams which are installed with the SDK from the second CD of the Great Plains install discs.

David Musgrave
Senior Development Consultant
MBS Services - Asia Pacific

Microsoft Business Solutions

http://www.microsoft.com/BusinessSolutions

Any views contained within are my personal views and
not necessarily Microsoft Business Solutions policy.
This posting is provided "AS IS" with no warranties,
and confers no rights.

 

[waely]

I searched the 2nd CD but didn't find any pdf with that name or has the diagram.

please advise.
thanks

 

[Vergence]

We are running GP 7.5 and the new consultant asked me for the same thing. Where can I find a 'schema' or mapping for GP? He says the SDK isn't what he is looking for. Thanks, Ivan

 

[waely]

this is what I found online. go to

http://www.winthropdc.com/fr-training.html

you should find pdf file under Entity-Relationship Diagrams for Great Plains header.

hope that's helpful.

waely

 

[waely]

the links got scrwed up. here is the link:

http://www.winthropdc.com/fr-training.html

 

[winthropdc]

Winthrop Dexterity Consultants is my old company which is now run by my wife.

On the Training page of

http://www.winthropdc.com

you will find ER diagrams. These have been extracted from the SDK which you should find under Tools on CD2.

You will need to install the SDK to for the files to be extracted from the CAB.

David Musgrave
Senior Development Consultant
MBS Services - Asia Pacific

Microsoft Business Solutions

http://www.microsoft.com/BusinessSolutions

Any views contained within are my personal views and
not necessarily Microsoft Business Solutions policy.
This posting is provided "AS IS" with no warranties,
and confers no rights.

 

[waely]

I explored GP CD2 but there was not tools folder or any reference to tools or SDK. I ran the setup and got the following options to install:
Fixed Asset Management(sql)
Advanced purchase order(sql)
ServiceAdvantage Server
ServiceAdvantage Client
ServiceAdvantage MA
QuickCubes Server
QuickCubes Client

should I be installing any of those component to extract the Diagram?

thanks for help,
waely

 

[stef315]

Browse the contents of the CD using Windows Explorer.

 

[waely]

winthropdc,
I didn't find the Tools folder in my CD2, but if what you have on your website is exactly what I should get if I extract my SDK I will download and work with it.

let me know,
thanks

 

[winthropdc]

It looks like you are working with v5.5 which does have the SDK but not under a tools folder. It is located here on CD 2 D:\DSDK\SETUP.EXE.

I was going to suggest downloading from PartnerSource, but you won't find v5.5 materials there any more.

David Musgrave
Senior Development Consultant
MBS Services - Asia Pacific

Microsoft Business Solutions

http://www.microsoft.com/BusinessSolutions

Any views contained within are my personal views and
not necessarily Microsoft Business Solutions policy.
This posting is provided "AS IS" with no warranties,
and confers no rights.