Previously,
SAS provided data surveyors that relied on accessing the underlying
database—Oracle, DB2, and SQL Server—and not the application
APIs. SAS provides, through software from Composite Software, both
Service Oriented Architecture (SOA) and SQL data services that unlock
the data in Oracle Applications, Siebel, as well as Salesforce.com.
The following figure shows how SAS interacts with Composite Software:
The Composite Information Server uses a Data Service to access a data
source through the data source's API. The Composite Information Server
then offers the data through an ODBC interface. You configure an ODBC
data source name on the SAS Application Server with the Composite
ODBC driver. Then you use SAS Management Console to register an ODBC
server and an ODBC library. For a detailed example of a Composite
Information Server connection to Salesforce.com, See
Establishing Connectivity to a Composite Information Server.