Hi Dear Friends, I didn't take care of this project for a couple of months. I'm sorry, the tools aren't for free anymore. The time for sharing and asking for feedback is closed now since I shared the software with 20 friends and then I just got feedback from 2 of them (Thanks Mike and Richard). So I'll commerce the tool through www.erptoolbelt.com site. Also, I'm open for selling the full project (source code included) serious offers to hsanguino@erptoolbelt.com.
Thanks,
Hugo.
---------------------
Whether you are a Final User, Consultant, DBA or a Developer, you benefit from using tools that help you work better, no doubt, that’s why I always take Saturdays to create those tools which can help me to go faster when doing my work along the week, sadly I’m always busy and have no time to publish all of them, but talking with some respected friends of mine Mike Harms and John Kirwin, I realized that maybe some tools would help to create a nice community sharing opportunity. And I think the Schema Analyzer for MAS 500 ERP is the simplest and most effective way to start it.
Introducing Schema Analyzer for MAS 500 ERP

Watch it in action!

• Originally Created for a Developer trying to understand the MAS 500 Database Schema
• Now Customized for those who aren’t developers but want explode the most of the Database Schema
• Graphics always help make the things easier.
• Completely intuitive, easy to use, it does what you need to get the knowledge
• Full support for SQL Server 2005*
The Schema Analyzer for MAS 500 ERP allows Developers, Consultants and Advanced users to gain access to ALL the MAS 500 Database Schema in a graphic way including new Tables added by using the SDK Visual Tools. This means that when you are working with MAS 500 databases, repots, APIs, Add-ons, etc, you can finally have the most powerful tool right there to hand to help yourself to solve those doubts regard Database Schema.
Why another Schema Tool?
This one uses a “Graphical Exploring” method which plays several key roles in Analytics:
- Help to finding patterns in raw data which can be a challenge, especially with complex data sets.
- Help to understanding and making sense of a set of data, besides help finding patterns in it.
- Clear presentation of results to others and of course oneself!
VAR Case 1
Let say you added some new tables to the database and the customer wants to see them in the Schema Browser like the rest of the SAGE tables. We know that the Hyper Schema Text/documents were created through the product called "ERWIN". If you purchase this expensive and complex CASE tool, maybe you could then use it to re-generate the hypertext model currently provided by SAGE and update the hyper text to reflect the new tables. But, if you don't plan on creating extensive schema modifications, I would recommend pick Schema Analyzer up which automatically recognize all new tables imported through MAS 500 Data Dictionary Tools.
VAR Case 2
We know the classic scene where Consultants assist customers with modifying or creating crystal reports or otherwise interface with MAS500 and they find the schema browser difficult. Schema Analyzer for MAS 500 would help since it exposes the table structure including definition information and the linking; besides it allows creating Notes, and the purpose of it is that interconnected people could be able to put their own “knowledge” in there, and then make that available to others.
Regards,
Hugo Sanguino
