Author Topic: Oracle 10g ? (Read 6522 times)

girlie · « **on:** March 04, 2005, 01:44:35 pm »

Hi - haven't been able to find this anywhere - does anyone know if EA corporate version will work on Oracle 10g? the specs say 9i...

gulp,
Thanks,
Christine

TBellaver · « **Reply #1 on:** March 04, 2005, 01:51:45 pm »

Hmmm,

I have just loaded both on this PC. I'll try and let you know.

- Todd

girlie · « **Reply #2 on:** March 04, 2005, 03:05:33 pm »

Thanks, that would be great and save me doing it!

Christine

TBellaver · « **Reply #3 on:** March 04, 2005, 03:39:01 pm »

Good news ... It works. I didn't have any problems connecting.

WAHHOO - Time for the fun stuff!

-Todd

girlie · « **Reply #4 on:** March 04, 2005, 03:49:14 pm »

Thanks muchly!
Christine

TBellaver · « **Reply #5 on:** March 04, 2005, 03:50:57 pm »

heh heh. no problemo...

- Yes, I am a geek

girlie · « **Reply #6 on:** March 04, 2005, 03:55:52 pm »

Question for me that doesn't know... I'm following the Oracle instructions I can find on the site and step #4. bothers me. It just says:
"Run the script to create all of the required tables/indexes etc."

I don't see a script available and I can only assume this is referring to a script I should have created myself for any tables etc.. I need or is there a script somewhere of EA required tables/indexes etc.. I'm supposed to be able to find?
Thanks,
Christine

Bruno.Cossi · « **Reply #7 on:** March 04, 2005, 04:44:10 pm »

Hi Christine,

the script is available in the Registered Users section, under Corporate Resources.

Hope this helps!
Bruno

Quote

Question for me that doesn't know... I'm following the Oracle instructions I can find on the site and step #4. bothers me. It just says:
"Run the script to create all of the required tables/indexes etc."

I don't see a script available and I can only assume this is referring to a script I should have created myself for any tables etc.. I need or is there a script somewhere of EA required tables/indexes etc.. I'm supposed to be able to find?
Thanks,
Christine

TBellaver · « **Reply #8 on:** March 07, 2005, 07:34:55 am »

I did use the scripts that Bruno mentioned. Make sure that you grab both Oracle scripts tho.

FYI: I was also able to export from my existing .eap file into Oracle DBMS using EA's Data Transfer Tool (From the EA Menu Bar > Tools/Data Management/Data Transfer...)

- Todd

girlie · « **Reply #9 on:** March 08, 2005, 10:04:54 am »

Thanks everyone - I'm good to go - successfully set up and have transfered my old model into oracle.

Christine

Justin Halls · « **Reply #10 on:** August 26, 2005, 06:33:22 am »

Hi,
Does anyone know if EA works with the latest Oracle 10gR2 Database?

Regards

Jeff Odell · « **Reply #11 on:** August 29, 2005, 04:18:09 am »

Can one of the posters that made this work verify which version of ODBC they used to connect? I know that the DDL Import only works with Oracle's ODBC and not Microsoft's and wondered if similar issues exist with the upsizing of an .EAP into Oracle.

Thanks -

jlo

eldon · « **Reply #12 on:** October 05, 2005, 03:41:31 pm »

I have tried to connect to Oracle 10g repository. I have a ODBC configured and in operation. I am trying to connect via Microsoft OLE DB Provider for ODBC Drives I am connect with Oracle 10g with this driver out from EA, but when I try to connect inside EA the following errors occurs:

Invalid data source...
You must suply a connect name

Funny, because when I test the connect before in EA´s dialog for connection, the test pass.

Any suggestions?

I´m sorry for my bad English

hd · « **Reply #13 on:** October 05, 2005, 07:56:14 pm »

To connect to an Oracle repository, use the "Oracle Provider for OLE DB".
Remember to transfer a data model (EABase.eap is a good start) to the repository before attempting to open a project.

To use the import ddl from odbc feature, connect using the Oracle ODBC driver.

JeffM · « **Reply #14 on:** December 01, 2005, 11:34:18 am »

Quote

Hi,
Does anyone know if EA works with the latest Oracle 10gR2 Database?

Regards

I've just been asked the same thing so I was wondering if anyone knew if Oracle 10g Release 2 was supported by EA?

Sparx Systems Forum

News: