SAS 9.1.3 Integration Technologies » Administrator's Guide (LDAP Version)


SAS Data Sources
Library Data
Column Data
Table Data
Data Sources

Creating a Table Data Source

A table data source is an existing SAS table that is accessible to users through client applications.

The SAS Integration Technologies Administrator provides a graphical user interface that allows you to create an LDAP object definition for a table. Client applications can then use the LDAP definition to access the table.

To add a new table data source using IT Administrator:

  1. Open IT Administrator.

  2. Select the SAS Data Sources button in the in the Manager Bar.

  3. Select the Tables folder in the tree view.

  4. Click the New button (New). The New Table window appears and requests that you enter property information for the new table data source.

    An alternative method for creating a table is to select the Tables folder and select File arrow New arrow Table.

  5. Enter a name and description for the data source. The name identifies the table in the tree view, and the description is visible when the object properties are viewed.

  6. On the Table tab (selected by default), you must enter the table name in the Member Name field. Note that the table must exist and must use the name that is entered in this field.

  7. Enter values for any of the other Table fields as needed. You can find information about the values that are required in each field by selecting the Help button in the New Table window.

  8. To associate the table with a logical name, select the Add button. The Logical Name Info window appears where you can select an existing logical name or create a new one. The logical name that you choose identifies the server on which the table resides. After you have chosen a logical name, select OK to close the Logical Name Info window.

  9. When you are finished entering information in the fields, select OK. The new table definition appears in the tree view.