The data builder can be used to read
source tables from third-party vendor databases and to write tables to them as well. In order to
use this feature, your site must have a
SAS/ACCESS Interface product license for the database that you want to use. 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
registered table from a
library with a Read operation 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, then
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.