Tables
The driver models the data in Oracle Service Cloud into a list of tables that can be queried using standard SQL statements.
Generally, querying Oracle Service Cloud tables is the same as querying a table in a relational database. Sometimes there are special cases, for example, including a certain column in the WHERE clause might be required to get data for certain columns in the table. This is typically needed for situations where a separate request must be made for each row to get certain columns. These types of situations are clearly documented at the top of the table page linked below.
CData JDBC Driver for Oracle Service Cloud Tables
| Name | Description |
| Accounts | The account represents a staff member in Oracle B2C Service. |
| Answers | The knowledge base information that provides solutions to the common customer support questions. |
| AnswerVersions | The versioned instance of an answer. Answers are solutions to common customer support questions. |
| Assets | The product or service associated with an organization's customers. |
| ContactMarketingRosters | The information about the contact lists used in audiences in Oracle Service Cloud Outreach Cloud Service. |
| Contacts | The customers or end users of Oracle B2C Service site. |
| Countries | The details about the countries and provinces which are used to maintain accurate address information for the organizations and contacts in Oracle B2C Service. |
| EventSubscriptions | The event-based subscription management object that allows external applications to discover objects that can be subscribed. |
| Holidays | The list of holidays in your organization. |
| Incidents | The question or the request for help submitted by a customer through the Ask a Question page, email, a chat session, site or answer feedback, or from an external source using the API. |
| Opportunities | The information about a specific sale or a pending deal with a contact or an organization that is tracked and maintained in the Oracle B2C Service knowledge base. |
| Organizations | The company, business unit of a large company, or government agency that has an organization record in the Oracle B2C Service knowledge base. |
| PurchasedProducts | The information about a purchased product. |
| SalesProducts | The items or services sold by an organization. |
| SalesTerritories | The specific geographical sales region. Sales representatives can be assigned specific territories for opportunity assignment. |
| ServiceCategories | The hierarchical service category that provides an option to group answers and incidents for better organization and refined searching in the knowledge base. |
| ServiceDispositions | The hierarchical service disposition that provides an option for classifying and recording how incidents are ultimately resolved. |
| ServiceProducts | The hierarchical service product that provides an option to group answers and incidents for better organization and refined searching in the knowledge base. |
| StandardContents | The preformed text or HTML content that can be sent to customers when responding to incidents, appended to responses by a business rule, or sent by an agent during a chat session. |
| Tasks | The information about an action or an activity scheduled to be completed within a specified time. |
| Variables | A shortcut defined for a larger string that can be inserted in the body of an answer or inserted inline during a chat session. |