Oracle

The same shape as the Microsoft SQL Server form, with one
difference in how the instance is addressed.

Fields

Field	Notes
Host	The server
SID	The instance, or use Service Name
Service Name	The service, or use SID
Username	Optional
Password	Optional: stored encrypted, never sent back to the browser
Connection String	An alternative to all of the above

SID or Service Name, never both

An Oracle instance is addressed one way or the other. The form says so, and it
refuses a save that supplies neither.

• SID is the older form and identifies one instance directly.
• Service Name is what a clustered or multi-tenant database usually presents.

If you have been given a connection detail and cannot tell which it is, the
database administrator can; guessing produces a connection error that names
neither field.

Connection string

As with MS-SQL, the connection string wins. Fill it in and every field above it
is ignored, including a host that looks right.

Related

• Endpoints: the list, and how a connection is tested
• Microsoft SQL Server: the same form, and where the rows go
• Task Mapping: the table name and column types