canonical: https://jentic.com/apis/oracle.com

# Oracle APIs

Oracle's REST APIs on Jentic cover three distinct enterprise surfaces: Oracle Eloqua Marketing Cloud for B2B marketing automation, Oracle REST Data Services (ORDS) for REST access to an Oracle Database, and Oracle BPM Suite for driving 12c process instances and human tasks. Together they let an agent move data between marketing operations, the operational database, and long-running business processes over a common HTTP interface.

## For AI agents

An agent can sync and segment Eloqua contacts and campaigns, query and update Oracle Database tables through ORDS AutoREST and custom resource modules, and start, suspend, or resume Oracle BPM process instances while acting on human tasks. It can chain these so marketing data, database records, and process state stay aligned across the three APIs.

## Scope

Use for: Reaching Oracle Eloqua marketing automation, Oracle Database via ORDS REST, and Oracle BPM Suite process and human-task operations over HTTP from external tooling and agents

Not supported:
- database backup
- SOA composite deployment
- ad campaign management
- BPMN process modelling
- transactional email delivery
- RMAN operations

## APIs

| API | Category | Endpoints | Description |
| --- | --- | --- | --- |
| Oracle Eloqua Marketing Cloud Service REST API | marketing | 358 | Manage Eloqua contacts, accounts, campaigns, emails, and bulk imports across the Application and Bulk REST APIs against an Eloqua instance. |
| Oracle REST Data Services API | storage | 51 | Query Oracle Database tables and views over REST, call custom ORDS resource modules, and manage ORDS OAuth2 clients and database administration endpoints. |
| Oracle BPM Suite REST API | productivity | 20 | Start, inspect, suspend, and resume Oracle BPM 12c process instances and act on human tasks, attachments, and comments over REST. |

## Cross-API use cases

### Persist BPM Process Outcomes to Oracle Database

When an Oracle BPM process instance completes or a human task is acted on, write the outcome to an Oracle Database table so downstream systems and reports read a consistent record. The agent watches BPM instance and task state and lands each result through an ORDS AutoREST endpoint.

Example prompt: Poll GET /4.0/tasks for completed tasks, then POST /{schema}/{object}/ through ORDS to record each outcome

### Marketing Engagement Warehouse in Oracle

Pull Eloqua campaign and contact activity through bulk export and load it into an Oracle Database schema via ORDS batchload, giving marketing ops a queryable engagement store without a separate ETL tier. The agent runs the Eloqua export, waits for it to finish, then ingests the rows.

Example prompt: Create an Eloqua bulk export of contact activities, poll until complete, then POST /{schema}/{object}/batchload with the rows

### Process-Driven Lead Handoff

Route a new Eloqua lead into an Oracle BPM process for review and follow-up, so marketing-qualified contacts trigger a governed business workflow. The agent creates or updates the Eloqua contact, then starts a BPM process instance carrying the lead details.

Example prompt: POST /api/REST/1.0/data/contact in Eloqua, then POST /4.0/processes/{processDefId}/instances in BPM Suite with the lead payload

## Why Jentic

- **Setup:** Wiring Oracle's three APIs by hand means handling Eloqua's dual Bearer and Basic auth and per-instance host, choosing among ORDS Basic, OAuth2, and Bearer auth against your own deployment, and building the BPM Suite Basic Auth header for WebLogic. Through Jentic you install once, add each Oracle API from the Jentic directory, store each credential once, and your agent calls them.
- **Permission scoping:** Your own rules choose which operations each Oracle API exposes to the agent. You can let it read Eloqua contacts and query an ORDS schema object while keeping BPM process suspend, ORDS batchload, or contact writes out of the allowed set unless you add them.
- **Credential handling:** Each Oracle credential, whether the Eloqua token, an ORDS OAuth2 client, or the BPM WebLogic Basic Auth pair, is stored once and encrypted by your own Jentic One instance and injected at execution time. The raw secrets never enter the agent's prompt, logs, or context.
- **Discovery method:** Agents search the Jentic directory by intent such as 'create an Eloqua contact', 'query an Oracle table', or 'list my BPM human tasks', and Jentic returns the matching operation with its input schema so the agent calls the right endpoint across all three APIs without browsing the reference docs.

## Related vendors

- **Salesforce** — CRM commonly synced with Eloqua for B2B lead-to-opportunity flow and paired with database and workflow systems
- **ServiceNow** — Workflow and ITSM platform often used alongside Oracle BPM for ticket-driven processes
- **Snowflake** — Cloud data warehouse paired with Oracle for analytics offload of operational and marketing data
- **HubSpot** — Marketing automation alternative to Eloqua for SMB and mid-market teams

## FAQ

### What can I do across Oracle's APIs on Jentic?

You can run B2B marketing automation in Eloqua, read and write Oracle Database records through ORDS, and drive BPM Suite process instances and human tasks. Because all three are reachable over the same HTTP interface, an agent can move data between marketing, the database, and business processes in a single workflow.

### Do these three Oracle APIs share one credential?

No. Each API has its own credential and host. Eloqua uses a Bearer or Basic credential against a per-instance host, ORDS accepts Basic, OAuth2, or Bearer against your own deployment, and BPM Suite uses Basic auth against its WebLogic server. You configure each one separately.

### Which Oracle API should I use for storing data?

Oracle REST Data Services is the storage-facing API: it exposes tables and views as REST resources through AutoREST, supports bulk ingest through batchload, and hosts custom modules backed by SQL or PL/SQL. Eloqua and BPM Suite are for marketing automation and process work respectively, not general data storage.

### Are these Oracle APIs hosted by Oracle or self-managed?

ORDS and BPM Suite typically run on customer-managed infrastructure, so their throughput depends on how you size the database and servers rather than a vendor quota. Eloqua is a hosted cloud service reached at a per-instance host. This mix means practical limits differ across the three.

### Can an agent combine marketing data with the Oracle Database?

Yes. A common pattern is to bulk-export Eloqua contact and campaign activity, then load it into an Oracle schema through ORDS batchload for querying and reporting. The agent runs the Eloqua export, waits for it to complete, and ingests the result through ORDS.

### How does Jentic handle Oracle's different auth models?

Jentic stores each Oracle credential separately, encrypted, in your own Jentic One instance and injects it at execution time. Whether an operation needs the Eloqua token, an ORDS OAuth2 client, or the BPM Basic Auth credential, the raw secret never enters the agent's prompt, logs, or context.