RE: - ER Modeling Tool Capable of Working with Inf

Posted in 2006

Topics: SQL Development & Query Writing, Connectivity: ODBC / JDBC / .NET

Struckhoff, — Fri, 03 Mar 2006 20:36:51 — source: IIUG Forums & Mailing Lists

Cliff, Have you tried using an ODBC connection? I'm using CA's Erwin 4.1.4 with an ODBC connection. It does support Informix at least thru 9.4 Kevin Struckhoff Analytics Mgr. NewRoads West ________________________________ Office 818.253.3819 Fax 818.834.3889 kevin.struckhoff@newroads.com -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of clifbean@ex.... Sent: Friday, March 03, 2006 12:27 PM To: ids@iiug.org Subject: [SPAM] - ER Modeling Tool Capable of Working with Informix [6467] - Bayesian Filter detected spam 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.

↪ replying to Struckhoff,

Andrus, Gary — Mon, 03 Apr 2006 17:24:48 — source: IIUG Forums & Mailing Lists

I've used the ODBC connections on CA's ERwin (AllFusion) as well,=0D=0Acurr= ently on version 4=2E1=2E4 Build 4033=2E I've had some troubles with=0D=0A= inheritance, sets, and some views on this version=2E=0D=0A=0D=0AI was told = that build 4244 is supposed to correct these problems, but=0D=0Abecause of = other issues, haven't been able to install it yet to verify=2E=0D=0A=0D=0AO= therwise, I've found it pretty useful for both forward and reverse=0D=0Aeng= ineering databases=2E The standard table definitions, data types,=0D=0Acon= straints, etc=2E all seem to work pretty well=2E=0D=0A=0D=0A-----Original M= essage-----=0D=0AFrom: ids-bounces@iiug=2Eorg [mailto:ids-bounces@iiug=2Eor= g] On Behalf Of=0D=0AStruckhoff,=2E=2E=2E=2E=0D=0ASent: Friday, March 03, 2= 006 3:37 PM=0D=0ATo: ids@iiug=2Eorg=0D=0ASubject: RE: - ER Modeling Tool Ca= pable of Working with=2E=2E=2E=2E [6468]=0D=0A=0D=0A=0D=0ACliff, =0D=0A=0D= =0AHave you tried using an ODBC connection? I'm using CA's Erwin 4=2E1=2E4 = with=0D=0A=0D=0Aan ODBC connection=2E It does support Informix at least thr= u 9=2E4 =0D=0A=0D=0AKevin Struckhoff =0D=0AAnalytics Mgr=2E =0D=0ANewRoads = West =0D=0A________________________________ =0D=0A=0D=0AOffice 818=2E253=2E= 3819 Fax 818=2E834=2E3889 =0D=0Akevin=2Estruckhoff@newroads=2Ecom =0D=0A=0D= =0A-----Original Message----- =0D=0AFrom: ids-bounces@iiug=2Eorg [mailto:id= s-bounces@iiug=2Eorg] On Behalf Of =0D=0Aclifbean@ex=2E=2E=2E=2E =0D=0ASent= : Friday, March 03, 2006 12:27 PM =0D=0ATo: ids@iiug=2Eorg =0D=0ASubject: [= SPAM] - ER Modeling Tool Capable of Working with Informix =0D=0A[6467] - Ba= yesian Filter detected spam =0D=0A=0D=0AI am trying to find a tool that wil= l allow me to import or connect to an=0D=0A=0D=0A=0D=0AInformix instance/da= tabase and capture the schema for use in both =0D=0Adocumenting =0D=0Aand a= ssist in the training of new personnel to our multiple databases=2E =0D=0A= =0D=0AI recently downloaded the ER/Modeling tool "Embarcadero ERStudio 7=2E= 0" =0D=0Asince it =0D=0Astated on its download page it was capable of worki= ng with Informix; =0D=0Ahowever, =0D=0Awithin the tool I can find no mentio= n of Informix databases at all :( =0D=0A=0D=0AAny assistance would be appre= ciated=2E =0D=0A=0D=0ATake care=2E =0D=0AClifton =0D=0A=0D=0A______________= _________________________________ =0D=0AJoin Excite! - http://www=2Eexcite= =2Ecom =0D=0AThe most personalized portal on the Web! =0D=0A=0D=0A*********= ***************************************************************=0D=0A=0D=0A= ******* =0D=0AForum Note: Use "Reply" to post a response in the discussion = forum=2E =0D=0A=0D=0A=0D=0A************************************************= ************************=0D=0A******* =0D=0A Forum Note: Use "Reply" to po= st a response in the discussion forum=2E =0D=0A=0D=0A=0D=0A----------------= -------------------------=0D=0AThis e-mail may contain confidential or priv= ileged information=2E If=0D=0Ayou=0D=0Athink you have received this e-mail= in error, please advise the=0D=0Asender by=0D=0Areply e-mail and then dele= te this e-mail immediately=2E Thank you=2E=0D=0AAetna=0D=0A