Property | Description |
|---|---|
Name | Required. Name of the connection. The name is not case sensitive and must be unique within the domain. It cannot exceed 128 characters, start with a number, contain spaces, or contain the following special characters: ~ ` ! $ % ^ & * ( ) - + = { [ } ] | \ : ; " ' < , > . ? / |
Connection Type | Required. The connection type. Select SAS Analytics. |
Description | The description of the connection. The description cannot exceed 255 characters. |
User Name | Required. The database user name. |
Password | Required. The password for the database user name. |
Owner | The owner of the connection. Default is the user who creates the connection. You can change the owner of the connection. |
Code Page | The code page that the Integration Service uses to extract data from the source database. |
Data Access Connection String | The connection string used to access data from the database. Enter <servername@dbname>. |
Host Name | Host name of the machine that runs the SPI Server. |
Port | Port number of the machine that runs the SPI Server. Must correspond to the port number used to configure the SPI Server. |
Library Name | The library name from which PowerCenter reads or writes to the SAS table. You can override the library name in the session properties. |
Post SAS Code | Value for the PostSASCode exit. Enter a SAS Macro or a SAS %include statement to run just after the reading of the SAS Source object. The SPI Server must be configured for SAS exits to run. The SAS Macro to be invoked must be defined in the autoexec.sas file that is part of the SPI Server configuration. |
Pre SAS Code | Value for the PreSASCode exit. Enter a SAS Macro or a SAS %include statement to run just before the reading of the SAS Source object. The SPI Server must be configured for SAS exits to run. The SAS Macro to be invoked must be defined in the autoexec.sas file that is part of the SPI Server configuration. |
Where Clause | Enter a selection of rows from the SAS source. This Where clause creates a WHERE statement in SAS. |
Indexes | Index for the SAS connection definition. |
Key Index | Key index for the SAS connection definition. The key index designates the key that identifies each row to use in an update else insert load. |
Library Name PREC | Determines how the library name is represented in the mapping. |