ER Modeling Tool Capable of Working with Informix

I am trying to find a tool that will allow me to import or connect to an Informix instance/database and capture the schema for use in both documenting and assist in the training of new personnel to our multiple databases. I recently downloaded the ER/Modeling tool "Embarcadero ERStudio 7.0" since it stated on its download page it was capable of working with Informix; however, within the tool I can find no mention of Informix databases at all :( Any assistance would be appreciated. Take care. Clifton _______________________________________________ Join Excite! - http://www.excite.com The most personalized portal on the Web!

I have used both Visio Professional and Erwin before with Informix. I prefer Erwin much better. You have more control over where the lines are placed. Erwin is not cheap though. Last time I looked it was close to $4000. Lennie > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org]On Behalf Of > clifbean@ex.... > Sent: Friday, March 03, 2006 2:27 PM > To: ids@iiug.org > Subject: ER Modeling Tool Capable of Working with Informix [6467] > > > > I am trying to find a tool that will allow me to import or > connect to an > Informix instance/database and capture the schema for use in > both documenting > and assist in the training of new personnel to our multiple > databases. > > I recently downloaded the ER/Modeling tool "Embarcadero > ERStudio 7.0" since it > stated on its download page it was capable of working with > Informix; however, > within the tool I can find no mention of Informix databases at all :( > > Any assistance would be appreciated. > > Take care. > Clifton > > _______________________________________________ > Join Excite! - http://www.excite.com > The most personalized portal on the Web! > > > ************************************************************** > ***************** > Forum Note: Use "Reply" to post a response in the discussion forum. >

I don't know about free ones, but three tools that I've used before with Informix successfully are: ERwin (from Computer Associates) PowerDesigner (from Sybase) and SilverRun (from Applied Information Science) They are all good tools, and all have good features, but none of these is free. I'd suggest taking a look at SilverRun. It may be a bit less expensive than the others, but has full functionality. HTH... Mike -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- Mike Lowe IBM DB2 Information Management Education Home Office: 303.225.5440 Fax: 303.224.5440 Tie Line 273-2438 Web: http://www.ibm.com/software/data email: mike.lowe@us.ibm.com I am trying to find a tool that will allow me to import or connect to an Informix instance/database and capture the schema for use in both documenting and assist in the training of new personnel to our multiple databases. I recently downloaded the ER/Modeling tool "Embarcadero ERStudio 7.0" since it stated on its download page it was capable of working with Informix; however, within the tool I can find no mention of Informix databases at all :( Any assistance would be appreciated. Take care. Clifton _______________________________________________ Join Excite! - http://www.excite.com The most personalized portal on the Web! ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

We use ERStudio with informix, and we're pretty happy with it. After a little bit of tweaking (you have to remember to change char(10) to boolean, blob/clob, etc... after reverse engineering), we have no real problems with it. It generates lovely html reports that we use as documentation for our staff. You can post comments on each table, column, relationship. We also evaluated ERWin and PowerDesigner before we chose ERStudio. We liked ERWin a lot too, but the price (for the tools) was too high compared with ERStudio. I don't really use it to do data modeling, but for documentation and as a training tool, I've found that its enough. Sierra M. On Fri, 3 Mar 2006, clifbean@ex.... wrote: > > I am trying to find a tool that will allow me to import or connect to an > Informix instance/database and capture the schema for use in both documenting > and assist in the training of new personnel to our multiple databases. > > I recently downloaded the ER/Modeling tool "Embarcadero ERStudio 7.0" since it > stated on its download page it was capable of working with Informix; however, > within the tool I can find no mention of Informix databases at all :( > > Any assistance would be appreciated. > > Take care. > Clifton > > _______________________________________________ > Join Excite! - http://www.excite.com > The most personalized portal on the Web! > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >

Thank you for responding. What version do you have of the package? I cannot find anything within version 7.0 that mentions Informix. I had heard good things about it in the past and wanted to use it but ran into the roadblock noted in my email. Take care.Clifton --- On Fri 03/03, Sierra A.T..... < staylor@cs.uoregon.edu > wrote:From: Sierra A.T..... [mailto: staylor@cs.uoregon.edu]To: ids@iiug.orgDate: Fri, 3 Mar 2006 16:15:21 -0500 (EST)Subject: Re: ER Modeling Tool Capable of Working with I.... [6472]We use ERStudio with informix, and we're pretty happy with it. After a little bit of tweaking (you have to remember to change char(10) to boolean, blob/clob, etc... after reverse engineering), we have no real problems with it. It generates lovely html reports that we use as documentation for our staff. You can post comments on each table, column, relationship. We also evaluated ERWin and PowerDesigner before we chose ERStudio. We liked ERWin a lot too, but the price (for the tools) was too high compared with ERStudio. I don't really use it to do data modeling, but for documentation and as a training tool, I've found that its enough. Sierra M. On Fri, 3 Mar 2006, clifbean@ex.... wrote: > > I am trying to find a tool that will allow me to import or connect to an > Informix instance/database and capture the schema for use in both documenting > and assist in the training of new personnel to our multiple databases. > > I recently downloaded the ER/Modeling tool "Embarcadero ERStudio 7.0" since it > stated on its download page it was capable of working with Informix; however, > within the tool I can find no mention of Informix databases at all :( > > Any assistance would be appreciated. > > Take care. > Clifton > > _______________________________________________ > Join Excite! - http://www.excite.com > The most personalized portal on the Web! > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. _______________________________________________ Join Excite! - http://www.excite.com The most personalized portal on the Web!

We're using version 6.0.1 -- (upgrading is on my list). We connect to our db via ODBC for reverse engineering/documentation purposes. I wouldn't use this tool to design a database and then engineer it into production. I don't think ERStudio officially supports Informix, just to be clear. We tried the trial version for awhile with Informix to be sure it worked for our purposes. We do have a support contract with them which gives us access to the usual upgrades, etc...I can send you a link to our doc if you'd like to see the schema reports. Sierra M. On Fri, 3 Mar 2006, clifbean@ex.... wrote: > > Thank you for responding. What version do you have of the package? I cannot > find anything within version 7.0 that mentions Informix. I had heard good > things about it in the past and wanted to use it but ran into the roadblock > noted in my email. Take care.Clifton --- On Fri 03/03, Sierra A.T..... < > staylor@cs.uoregon.edu > wrote:From: Sierra A.T..... [mailto: > staylor@cs.uoregon.edu]To: ids@iiug.orgDate: Fri, 3 Mar 2006 16:15:21 -0500 > (EST)Subject: Re: ER Modeling Tool Capable of Working with I.... [6472]We use > ERStudio with informix, and we're pretty happy with it. After a little bit of > tweaking (you have to remember to change char(10) to boolean, blob/clob, > etc... after reverse engineering), we have no real problems with it. It > generates lovely html reports that we use as documentation for our staff. You > can post comments on each table, column, relationship. We also evaluated ERWin > and PowerDesigner before we chose ERStudio. We liked ERWin a lot too, but the > price > (for the tools) was too high compared with ERStudio. I don't really use it to > do data modeling, but for documentation and as a training tool, I've found > that its enough. Sierra M. On Fri, 3 Mar 2006, clifbean@ex.... wrote: > > > I am trying to find a tool that will allow me to import or connect to an > > Informix instance/database and capture the schema for use in both > documenting > and assist in the training of new personnel to our multiple > databases. > > I recently downloaded the ER/Modeling tool "Embarcadero > ERStudio 7.0" since it > stated on its download page it was capable of > working with Informix; however, > within the tool I can find no mention of > Informix databases at all :( > > Any assistance would be appreciated. > > > Take care. > Clifton > > > _______________________________________________ > Join Excite! - > http://www.excite.com > The most personalized portal on the Web! > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > _______________________________________________ > Join Excite! - http://www.excite.com > The most personalized portal on the Web! > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >

You might want to give a call to AGS as ServerStudio in its next release has ER diagramming. Bruce Simms Data Base Services TALX UCeXpress 10101 Woodfield Lane St. Louis, MO 63132 (314) 684-2238 FAX (314) 983-3238 bsimms@talx.com -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Sierra A.T..... Sent: Friday, March 03, 2006 5:08 PM To: ids@iiug.org Subject: Re: ER Modeling Tool Capable of Working with I.... [6474] We're using version 6.0.1 -- (upgrading is on my list). We connect to our db via ODBC for reverse engineering/documentation purposes. I wouldn't use this tool to design a database and then engineer it into production. I don't think ERStudio officially supports Informix, just to be clear. We tried the trial version for awhile with Informix to be sure it worked for our purposes. We do have a support contract with them which gives us access to the usual upgrades, etc...I can send you a link to our doc if you'd like to see the schema reports. Sierra M. On Fri, 3 Mar 2006, clifbean@ex.... wrote: > > Thank you for responding. What version do you have of the package? I cannot > find anything within version 7.0 that mentions Informix. I had heard good > things about it in the past and wanted to use it but ran into the roadblock > noted in my email. Take care.Clifton --- On Fri 03/03, Sierra A.T..... < > staylor@cs.uoregon.edu > wrote:From: Sierra A.T..... [mailto: > staylor@cs.uoregon.edu]To: ids@iiug.orgDate: Fri, 3 Mar 2006 16:15:21 -0500 > (EST)Subject: Re: ER Modeling Tool Capable of Working with I.... [6472]We use > ERStudio with informix, and we're pretty happy with it. After a little bit of > tweaking (you have to remember to change char(10) to boolean, blob/clob, > etc... after reverse engineering), we have no real problems with it. It > generates lovely html reports that we use as documentation for our staff. You > can post comments on each table, column, relationship. We also evaluated ERWin > and PowerDesigner before we chose ERStudio. We liked ERWin a lot too, but the > price > (for the tools) was too high compared with ERStudio. I don't really use it to > do data modeling, but for documentation and as a training tool, I've found > that its enough. Sierra M. On Fri, 3 Mar 2006, clifbean@ex.... wrote: > > > I am trying to find a tool that will allow me to import or connect to an > > Informix instance/database and capture the schema for use in both > documenting > and assist in the training of new personnel to our multiple > databases. > > I recently downloaded the ER/Modeling tool "Embarcadero > ERStudio 7.0" since it > stated on its download page it was capable of > working with Informix; however, > within the tool I can find no mention of > Informix databases at all :( > > Any assistance would be appreciated. > > > Take care. > Clifton > > > _______________________________________________ > Join Excite! - > http://www.excite.com > The most personalized portal on the Web! > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > _______________________________________________ > Join Excite! - http://www.excite.com > The most personalized portal on the Web! > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.