Overview

Oracle Cloud Database (Autonomous DB + DB Cloud Service) is Oracle's managed database in OCI. The Automize Oracle Cloud connector covers SQL execution + DB operations via REST.

Regions: OCI regions globally.
Plans: Pay-per-OCPU + storage.

Setting up the connection

OCI Console → DB user with REST API enabled.
In Automize → Settings → Connectors → Oracle Cloud. Paste connection details + credentials.

Find your credentials at https://cloud.oracle.com/.

Rate limits

Per-DB capacity.

Data model

Oracle DB primitives:

    DB Instance ─── Schemas ─── Tables ─── Rows

Available operations

10 operations available. Click any row to jump to its detail.

Operation	Category	What it does
Bulk Insert	General	Insert rows in batches
Call Procedure	General	Call a stored procedure
Execute	General	Execute an INSERT/UPDATE/DELETE statement
Execute Many	General	Execute a statement with multiple parameter sets
Export CSV	General	Export query results to a CSV file
Import CSV	General	Import a CSV file into a table
List Columns	General	List columns of a table
List Tables	General	List tables in the database
Query	General	Execute a SELECT query and return results
Table Exists	General	Check if a table exists

Operations

Bulk Insert

Insert rows in batches

Parameter	Required	Type	Description
Table `table`	Yes	text
Columns `columns`	Yes	textarea
Data `data`	Yes	textarea
Rows `rows`	Yes	list	List of row dicts
Batch Size `batch_size`	No	integer	Batch size

Call Procedure

Call a stored procedure

Parameter	Required	Type	Description
Procedure `procedure`	Yes	text
Params `params`	No	textarea

Execute

Execute an INSERT/UPDATE/DELETE statement

Parameter	Required	Type	Description
Sql `sql`	Yes	text
Params `params`	No	textarea

Execute Many

Execute a statement with multiple parameter sets

Parameter	Required	Type	Description
Sql `sql`	Yes	text
Params List `params_list`	Yes	textarea

Export CSV

Export query results to a CSV file

Parameter	Required	Type	Description
Sql `sql`	Yes	text
File Path `file_path`	Yes	text
Params `params`	No	list	Bind parameters

Import CSV

Import a CSV file into a table

Parameter	Required	Type	Description
Table `table`	Yes	text
File Path `file_path`	Yes	text
Has Header `has_header`	No	boolean	CSV has header row

List Columns

List columns of a table

Parameter	Required	Type	Description
Table `table`	Yes	text
Schema `schema`	No	string	Schema name

List Tables

List tables in the database

Parameter	Required	Type	Description
Schema `schema`	No	text

Tips

Per schema.

Query

Execute a SELECT query and return results

Parameter	Required	Type	Description
Sql `sql`	Yes	text
Params `params`	No	textarea

Table Exists

Check if a table exists

Parameter	Required	Type	Description
Table `table`	Yes	text
Schema `schema`	No	string	Schema name

FAQ

Autonomous DB?: Oracle's self-tuning, self-securing DB. Autonomous Transaction Processing + Autonomous Data Warehouse variants.

Oracle Cloud integration