The database used by
the SAS Web Infrastructure Platform must be configured in the Web
application server as a JDBC data source. The JDBC data source is
configured with the JDBC driver and connection information for the
selected database. These settings are provided to the SAS Deployment
Wizard during installation and configuration. You need to know the
JDBC connection parameters if you make changes later, such as changing
the connection to access a database on another machine. JDBC connection
settings typically require a user ID and password for access to the
data source.
The default database
for SAS Web Infrastructure Platform is the SAS Framework Data Server.
The JDBC connection parameters for the SAS Framework Data Server are
provided in the following table:
JDBC Connection Parameters for SAS Framework Data Server
|
|
|
|
|
jdbc:sastkts:// serverName:port?stmtpooling=0&constring=(DSN=SharedServices;encoding=UNICODE_FSS)
In the URL, substitute
the server name and port number of the SAS Framework Data Server at
your site. The default port is 22031.
|
|
|
These settings are configured
during initial deployment. However, you need to know the connection
information if you make changes later, such as moving the SAS Framework
Data Server to another host system.
Note: You must specify the user
name and password values as required to access the data source.
The SAS Drivers for
JDBC are used to connect to the SAS Framework Data Server. The JAR
files in the following list must be in the same directory as the JDBC
driver to connect with the SAS Framework Data Server:
-
-
-
-
-
sas.intrnet.javatools.jar
-
sas.intrnet.javatools.nls.jar
-
-
-
-
-
-
sas.svc.connection.nls.jar
To modify the settings
for a JDBC data source, see the documentation for your Web application
server.