1

I have been trying to generate an ERD for some oracle database. While I am doing this via 'Actions'->'Reverse Engineering' option, I get a section that asks me for a connection string. But I am unsure of the format about how we can specify the database and its details. Could someone please help me with this?

Thanks Pradeep

pradeepradyumna
  • 952
  • 13
  • 34

1 Answers1

2

I am using Erwin 7.3.8 to connect on a Oracle 11g schema. The connection works from me when I use the oracle tnsnames string format:

For example:

(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = **database-server**)(PORT = **database-server-port**))(CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = **service-name-if-exists**)))

Copy as a one line command and paste in the Connection String field.

Cheers!

James Freitas
  • 504
  • 2
  • 8
  • 21