Excel Add-In for SAS Xpt

Build 26.0.9655

TestConnectionBehavior

Specifies the behavior of the test connection operation.

Possible Values

READ_FILE, LIST_FILES, NO_OPERATION, AUTHENTICATE, LIST_OR_READ_FILES

Data Type

string

Default Value

"AUTHENTICATE"

Remarks

Changes how the add-in responds to a test connection operation based on the integration scenario.

LIST_OR_READ_FILES

List and read files from the storage source until at least one is parsed. Fails if none of the files can be parsed (are invalid). Fails if the directory contains no SAS Xpt files. Note: this mode will not read files in sub-directories. This is the most flexible option and works with both directory and file URIs.

READ_FILE

Validates that the URI points to a readable SAS Xpt file. The URI must point to an existing SAS Xpt file, not a directory. This behavior will fail if the file does not exist or contains invalid SAS Xpt content.

LIST_FILES

Validates that the URI points to a directory and lists its contents. Fails if the directory contains no SAS Xpt files.

NO_OPERATION

Performs basic URI validation without accessing files or verifying their existence. This is useful for quickly validating configuration without network or file system operations.

AUTHENTICATE

Validates connection credentials and URI accessibility. For cloud storage, this verifies authentication. For local files, this checks URI format and basic accessibility.

Notes

  • The add-in is read-only. Unlike write-capable drivers, empty directories will cause failures for LIST_FILES since a connection with no readable files is unusable.

Behavior by URI examples

URI NO_OPERATION READ_FILE LIST_FILES LIST_OR_READ_FILES AUTHENTICATE
Directory with XPT files Success Failure: URI must point to an existing file Success Success Success
Empty directory Success Failure: URI must point to an existing file Failure: URI must point to a non-empty directory Success Success
Non-existing directory Success Failure: URI must point to an existing file Failure: URI must point to an existing directory Failure: URI must point to an existing file or directory Success
Valid XPT file Success Success Failure: URI must point to an existing directory Success Success
Non-existing file Success Failure: URI must point to an existing file Failure: URI must point to an existing directory Failure: URI must point to valid file or directory Success
Invalid XPT format Success Failure: Parsing error Failure: URI must point to an existing directory Failure: Parsing error Success
Cloud storage, invalid credentials Success Failure: Authentication failed Failure: Authentication failed Failure: Authentication failed Failure: Authentication failed

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9655