Progress DataDirect forJDBC for Oracle Service Cloud
The Progress DataDirect forJDBC for Oracle Service Cloud Driver supports standard SQL query language to provide read-only access to data managed by the Oracle Service Cloud Web service. In addition, the driver supports the Oracle RightNow CX API version 1.2 for sites using Oracle Service Cloud February 2014 or later.
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 ROQL (Oracle RightNow query language) 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 that 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 Client-Side Caches for details.
The driver can be used with industry standard tools, which means developers can leverage their existing SQL knowledge instead of having to learn ROQL and Oracle RightNow CX API. Examples include the following tools:
SAP Crystal Reports
Hibernate
Oracle WebLogic
Spring for JDBC
The following figure shows the different components of an environment that uses the driver to access Oracle Service Cloud.
When an application connects to Oracle Service Cloud through the driver, the driver establishes a Web service session with an 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. For details, see Using the Database Configuration File and Views and Remote/Local Tables.
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 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 getExportedKeys(), getImportedKeys(), and getPrimaryKey() 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
