Table of Contents

Search

  1. Preface
  2. Introduction to PowerExchange for SAS
  3. Installation and Configuration
  4. Working with SAS Sources
  5. Working with SAS Targets
  6. Working with SAS Sessions
  7. Appendix A: SAS Datatype Reference
  8. Appendix B: SPI Server Configuration Parameters
  9. Appendix C: Error Messages

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

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.

0 COMMENTS

We’d like to hear from you!