Re: CASE Tools for Informix ?

I assume you're lookign for a modeler that will also generate your DB for you. There are a number of options. * Silverrun creates DB modeling and business re-engineering software custom-made for Informix's product line. * LogicWorks markets ERWin/ERx, a featureful (and very expensive) DB modeler for Win95/WinNT. * Visible Corp. publishes EasyER, a very cheaper (~$700) modeling tool. I was not very impressed with the evaluation copy I used, however - very clumsy interface and buggy features. * Embarcadero makes ER/Studio, a very fast, mostly intuitive modeler for Windows that holds a middle ground in price between EasyER and ERwin. I've used this tool the most, and really like it. One nice feature is the ability to generate multiple physical diagrams from a single logical source, and effortlessly merge changes later on. All these tools use standard database modeling diagrams (i.e., either IE or IDEF1X). Some of them promise to help you manage your entire project, including your stored procedure code. Most of them can generate SQL for a vast variety of DBs (including Informix), or connect directly to your DB using ODBC. And, of course, every vendor includes their own special perks (e.g., ER/Studio comes with a nice DB-independent SQL composition and query app). There are others besides this, but these are the only ones I've given serious consideration. For a comparison of all the major tools, check out http://www.aisintl.com/, an independent site run by an information systems consulting firm. Vendor URLs: Visible: http://www.visible.com/ Embarcadero: http://www.embarcadero.com/ Logic Works: http://www.logicworks.com/ Silverrun: http://www.silverrun.com/ -J- } } Hi ! } } A "CASE tool" means different things to different people. It would help } if you specify what your client requires from a 'CASE tool'. } } A proper CASE tool would allow a user to choose a design paradigm ( } UML, Fusion, OMT, etc.. ), build various models that are included in } that paradigm, interchange between design paradigms, even generate } code. These tools are language independent. } } The industry leaders for good case tools are Platinum's Paradigm Plus } and Rational's Rose. } } However, you ask for "CASE tools for Informix". I guess what your } client is looking for is some kind of graphical tool to keep track of } E-R diagrams, table schema and generate these and build the database. } There are many tools out there that you could use. Try using, } S-Designer. } } } Hope this helps } } Chaminda Peries } } } ---------- } From: Marty Eichelman[SMTP:eich@erols.com] } Sent: Friday, October 31, 1997 10:05 AM } To: informix-list@rmy.emory.edu } Subject: CASE Tools for Informix ? } } } Could someone please recommend a couple of good CASE tools for } Informix. I } need to give the options to the client, and haven't used } Informix myself. } } I appreciate your help. } } TIA, } } Marty } } } } -+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+ } -+ } } Marty Eichelman, Jr. } eich@erols.com } http://www.erols.com/eich } Software Engineering Consultant } } - - Anyone without a sense of humor is at the mercy of the rest } of us - - }