|
Connect to an Oracle database |
|
|
Connect to an Oracle database |
|
Connecting to an Oracle database in Data Architect requires the user to have an Oracle Client installed on the computer.
To add a connection to a SQL database, the user must select the Add Data Connection button 
, located in the Data Connections dialog bar or right click on the Data Connections root and select the Add Data Connection option. As a result, the Add Connection dialog will be displayed.
| • | Connection Name - the name given by the user to identify the connection. |
| • | Provider Type - Oracle Database must be selected from the drop-down list. |
| • | TNS Name - the net service name that is described in the tnsnames.ora file must be inserted. 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, the "ora9" net service name, that must be described in the tnsnames.ora file, has been inserted. 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, as follows:
ORA9 =
(DESCRIPTION =
(ADDRESS =
(PROTOCOL = TCP)(HOST = 192.168.1.110)(PORT = 1521)
)
(CONNECT_DATA =
(SERVICE_NAME = ORA9)(SID = Ecrion_DB)
)
)
In the ADDRESS - the protocol, host address and port number are described.
In the CONNECT_DATA - the SERVICE_NAME (the name of the system to the outside world) and SID (the local name of the database on your system) are configured.
| • | Log on to database - the user credentials must be entered. |
| • | Finally, to test the connection, the Test Connection button must be selected. |