Creating a Table Data Source

A table data source is an existing SAS table that is accessible to users through applications such as the SAS Information Delivery Portal.

The SAS Integration Technologies Administrator provides a graphical user interface that allows you to create an LDAP object definition for a table. The portal uses the LDAP definition to access the table. For general instructions, see Using IT Administrator.

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 (). 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 New 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.