DB schema documentation for Vista 8.03 (now Epicor)

Vista/Vantage 8
1

Can someone point us to, or share, DB schema documentation re: the Progress DB used on a Vista 8.03.305L install?

This is for a small machine shop with a Vista 8.03.305L and it needs to run scripts to extract data from the Progress DB. We can read data, but we don't know table and field names. Guidance appreciated.

2

hi PJ,
There is inside vista… (maybe) a program called Data Dictionary which you can run and talks you through the different fields in the system.

There was an old one hosted by @jgiese.wci I don’t think he has it any more

But Data Dictionary within Vista should give you what you need.

1 Like
3

https://epidd.wcibags.com/

2 Likes
4

I stand corrected he still has it.! Mind you this is for version 9 I believe however the Schema is not that drastically different.

5

Thank you.

6

Good morning Joshua. That resource you had was absolutely perfect! It seems like the subdomain epidd does not exist anymore though. 404 on that page.

7

Unfortunately it hit that age where the data was less and less relevant for the general populace and the technology running it was more and more risky from a security risk aspect, so we made the decision to axe it internally.

2 Likes
8

Understandable. I feel bad asking, any other way of receiving this information? Even screenshots would suffice. Your resource was the “keys to the castle” for the old progress database schema. If not I understand. Thank you for providing it to begin with!

9

Here is the zip package of the html files for the EpiDD site before we shut it down. I removed the ERD section that showed table images, because it was way too large of file and overall not super useful.

Enjoy

EpiDD.zip (3.8 MB)

2 Likes
10

Thank you so much! It truly is such a huge resource for us few still clinging onto v8. Thank you again and have a nice day.

11

Dos this exist for Epicor 10?

image001.png

12

I think this may be what you are looking for

13

Thank you so much, YES……

image001.png

1 Like
14

I built a dashboard in 10+ that does the same thing this old HTML did for 9. All the field defs are in the DB in ZDataTable, ZDataField, and zDataSet including UD.

DBExplorerTool.dbd (594.2 KB)

2 Likes
15

This is GREAT. Thanks SO MUCH!!