Setting data sources - Data Compare for Oracle

When you create a new project, Data Compare for Oracle requires information about which two databases you want to compare, and how to connect to them.

This topic describes how to connect to databases in Data Compare for Oracle.

Selecting data sources
Using a TNS connection
Using a manual connection
Selecting schemas to compare
Using a direct connection

Selecting databases

You enter information about the databases you want to compare on the Project Configuration dialog box:

Specify the two databases you want to compare on the Data Sources tab. You specify a source and a target. The source is the database that will not change; the target is the database that will change.

You can connect to your Oracle databases using a TNS connection or a manual connection.

Tip: If you want to use the same database connection details for the source and target, you can use the Copy button. For a short tip video, see: Using the Copy button.

Using a TNS connection

A TNS connection enables you to connect to a database using an alias specified in your tnsnames.ora configuration file.

By default, tnsnames.ora is located in:

ORACLE_HOME/network/admin

To connect using a TNS connection:

1. Under Source or Target, select Database.
2. Select the TNS Connection tab, if it is not already selected.
3. In the Oracle home box, type or select the name of the Oracle home.

   An Oracle home is the location of an Oracle Database installation.

4. Under Database, in the Network Alias box, type or select the alias (network service name) of the database and then enter the User name and Password.

   If you want Data Compare for Oracle to remember your password, select the Save check box.

Using a manual connection

A manual connection can be useful if:

• you do not not have Oracle client software installed, and cannot use a tnsnames.ora file
• you do not have an alias entry for a database you want to compare in your tnsnames.ora file
• you are experiencing problems connecting to a database using a TNS connection
• you want to connect to a database without an Oracle client installed, using a direct connection

To connect using a manual connection:

1. In the Data Sources tab, under Source or Target, select the Manual Connection tab.
2. In the Host name box, type the host system name for the database.

   A host system name can be:

   • an IP address
   • a computer name
   • localhost, if you connect to a database that is on the same computer as Data Compare for Oracle
3. In the Port box, type the listener port number.
4. From the Database menu, select SID or Service name.

   A SID (system identifier) is a unique name for an Oracle database on a specific host; a service name is an alias for a database specified in your tnsnames.ora configuration file.

5. Type the SID or service name as appropriate, and enter the User Name and Password.

   If you want Data Compare for Oracle to remember your password, select the Save check box.

Selecting schemas to compare

When you have specified source and target databases, you can select the schemas to compare. You can compare data from a single schema from each data source, or multiple schemas.

To compare data from a single schema from each database:

1. Under Source, in the Schemas box, type or select a schema.

   If a schema with the same name exists in the target database, it is automatically selected.

2. If you want to compare to a different schema, under Target, select the required schema.

If no schemas are displayed in Schemas, click Refresh list.

To compare multiple schemas from each database:

1. In the Schemas boxes, select a source and a target schema to compare.
2. Click +Add schemas to the comparison.

   

   The schemas you selected are added to the comparison, and displayed in the lower pane.

   

3. Repeat this process for as many schemas as you want to compare.

Note that data in the schemas selected in the Schemas boxes and data in the schemas in the lower pane is compared when you run the comparison.

If you want to remove schemas that you have added to the comparison, click x Remove.

Using a direct connection

You can choose to connect to a database directly over TCP/IP when you are using a manual connection.

A direct connection does not require an Oracle client, and can be useful if you are experiencing problems connecting to databases.

To use a direct connection:

1. On the Tools menu, click Application Options.
2. Under Connections, select the Prefer direct connection check box:

   

3. Click OK.

   You can now use a manual connection to connect to a database directly.

Note that if you use a direct connection, you cannot use a service name to connect to a database.