SAS Scalable Performance
Data (SPD) Server provides ODBC and JDBC access to SPD Server data
stores from all supported platforms. When the appropriate drivers
are installed on the network, SPD Server allows queries on tables
from third-party applications that do not use SAS software. SPD Server
provides the following connectivity options:
-
ODBC (Open Database Connectivity):
ODBC is an interface standard that provides a common interface for
accessing databases. Many software applications running in a Windows
environment are compliant with ODBC and can access data created by
other software. ODBC is a good choice if you have client machines
running Windows applications, such as Microsoft Excel or Microsoft
Access.
-
JDBC (Java Database Connectivity):
JDBC is an interface standard that provides a common interface for
accessing databases by Java programs. JDBC is a good choice if you
have Java applications running that need access to SPD Server tables.