PowerExchange for SAS User Guide for PowerCenter

10.5.4
- 10.5.9
- 10.5.8
- 10.5.7
- 10.5.6
- 10.5.5
- 10.5.3
- 10.5.2
- 10.5.1
- 10.5
- 10.4.0

Back Next

Configuring a SAS Relational Database Connection

Use a relational connection object for each SAS source or target that you want to access. The relational database connection defines how the PowerCenter Integration Service accesses the underlying database for SAS. When you configure a SAS connection, you specify the connection attributes that the PowerCenter Integration Service uses to connect to SAS.

The following table describes the properties that you configure for a SAS connection:

Property	Description
Name	Name of the active SAS connection.
Host	Host name of the machine running the SPI Server.
Port	Port number of the machine running the SPI Server. Must correspond to the port number used in configuring the SPI Server.
Code page	Code page used for the connection.
User Name	User name with the appropriate permissions to access SAS data.
Password	Password for the user.

Rename Saved Search

Table of Contents

PowerExchange for SAS User Guide for PowerCenter

PowerExchange for SAS User Guide for PowerCenter

Configuring a SAS Relational Database Connection

Configuring a SAS Relational Database Connection