About Access to DBMS Data

The data builder can be used to read source tables from third-party vendor databases and to write tables to them as well. The SAS/ACCESS Interface products provide this feature. The user ID and password that you use to log on to the data builder might not be valid for a third-party vendor database. If this is the case, then you are prompted for credentials to the DBMS when you access a table from the database with a Read or a Write operation. As an alternative to being prompted, you can store a login in metadata that has valid DBMS credentials. For more information, see "How to Store Passwords for a Third-Party Server" in SAS Intelligence Platform: Security Administration Guide.

If you are prompted for credentials and supply an invalid user ID or password, you are denied access to the data. In this case, you can select FileClear Credentials Cache to remove the invalid credentials from your session. The next time you access the data source, you are prompted again.

Third-party databases are often more restrictive about column names or length than SAS. For more information, see "DBMS-Specific Naming Conventions" in SAS/ACCESS for Relational Databases: Reference.