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.