How To: Connect to a Database

       Create a New Server Connection

To create a server connection, perform the following actions:

1.On the Start Page click New Data Comparison. The New Data Comparison wizard opens.
2.Click New to create source and target connections.
 
3.The Database Connection Properties window will open.
 

Direct Connection

If you want to connect to the server using the Direct mode, follow the steps below:

1.Click the Direct check box.
2.Enter the host name in the Host box.
3.Enter the port information in the Port box. Default port number is 1521.
4.In the Service Name box enter the database name to which you want to connect to.
5.Enter the login credentials in the User and Password boxes.
6.(optional) You can specify how to connect to the server in the Connect as box. 'Normal' is set by default. Alternatively, you can connect to SYSDBA and SYSOPER administrative privileges selecting 'SYSDBA' or 'SYSOPER' options.
7.Enter a distinctive name for your new connection in the Enter connection name box. Alternatively, the connection name is generated automatically as [user]@[host]:[service name].
8.(optional) You can assign a category for a new connection  in the Document Category box.
9.(optional) You can click Advanced to configure advanced connection properties.
10. (optional) You can click Test Connection to verify that you can connect to the database by using the specified connection information.
11. Click OK to create the connection.

Connection via the TNS

If you want to connect to the server via TNS, follow the steps below:

1.Select TNS (Transparent Network Substrate) in the Connection type box.
2.Enter the database name in the Server box.
3.Enter the login credentials in the User and Password boxes.
4.(optional) You can specify how to connect to the server in the Connect as box. 'Normal' is set by default. Alternatively, you can connect to SYSDBA and SYSOPER administrative privileges selecting 'SYSDBA' or 'SYSOPER' options.
5. If you have several Oracle clients installed, in the Home box select which home you want to work with for the connection. If an Oracle Client is unique, it is selected by default. If you want to connect to the server via an Instant Client, specify the client in the Home box as well.

Note

If you cannot find the server you want in the server list, your Oracle Client is not properly installed.

6.Enter a distinctive name for your new connection in the Connection name box. Alternatively, the connection name is generated automatically as [user]@[server].
7.(optional) You can assign a category for a new connection  in the Document Category box.
8.(optional) You can click Advanced to configure advanced connection properties.
9. (optional) You can click Test Connection to verify that you can connect to the database by using the specified connection information.
10. Click OK to create the connection.

Connection via TNS using OS Authentication

1.Before you can connect, you should create an external user with the granted CONNECT and DBA roles:

CREATE USER "OPS$DOMAIN_NAME\USER_NAME"
IDENTIFIED EXTERNALLY
DEFAULT TABLESPACE USERS
TEMPORARY TABLESPACE TEMP
PROFILE "DEFAULT";
 
GRANT UNLIMITED TABLESPACE, CONNECT, DBA TO "OPS$DOMAIN_NAME\USER_NAME" WITH ADMIN OPTION;

1.Select TNS using OS Authentication in the Connection type box.
2.Select the required server in the Server box.
3.(optional) You can specify how to connect to the server in the Connect as box. 'Normal' is set by default. Alternatively, you can connect to SYSDBA and SYSOPER administrative privileges selecting 'SYSDBA' or 'SYSOPER' options.
4.If you have several Oracle clients installed, in the Home box select which home you want to work with for the connection. If an Oracle Client is unique, it is selected by default. If you want to connect to the server via an Instant Client, specify the client in the Home box as well.

Note

If you cannot find the server you want in the server list, your Oracle Client is not properly installed.

5.Enter a distinctive name for your new connection in the Connection Name box. Alternatively, the connection name is generated automatically as [domain name/user name]@[server].
6.(optional) You can assign a category for a new connection  in the Document Category box.
7.(optional) You can click Advanced to configure advanced connection properties.
8. (optional) You can click Test Connection to verify that you can connect to the database by using the specified connection information.
9. Click OK to create the connection.

Alternative ways to access the Database Connection Properties window:

1.In the Database menu, click .
2.Click the New Connection button on the Connection toolbar.

Note

The Connection toolbar is hidden by default. To unhide it, right-click on the menu bar and click Connection.

       Edit and delete connections

You can create, edit, and delete connections with the help of Connection Manager. To open it, click Edit on the Source and Target page of the New Data Comparison wizard or click the Connection Manager button on the Database menu.

To edit a connection, select it in the Connections list and click the Edit button or just double-click it in the list. The Database Connection Properties window will open.

To delete a connection, select it in the Connections list and click the Delete button or press the DELETE key.

You also can use the New button to create new connections.

       Windows connection coloring

Windows connection coloring allows you immediately know to which server you're connected to. You can add coloring for each server connection.

 

       See Also