Oracle Database
App Vendor: Oracle Database
App Category: IT Services
Connector Version: 1.0.0
API Version: NA
About App
Oracle Database is a proprietary multi-model database management system used for running online transaction processing (OLTP), data warehousing (DW), SQL, and mixed (OLTP & DW) database workloads.
The Oracle Database app is configured with Cyware Orchestrate to perform the following actions:
Action Name | Description |
|---|---|
Run Query | This action runs an SQL query |
Configuration Parameters
The following configuration parameters are required for the Oracle Database app to communicate with the Oracle Database enterprise application. The parameters can be configured by creating instances in the app.
Parameter | Description | Field Type | Required/Optional | Comments |
|---|---|---|---|---|
Username | Enter the username used to connect with Oracle Database. Example: user | Text | Required | |
Password | Enter the password | Password | Required | |
Host | Enter the host machine the Database resides Example: database-1-.amazonaws.com | Text | Required | |
Port | Enter the port used to connect to the Database Example: 1521 | Text | Required | |
Database | Enter the name of the Database to connect to Example: DATABASe | Text | Required |
Action: Run Query
This action runs an SQL query in the Oracle Database.
Action Input Parameters
Parameter | Description | Field Type | Required/Optional | Comments |
|---|---|---|---|---|
Query | Enter the query to run. Example: update employees set name = 'Example Set Name' where emp_id = 1 | Text | Required |