Connecting to Data Servers

Establish that your users can connect to the SAS Metadata Server and the system's SAS Workspace Servers. Then ensure that users can access the input data sources to SAS Data Integration Studio jobs. Here are some examples of these sources:

• DB2 tables

• Sybase tables

• Teradata tables

• ODBC data sources

• Oracle tables

• SAS data sets

• SAS Scalable Performance Data Engine tables

• Register your data sources (see the SAS Intelligence Platform: Data Administration Guide).

• View data sources in SAS Data Integration Studio.

To determine whether your data integration developers are able to read data from a particular data server, follow these steps:

1. In the Inventory tree, expand the Table node.

2. Right-click a data source and select Open to display the View Data window.

Copyright © 2009 by SAS Institute Inc., Cary, NC, USA. All rights reserved.