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

Use DAS Management Console to add a new connection or to edit an already existing connection.

 

 

To add a connection to a SQL database select Data Connections in the left-side panel and click the Add button.

 

 

 

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.