- Overview
- Setup Guide
- Permissions
- Troubleshooting
Data streams
This Provider Plugin defines 0 data streams.| Stream | Description | Sync |
|---|---|---|
| — | This Provider Plugin has no data streams to choose. | — |
Oracle Database
What You’ll Need
| Credential | What it is |
|---|---|
| Username | Oracle Cloud username |
| Password | Oracle Cloud password |
| Host | Oracle Cloud host (e.g., fa-abcd-saasfaprod1.fa.ocs.oraclecloud.com) |
| Port | Database port (e.g., 1521) |
| Service Name | Oracle service name (e.g., ORCL) |
| Base URL | Oracle REST API base URL |
Info: Setup access in Oracle Cloud. These steps require Administrator, or a colleague with equivalent permissions who can create credentials for you. If that is not you, ask your Oracle Cloud administrator.
- Integration Specialist or equivalent role
- REST API access enabled for your instance
- Understanding of Oracle Cloud data model
Step 1: Identify Your Instance URL
Your Oracle Cloud instance URL format:https://server-instance.fa.us6.oraclecloud.com
Step 2: Create Integration User
For best practices, create a dedicated integration user:- Navigate to Security Console → Users
- Create a new user:
parable_integration - Assign required roles (see permissions below)
Step 3: Assign Required Roles
The integration user needs these roles:| Role | Purpose |
|---|---|
Financial Analyst | Read financial data |
Integration Specialist | API access |
Employee | Basic data access |
Warning: Grant only the minimum roles required for your use case.
Step 4: Note Your Credentials
| Credential | Value |
|---|---|
| Username | parable_integration |
| Password | (your secure password) |
| Instance URL | https://your-instance.fa.us6.oraclecloud.com |
Step 5: Enter values in the form
- Enter Username, Password, Host, Port, Service Name, and Base URL in the Provider form.
- Click Save & test connection.
This Provider Plugin does not declare any data streams.
Tip: Rate Limits: Oracle Cloud rate limits vary by service. Parable waits and tries again when Oracle Cloud limits requests, so the first sync of a large dataset can take longer.
| Error | Meaning | Solution |
|---|---|---|
401 Unauthorized | Invalid credentials | Verify username and password |
403 Forbidden | Missing role | Add required role to user |
404 Not Found | Wrong endpoint | Check the Base URL in the connection |
500 Internal Server Error | Server issue | Contact Oracle support |