New/Edit Project - Oracle

This page covers the current Oracle connection editor used when creating or editing a project. The shared project workflow is still the same, but the Oracle form is organized around connection style, service identification, and schema mapping or filtering rather than a database picker.

Connection details

• Connect Type: choose Basic to connect with host, port, and service details, or choose TNS to connect with an Instant Client network alias.
• Basic connection fields: enter the host, port, and service identifier. The selector beside the service field lets you treat that value as either a Service Name or a SID. When no saved port is available, the current form falls back to the Oracle default port 1521.
• TNS connection fields: when TNS is selected, the form switches to an Instant Client Network Alias field instead of the basic host and service controls.
• User name and password: enter the Oracle account for the project. The current editor still requires a user name before validation succeeds.
• Save: this is only enabled after a password has been entered and stores the password in the project file in encrypted form.
• Connect Role: choose Default, SYSOPER, or SYSDBA when the target environment requires a privileged Oracle session.
• OS Authentication: enable this when the Oracle connection should use operating-system authentication. Keep the user name field populated, because the current editor still validates that it is present.

Oracle mapping and filter behavior

• The Oracle page does not expose a SQL Server or MySQL-style database selector. Oracle object scope is instead handled through schema filtering and mapping.
• For single-connection Oracle projects, the connection panel exposes a Filter path for schema selection.
• For compare projects, the same area becomes a Mapping path and the status line warns when no schema filter is active.
• Shared help that mentions schema usually maps to Oracle schema owners, so owner.object naming matters when reviewing mappings, filters, and compare results.

Common Oracle project tasks

• Reuse the saved host list from the Host dropdown. Choosing a saved server fills the stored user name, password, save setting, and port.
• Use the mapping or filter area after the connection details are stable, because Oracle ownership rules affect what gets loaded and compared.
• Watch the connection result banner after testing. The current form shows a green success message when the connection validates and a red summary when it does not.

Connection flow

In the current Oracle editor, the usual sequence is to choose Basic or TNS, enter the host and service details or the network alias, supply the account and role, test the connection, then continue into mapping or filtering and the remaining project tabs.

For the shared editor workflow, see New/Edit Project Overview. For the schema-owner side of the workflow after the connection is defined, see Mapping and Filters.