DBAppender Connection Options for SAS Tables

The following is an example of the basic syntax for specifying options in the ConnectionString parameter of a DBAppender configuration if the data store is a SAS table. 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=BASE;
SCHEMA=(NAME=schema-name;PRIMARYPATH=schema-path);

Syntax Description

The data source connection options for a SAS table include the following:

CATALOG=catalog-identifier;

specifies an arbitrary identifier for the SAS catalog. Any identifier is valid (for example, catalog=base).

Requirement

You must specify a catalog.

DRIVER=BASE;

identifies the data source to which you want to connect, which is a Base SAS table.

Requirement

You must specify the driver.

SCHEMA=(NAME=schema-name;PRIMARYPATH=schema-path);

specifies the name and path for the schema. Any name is valid (for example, name=MySchema). For PRIMARYPATH=, specify the path where the SAS table is located, relative to the local machine.

Requirement

You must specify the SCHEMA= option.

Example: Connection String for SAS Tables

DRIVER=base;CATALOG=base;schema=(name=MySchema;primarypath='C:\LogsData');