ER tool
A user asked for a low-cost or free ER/data-modelling tool that can reverse-engineer an Informix schema, ruling out ERwin (too expensive, weak community edition) and IBM Data Studio (too heavy/slow and poor Informix fit). Suggestions from the list included an ERwin 30-day trial, Oracle SQL Data Modeler via a JDBC connection (no native Informix support but workable), Microsoft Visio Pro using the Informix Client-SDK ODBC driver, ServerStudio (already used, but licence cost was the issue), SquirrelSQL's graph plugin (judged too limited) and JSQLTool. The poster said he'd try Oracle Data Modeler first, then Visio, but no final outcome is recorded in the thread.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Hi, Anyone use a ER tool with Informix able to do reverse enginer? Low cost or free ... All I tested so far... anyone works... :( In past (10 years ago) ERWin was a excellent choice , but today has a very high price for my situation and their "community" edition is a joke.... and I not sure if today it is compatible with Informix was early... IBM Data Studio is out of question... or I need to buy a new desktop able to run it... and probably will run slowwwwww..... Cesar --f46d043be18c27031c04dcd620d6
ERWin used to have a 30 day free trial that would do the job nicely Cheers Paul -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Cesar Inacio Martins Sent: Thursday, May 16, 2013 8:49 AM To: ids@iiug.org Subject: ER tool [30280] Hi, Anyone use a ER tool with Informix able to do reverse enginer? Low cost or free ... All I tested so far... anyone works... :( In past (10 years ago) ERWin was a excellent choice , but today has a very high price for my situation and their "community" edition is a joke.... and I not sure if today it is compatible with Informix was early... IBM Data Studio is out of question... or I need to buy a new desktop able to run it... and probably will run slowwwwww..... Cesar --f46d043be18c27031c04dcd620d6 **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum.
IBM DataStudio can do it, it is based in Eclipse, free of charge. http://www-03.ibm.com/software/products/us/en/data-studio/ Regards. Alexandre Marini IBM Informix Certified Professional v10 / v11.50 / v11.70 IBM Information Management Informix Technical Professional IBM Infosphere DataStage Technical Professional Informix Senior DBA - Orizon Brasil BRIUG website administrator Informix independent consultant > To: ids@iiug.org > From: paul@oninit.com > Subject: RE: ER tool [30281] > Date: Thu, 16 May 2013 09:59:04 -0400 > > ERWin used to have a 30 day free trial that would do the job nicely > > Cheers > Paul > > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Cesar > Inacio Martins > Sent: Thursday, May 16, 2013 8:49 AM > To: ids@iiug.org > Subject: ER tool [30280] > > Hi, > > Anyone use a ER tool with Informix able to do reverse enginer? > Low cost or free ... > > All I tested so far... anyone works... :( > > In past (10 years ago) ERWin was a excellent choice , but today has a very > high price for my situation and their "community" edition is a joke.... and > I not sure if today it is compatible with Informix was early... > > IBM Data Studio is out of question... or I need to buy a new desktop able > to run it... and probably will run slowwwwww..... > > Cesar > > --f46d043be18c27031c04dcd620d6 > > **************************************************************************** > *** > Forum Note: Use "Reply" to post a response in the discussion forum. > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >
Try Oracle Data modeler, has no real Informix support, but can reverse engineer with JDBC connection. I used that only once to give a customer a view on his model, not for SQL generation. Marcus Haarmann ----- Ursprüngliche Mail ----- Von: "Cesar Inacio Martins" <cesar.inacio.martins@gmail.com> An: ids@iiug.org Gesendet: Donnerstag, 16. Mai 2013 15:49:00 Betreff: ER tool [30280] Hi, Anyone use a ER tool with Informix able to do reverse enginer? Low cost or free ... All I tested so far... anyone works... :( In past (10 years ago) ERWin was a excellent choice , but today has a very high price for my situation and their "community" edition is a joke.... and I not sure if today it is compatible with Informix was early... IBM Data Studio is out of question... or I need to buy a new desktop able to run it... and probably will run slowwwwww..... Cesar --f46d043be18c27031c04dcd620d6 ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.
Hi Paul, I'm looking for a "permanent" solution... 2013/5/16 Paul Watson <paul@oninit.com> > ERWin used to have a 30 day free trial that would do the job nicely > > Cheers > Paul > > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of > Cesar > Inacio Martins > Sent: Thursday, May 16, 2013 8:49 AM > To: ids@iiug.org > Subject: ER tool [30280] > > Hi, > > Anyone use a ER tool with Informix able to do reverse enginer? > Low cost or free ... > > All I tested so far... anyone works... :( > > In past (10 years ago) ERWin was a excellent choice , but today has a very > high price for my situation and their "community" edition is a joke.... and > I not sure if today it is compatible with Informix was early... > > IBM Data Studio is out of question... or I need to buy a new desktop able > to run it... and probably will run slowwwwww..... > > Cesar > > --f46d043be18c27031c04dcd620d6 > > > **************************************************************************** > *** > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --f46d04388df18c1bb504dcd79544
Hi Marcus, Interesting! I will download it. I was tried connect with the SQL Developer 3.5 but they don't have support to informix... I don't try the Oracle Data modeler before because I think will get the same problem.... I post here later if will works for me. Thank you! Cesar 2013/5/16 Marcus Haarmann <marcus.haarmann@midoco.de> > Try Oracle Data modeler, has no real Informix support, but can reverse > engineer with JDBC connection. > I used that only once to give a customer a view on his model, not for SQL > generation. > > Marcus Haarmann > > ----- Ursprüngliche Mail ----- > > Von: "Cesar Inacio Martins" <cesar.inacio.martins@gmail.com> > An: ids@iiug.org > Gesendet: Donnerstag, 16. Mai 2013 15:49:00 > Betreff: ER tool [30280] > > Hi, > > Anyone use a ER tool with Informix able to do reverse enginer? > Low cost or free ... > > All I tested so far... anyone works... :( > > In past (10 years ago) ERWin was a excellent choice , but today has a very > high price for my situation and their "community" edition is a joke.... and > I not sure if today it is compatible with Informix was early... > > IBM Data Studio is out of question... or I need to buy a new desktop able > to run it... and probably will run slowwwwww..... > > Cesar > > --f46d043be18c27031c04dcd620d6 > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --f46d04388e552198ab04dcd7aa35
Hi Marini, Sorry, as I said... > IBM Data Studio is out of question... It's terrible tool.... maybe good to DB2... to Informix is just 1% compatible... and slow and annoying to work... 2013/5/16 Alexandre Marini <alexandre@briug.org> > IBM DataStudio can do it, it is based in Eclipse, free of charge. > http://www-03.ibm.com/software/products/us/en/data-studio/ > > Regards. > > Alexandre Marini > IBM Informix Certified Professional v10 / v11.50 / v11.70 > > IBM Information Management Informix Technical Professional > > IBM Infosphere DataStage Technical Professional > Informix Senior DBA - Orizon Brasil > BRIUG website administrator > Informix independent consultant > > > To: ids@iiug.org > > From: paul@oninit.com > > Subject: RE: ER tool [30281] > > Date: Thu, 16 May 2013 09:59:04 -0400 > > > > ERWin used to have a 30 day free trial that would do the job nicely > > > > Cheers > > Paul > > > > -----Original Message----- > > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of > Cesar > > Inacio Martins > > Sent: Thursday, May 16, 2013 8:49 AM > > To: ids@iiug.org > > Subject: ER tool [30280] > > > > Hi, > > > > Anyone use a ER tool with Informix able to do reverse enginer? > > Low cost or free ... > > > > All I tested so far... anyone works... :( > > > > In past (10 years ago) ERWin was a excellent choice , but today has a > very > > high price for my situation and their "community" edition is a joke.... > and > > I not sure if today it is compatible with Informix was early... > > > > IBM Data Studio is out of question... or I need to buy a new desktop able > > to run it... and probably will run slowwwwww..... > > > > Cesar > > > > --f46d043be18c27031c04dcd620d6 > > > > > **************************************************************************** > > *** > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --f46d0443048ac5f71a04dcd79ab1
Hi Spokey, Is what I'm using today, but the company have only 1 license and isn't renewed a couple years... We are two DBAs and I if is possible (so only 1 can use by time), I want the developers using this tool too. This way the server studio become expensive. Regards Cesar 2013/5/16 Spokey Wheeler Gmail <spokey.wheeler@gmail.com> > > On 16 May 2013, at 14:49, Cesar Inacio Martins < > cesar.inacio.martins@gmail.com> wrote: > > > Hi, > > > > Anyone use a ER tool with Informix able to do reverse enginer? > > Low cost or free ... > > > > All I tested so far... anyone works... :( > > > > In past (10 years ago) ERWin was a excellent choice , but today has a > very > > high price for my situation and their "community" edition is a joke.... > and > > I not sure if today it is compatible with Informix was early... > > > > IBM Data Studio is out of question... or I need to buy a new desktop able > > to run it... and probably will run slowwwwww..... > > www.serverstudio.com ? --f46d04388df1fd29e504dcd7efb9
On 16 May 2013, at 16:58, "Cesar Inacio Martins" <cesar.inacio.martins@gmail.com> wrote: > Hi Spokey, > > Is what I'm using today, but the company have only 1 license and isn't > renewed a couple years... > We are two DBAs and I if is possible (so only 1 can use by time), I want > the developers using this tool too. > This way the server studio become expensive. http://download.cnet.com/JSQLTool/3000-10254_4-75851493.html ? :-D > 2013/5/16 Spokey Wheeler Gmail <spokey.wheeler@gmail.com> > >> >> On 16 May 2013, at 14:49, Cesar Inacio Martins < >> cesar.inacio.martins@gmail.com> wrote: >> >>> Hi, >>> >>> Anyone use a ER tool with Informix able to do reverse enginer? >>> Low cost or free ... >>> >>> All I tested so far... anyone works... :( >>> >>> In past (10 years ago) ERWin was a excellent choice , but today has a >> very >>> high price for my situation and their "community" edition is a joke.... >> and >>> I not sure if today it is compatible with Informix was early... >>> >>> IBM Data Studio is out of question... or I need to buy a new desktop able >>> to run it... and probably will run slowwwwww..... >> >> www.serverstudio.com ? > > --f46d04388df1fd29e504dcd7efb9 > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >
Did you know this can be done in Microsoft Visio Pro with any ODBC data source, including Informix Client-SDK? It's not too expensive, and I often find people have it already. Regards, Doug Lawry
SquirrellSQL have the Graph plugin but it is somehow limited. Em 16-05-2013 17:08, Spokey Wheeler Gmail escreveu: > On 16 May 2013, at 16:58, "Cesar Inacio Martins" > <cesar.inacio.martins@gmail.com> wrote: > >> Hi Spokey, >> >> Is what I'm using today, but the company have only 1 license and isn't >> renewed a couple years... >> We are two DBAs and I if is possible (so only 1 can use by time), I want >> the developers using this tool too. >> This way the server studio become expensive. > http://download.cnet.com/JSQLTool/3000-10254_4-75851493.html ? :-D > >> 2013/5/16 Spokey Wheeler Gmail <spokey.wheeler@gmail.com> >> >>> On 16 May 2013, at 14:49, Cesar Inacio Martins < >>> cesar.inacio.martins@gmail.com> wrote: >>> >>>> Hi, >>>> >>>> Anyone use a ER tool with Informix able to do reverse enginer? >>>> Low cost or free ... >>>> >>>> All I tested so far... anyone works... :( >>>> >>>> In past (10 years ago) ERWin was a excellent choice , but today has a >>> very >>>> high price for my situation and their "community" edition is a joke.... >>> and >>>> I not sure if today it is compatible with Informix was early... >>>> >>>> IBM Data Studio is out of question... or I need to buy a new desktop able >>>> to run it... and probably will run slowwwwww..... >>> www.serverstudio.com ? >> --f46d04388df1fd29e504dcd7efb9 >> >> >> > ******************************************************************************* >> Forum Note: Use "Reply" to post a response in the discussion forum. >> > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. --
Hi Doug, Thank you for this information, I will test first the Oracle solution, if not work then I will check about the Visio Pro. 2013/5/16 DOUG LAWRY <douglawry@hotmail.com> > Did you know this can be done in Microsoft Visio Pro with any ODBC data > source, including Informix Client-SDK? It's not too expensive, and I often > find people have it already. > > Regards, > Doug Lawry > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a11c25e4cabcb4404dcd88a3e
Hi Spokey, Did you already use the JSQLTool with Informix? 2013/5/16 Spokey Wheeler Gmail <spokey.wheeler@gmail.com> > On 16 May 2013, at 16:58, "Cesar Inacio Martins" > <cesar.inacio.martins@gmail.com> wrote: > > > Hi Spokey, > > > > Is what I'm using today, but the company have only 1 license and isn't > > renewed a couple years... > > We are two DBAs and I if is possible (so only 1 can use by time), I want > > the developers using this tool too. > > This way the server studio become expensive. > > http://download.cnet.com/JSQLTool/3000-10254_4-75851493.html ? :-D > > > 2013/5/16 Spokey Wheeler Gmail <spokey.wheeler@gmail.com> > > > >> > >> On 16 May 2013, at 14:49, Cesar Inacio Martins < > >> cesar.inacio.martins@gmail.com> wrote: > >> > >>> Hi, > >>> > >>> Anyone use a ER tool with Informix able to do reverse enginer? > >>> Low cost or free ... > >>> > >>> All I tested so far... anyone works... :( > >>> > >>> In past (10 years ago) ERWin was a excellent choice , but today has a > >> very > >>> high price for my situation and their "community" edition is a joke.... > >> and > >>> I not sure if today it is compatible with Informix was early... > >>> > >>> IBM Data Studio is out of question... or I need to buy a new desktop > able > >>> to run it... and probably will run slowwwwww..... > >> > >> www.serverstudio.com ? > > > > --f46d04388df1fd29e504dcd7efb9 > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --f46d0443048a58435104dcd892be
Hi Sergio, We use Squirrel a lot here with Informix, is nice tool , I already tested before the graphs , but it is limited to "view" and to much limited. Thanks Cesar 2013/5/16 Sérgio Ferreira <sergio@moredata.pt> > SquirrellSQL have the Graph plugin but it is somehow limited. > > Em 16-05-2013 17:08, Spokey Wheeler Gmail escreveu: > > On 16 May 2013, at 16:58, "Cesar Inacio Martins" > > <cesar.inacio.martins@gmail.com> wrote: > > > >> Hi Spokey, > >> > >> Is what I'm using today, but the company have only 1 license and isn't > >> renewed a couple years... > >> We are two DBAs and I if is possible (so only 1 can use by time), I want > >> the developers using this tool too. > >> This way the server studio become expensive. > > http://download.cnet.com/JSQLTool/3000-10254_4-75851493.html ? :-D > > > >> 2013/5/16 Spokey Wheeler Gmail <spokey.wheeler@gmail.com> > >> > >>> On 16 May 2013, at 14:49, Cesar Inacio Martins < > >>> cesar.inacio.martins@gmail.com> wrote: > >>> > >>>> Hi, > >>>> > >>>> Anyone use a ER tool with Informix able to do reverse enginer? > >>>> Low cost or free ... > >>>> > >>>> All I tested so far... anyone works... :( > >>>> > >>>> In past (10 years ago) ERWin was a excellent choice , but today has a > >>> very > >>>> high price for my situation and their "community" edition is a > joke.... > >>> and > >>>> I not sure if today it is compatible with Informix was early... > >>>> > >>>> IBM Data Studio is out of question... or I need to buy a new desktop > able > >>>> to run it... and probably will run slowwwwww..... > >>> www.serverstudio.com ? > >> --f46d04388df1fd29e504dcd7efb9 > >> > >> > >> > > > > ******************************************************************************* > >> Forum Note: Use "Reply" to post a response in the discussion forum. > >> > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --f46d04388df11d80d004dcd89bda
Lord no. I'm firmly in the ServerStudio camp. On 16 May 2013, at 17:44, "Cesar Inacio Martins" <cesar.inacio.martins@gmail.com> wrote: > Hi Spokey, > > Did you already use the JSQLTool with Informix? > > 2013/5/16 Spokey Wheeler Gmail <spokey.wheeler@gmail.com> > >> On 16 May 2013, at 16:58, "Cesar Inacio Martins" >> <cesar.inacio.martins@gmail.com> wrote: >> >>> Hi Spokey, >>> >>> Is what I'm using today, but the company have only 1 license and isn't >>> renewed a couple years... >>> We are two DBAs and I if is possible (so only 1 can use by time), I want >>> the developers using this tool too. >>> This way the server studio become expensive. >> >> http://download.cnet.com/JSQLTool/3000-10254_4-75851493.html ? :-D >> >>> 2013/5/16 Spokey Wheeler Gmail <spokey.wheeler@gmail.com> >>> >>>> >>>> On 16 May 2013, at 14:49, Cesar Inacio Martins < >>>> cesar.inacio.martins@gmail.com> wrote: >>>> >>>>> Hi, >>>>> >>>>> Anyone use a ER tool with Informix able to do reverse enginer? >>>>> Low cost or free ... >>>>> >>>>> All I tested so far... anyone works... :( >>>>> >>>>> In past (10 years ago) ERWin was a excellent choice , but today has a >>>> very >>>>> high price for my situation and their "community" edition is a joke.... >>>> and >>>>> I not sure if today it is compatible with Informix was early... >>>>> >>>>> IBM Data Studio is out of question... or I need to buy a new desktop >> able >>>>> to run it... and probably will run slowwwwww..... >>>> >>>> www.serverstudio.com ? >>> >>> --f46d04388df1fd29e504dcd7efb9 >>> >>> >>> >> >> > ******************************************************************************* >>> Forum Note: Use "Reply" to post a response in the discussion forum. >>> >> >> >> >> > ******************************************************************************* >> Forum Note: Use "Reply" to post a response in the discussion forum. >> >> > > --f46d0443048a58435104dcd892be > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >
On 16 May 2013, at 14:49, Cesar Inacio Martins <cesar.inacio.martins@gmail.com> wrote: > Hi, > > Anyone use a ER tool with Informix able to do reverse enginer? > Low cost or free ... > > All I tested so far... anyone works... :( > > In past (10 years ago) ERWin was a excellent choice , but today has a very > high price for my situation and their "community" edition is a joke.... and > I not sure if today it is compatible with Informix was early... > > IBM Data Studio is out of question... or I need to buy a new desktop able > to run it... and probably will run slowwwwww..... www.serverstudio.com ?