Re: Case Tools
Posted in 1994
Topics: Triggers, Constraints & Referential Integrity
Medha Pai (shonoo@Netaxs.com) wrote: : John Dennis (jdennis@netcom.com) wrote: : : My company is a small company quickly turning into a large one. We have : : no case tool or methodolgy in place. Our current "case tool" is ERWin : : and MS-Word. Not pretty! We are looking at IDE's Software through Pictures. : : I was wondering if: : : 1) anyone has had postive or negative experience with this : : case tool? and : : 2) if there was some other case tool that we might consider? : You may want to consider LBMS, System Architect, and bachman. : Bachman is a primarily a data modelling tool, and from what I have seen : the reporting capabilities are not as good as Erwin. : LBMS and System Architect are both process modelling tools, with : significant learning curves. : Systems Architect supports several methodologies, while LBMS supports : only one. Also LBMS does not generate triggers . For some one used : to ErWin the data modelling capabilities of LBMS are no substitute. : Hope this helps : : Specs: : : * We use ORACLE, SYBASE and INFORMIX (Erwin supports all of these) : : * We use several front-end tools like SQL-Windows, : : Powerbuilder and Motif. : : Thanks for any input as this will help us out big time. : : John Dennis In addition to the above, Excelator by INTERSOLV is also a good candidate. Excelator also supports process modelling. It also produces SYBASE and ORACLE database creation scripts. I am not sure about INFORMIX. I personally found it very easy to use.