Data Connector Options Listed by Category

Authentication

A C P T U

Name	Syntax and Description
authenticationDomain= Data Connector Option	authenticationDomain="domain" specifies the name of the authentication domain that contains credentials (userName= and password=) that are used to access a data source. Product: SAS Cloud Analytic Services Document: SAS Cloud Analytic Services: User’s Guide
client_id= Data Connector Option	client_id="ID-value" specifies the client ID value for the OAuth client that is used to connect to Google BigQuery. Product: SAS Cloud Analytic Services Document: SAS Cloud Analytic Services: User’s Guide
client_secret= Data Connector Option	client_secret=authentication-secret specifies the client secret value for the OAuth client that is used to connect to Google BigQuery. Product: SAS Cloud Analytic Services Document: SAS Cloud Analytic Services: User’s Guide
credentialsFile= Data Connector Option	credentialsFile="path-and-filename" specifies the path and name of the AWS credentials file to use for bulk loading data. Product: SAS Cloud Analytic Services Document: SAS Cloud Analytic Services: User’s Guide
password= Data Connector Option	password="password" specifies the data source password for a user. Product: SAS Cloud Analytic Services Document: SAS Cloud Analytic Services: User’s Guide
token= Data Connector Option	token="temporary-token" specifies a temporary token that is associated with the temporary credentials that you specify with the key= and secret= options. Product: SAS Cloud Analytic Services Document: SAS Cloud Analytic Services: User’s Guide
userName= Data Connector Option	userName="user-name" specifies the data source user name. Product: SAS Cloud Analytic Services Document: SAS Cloud Analytic Services: User’s Guide

Bulk Loading

B D

Name	Syntax and Description
blErrors= Data Connector Option	blErrors=number specifies that, after the indicated number of errors is received, the load should stop. Product: SAS Cloud Analytic Services Document: SAS Cloud Analytic Services: User’s Guide
blLoad= Data Connector Option	blLoad=number-of-rows specifies that, after the indicated number of rows is loaded, the load should stop. Product: SAS Cloud Analytic Services Document: SAS Cloud Analytic Services: User’s Guide
blParallel= Data Connector Option	blParallel=TRUE | FALSE specifies whether to perform a parallel bulk load. Product: SAS Cloud Analytic Services Document: SAS Cloud Analytic Services: User’s Guide
blSkip= Data Connector Option	blSkip=number-of-rows specifies to skip the indicated number of rows before starting the bulk load. Product: SAS Cloud Analytic Services Document: SAS Cloud Analytic Services: User’s Guide
blSkipIdxMaint= Data Connector Option	blSkipIdxMaint=TRUE | FALSE specifies whether to perform index maintenance on the bulk load. Product: SAS Cloud Analytic Services Document: SAS Cloud Analytic Services: User’s Guide
blSkipUnusableIdx= Data Connector Option	blSkipUnusableIdx=TRUE | FALSE specifies whether to skip index entries that are in an unusable state and continue with the bulk load. Product: SAS Cloud Analytic Services Document: SAS Cloud Analytic Services: User’s Guide
blStreamSize= Data Connector Option	blStreamSize=value specifies the size of the stream transfer buffer. Product: SAS Cloud Analytic Services Document: SAS Cloud Analytic Services: User’s Guide
defaultDir= Data Connector Option	defaultDir="directory-path" specifies where all temporary files are created during bulk loading or bulk unloading. Product: SAS Cloud Analytic Services Document: SAS Cloud Analytic Services: User’s Guide
delimiter= Data Connector Option	delimiter="character" specifies a character that separates columns of data during bulk loading to or bulk unloading from your data source. Product: SAS Cloud Analytic Services Document: SAS Cloud Analytic Services: User’s Guide

Data Access

C H S

Name	Syntax and Description
clusterId= Data Connector Option	clusterId="cluster-ID" specifies the cluster ID for a connection. Product: SAS Cloud Analytic Services Document: SAS Cloud Analytic Services: User’s Guide
httpPath= Data Connector Option	httpPath="http-path" specifies the HTTP or HTTPS endpoint for a connection. Product: SAS Cloud Analytic Services Document: SAS Cloud Analytic Services: User’s Guide
sslMode= Data Connector Option	sslMode='allow | disable | prefer | require | verify-ca | verify-full' specifies the support mode for a TLS encrypted connection to your data source. Product: SAS Cloud Analytic Services Document: SAS Cloud Analytic Services: User’s Guide