Connecting to an Oracle database in Data Architect requires that you have an Oracle Client installed on your computer.

 

To add a connection to an Oracle database click the Add Data Connection button in the Data Connections dialog bar or right click on the Data Connections root and select Add Data Connection. This will open the Add Connection dialog box below:

 

 

In the first text box type a name for the connection that you are about to set.

In the Provider Type box select Oracle Database from the drop-down list.

 

In the TNS Name text box enter the net service name that is described in tnsnames.ora file.

The net service name is an alias mapped to a database network address contained in a connect descriptor. A connect descriptor contains the location of the listener through a protocol address and the service name of the database to which to connect. Clients and database servers (that are clients of other database servers) use the net service name when making a connection with an application.

 

In the example above we used the net service name "ora9" that must be described in the tnsmanes.ora file. This file is located by default in the %ORACLE_HOME%\network\admin directory on Windows operating systems.

 

The tnsnames.ora contains the description of the "ora9" net service name:

 

ORA9 =

 (DESCRIPTION = 

     (ADDRESS =

        (PROTOCOL = TCP)(HOST = 192.168.1.110)(PORT = 1521)

     )

 (CONNECT_DATA =

   (SERVICE_NAME = ORA9)(SID = Ecrion_DB)

 )

)

 

In the ADDRESS section are configured the protocol, the host address and the port number.

In the CONNECT_DATA section are configured the SERVICE_NAME (the name of the system to the outside world) and the SID (the local name of the database on your system).

 

 

In the Log on to database section you must enter the user credentials.

 

Finally, to test the connection click the Test Connection button.