I want to see it graphically. I Reverse Enginner with Erwin for my SQLServer database.
And I tried doing the same for Oracle too.
But I could not establish a connection with my Oracle DSN from Erwin. It does not give me an error, but the login screen just stays there. Erwin version is 3.5.2.
Have you used this tool before?? Will you be knowing what the problem is?
Thanks for your response.
If Erwin talks to Oracle without any hazzle, then why is mine not working??
These are the steps I followed :
1. Set up a system DSN on any machine for Oracle ODBC Driver 8.01.06 using the service name.
2. Open up Erwin and then set the target server to Oracle 8.x
3. Click on Oracle Connection and fill in the username/password, along with the DSN name.
4. And when I click 'connect', the screen just stays there, giving neither an error message nor a 'connected' message.
To think that anything could be wrong with the service name - I am able to use a 3rd party tool to export and import table data to and from the Oracle database without any poblem using the same DSN.
Is there anything like the DSN should reside in the same machine as the server for Erwin(though it is highly unlikely...)?
What do you think the problem could be?