The Progress DataDirect forODBC for Oracle Service Cloud driver supports standard SQL query language to provide read-only access to data managed by the Oracle Service Cloud.
In addition, the driver supports the Oracle RightNow CX API version 1.2 against sites whose version is February 2014 or higher.
Note: You can also query the SYSTEM_REMOTE_SESSIONS table in the INFORMATION_SCHEMA schema to get version information.
The driver translates the SQL statements provided by the application to Oracle RightNow queries (ROQL) and Web service calls. See "Supported SQL Statements and Extensions" for information about the SQL statements that the driver supports.
The driver maps the Oracle Service Cloud data model to a set of relational tables. The mapping representation is stored in XML files external to the driver, which allows the sharing of map files among different client machines. See "Mapping Objects to Tables" for details.
The driver uses a client-side data cache for improved performance. You can define rules that specify which data to cache on the client as well as when the cached data becomes invalid and needs to be refreshed. See "Using Client-Side Caches" for details.
The Oracle Service Cloud driver can be used with industry standard tools, which means developers can leverage their existing SQL knowledge instead of having to learn the Oracle RightNow query language and API. Examples include the following tools:
SAP Crystal Reports
Hibernate
Oracle WebLogic
The following figure shows the different components of an environment that uses the Oracle Service Cloud Driver to access the Oracle Service Cloud.
When an application connects to the Oracle Service Cloud through the driver, the driver establishes a Web service session with the Oracle Service Cloud instance and a database session that opens an embedded database. The application can establish multiple sessions with Oracle Service Cloud; however, additional Web service and database sessions are always opened in the ratio of one database session per Web service session. The database session maintains the object-to-relational table mapping. In addition, it maintains cached tables and local tables, as well as maintaining views. See "Using the Database Configuration File" for details.
Oracle Service Cloud has certain standard objects that always exist, even if they do not contain anything. Oracle Service Cloud administrators can also create custom objects using the Oracle Service Cloud administration utility. The relationships among these objects are tabular, like those among the tables in a database. The Oracle Service Cloud driver recognizes the relationships among both standard objects and custom objects and can access and update both. The relationships among objects can be reported through the SQL ForeignKeys and SQLPrimaryKeys metadata methods. The driver is optimized to leverage Oracle Service Cloud mechanisms for joining data, minimizing the amount of data that needs to be fetched over the network. See "Mapping Objects to Tables" for details.
SAP Crystal Reports
