Table of Contents

Search

  1. Preface
  2. Introduction to TDM Administration
  3. User and Role Administration
  4. Security Administration
  5. System Preferences
  6. TDM Server Administration
  7. Connections
  8. Pass Phrases
  9. Dictionaries
  10. User-Defined Datatypes

SAS Analytics Connections

SAS Analytics Connections

You can create an SAS Analytics connection in Test Data Manager to perform data subset and data masking operations.
The following table describes the database connection properties for an SAS Analytics database:
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.