DBAppender Connection Options for Oracle

The following is an example of the basic syntax for specifying options in the ConnectionString parameter of a DBAppender configuration for an Oracle database. If you need additional details, contact SAS Technical Support.

Valid in:	ConnectionString parameter of DBAppender configuration
See:	DBAppender

Table of Contents

Syntax

CATALOG=catalog-identifier;
DRIVER=ORACLE;
PATH=database-specification;
PWD=password;
UID=user-id;

Syntax Description

The data source connection options for an Oracle database include the following:

CATALOG=catalog-identifier;

specifies an arbitrary identifier for an SQL catalog, which groups logically related schemas. Any identifier is valid (for example, catalog=oracle_log).

Requirement

You must specify a catalog. For the Oracle database, this is a logical catalog name to use as an SQL catalog identifier.

DRIVER=ORACLE;

identifies the data source to which you want to connect, which is an Oracle database.

Requirement

You must specify the driver.

PATH=database-specification;: specifies the Oracle connect identifier. A connect identifier can be a net service name, a database service name, or a net service alias.

PWD=password;

specifies the Oracle database password that is associated with user ID specified in UID=.

Default	If this parameter is not specified, then the password for the default Oracle user ID (OPS$sysid) is used, if it is enabled.
Requirement	This parameter is required if UID= is specified.

UID=user-id;

specifies an Oracle user ID. If the user ID contains blanks or national characters, enclose it in quotation marks.

Default	If this parameter is not specified, then the default Oracle user ID (OPS$sysid) is used, if it is enabled.
Requirement	This parameter is required if PWD= is specified.

Example: Connection String for Oracle

DRIVER=oracle;UID=User1;PWD=Password1;PATH=MyDatabaseService;CATALOG=x;