Oracle
Version: 2.0.0
Oracle Database is a proprietary multi-model database management system produced and marketed by Oracle Corporation. It is a database commonly used for running online transaction processing, data warehousing and mixed database workloads.
Connect Oracle with LogicHub
- Navigate to Automations > Integrations.
- Search for Oracle.
- Click Details, then the + icon. Enter the required information in the following fields.
- Label: Enter a connection name.
- Reference Values: Define variables here to templatize integration connections and actions. For example, you can use https://www.{{hostname}}.com where, hostname is a variable defined in this input. For more information on how to add data, see 'Add Data' Input Type for Integrations.
- Verify SSL: Select option to verify connecting server's SSL certificate (Default is Verify SSL Certificate).
- Remote Agent: Run this integration using the LogicHub Remote Agent.
- Server Name or Hostname of Database: example, 192.168.1.1 or mydatabase.example.com.
- Port (Optional): Specify the port on which database server is listening to default is 1521.
At least one of the following fields are required: - Database Service Name: Service Name of Oracle Database Instance
- Database SID: SID of Oracle Database Instance.
- Username: Username for connecting to the database.
- Password: Password for connecting to the database.
- After you've entered all the details, click Connect.
Actions for Oracle
Query
Query Oracle Database
Input Field
Choose a connection that you have previously created and then fill in the necessary information in the following input fields to complete the connection.
| Input Name | Description | Required |
|---|---|---|
| Query Template | Jinja2 Template e.g following are some examples - Select id, name from customers where city_id = {{city_id_column_name}} - {{query_column_name}} - Select id, date, amount from orders - Update customers set name = ‘new name’ where id = 3 Here variables inside curly braces {{}} refer to the column of the parent node’s results table. | Required |
Output
If the query returns results, for example, select * from orders, the following will be the one row of the output.
In case the query does not return results, for example, update customers set name = ‘new name’ where id = 3. The output would be the following:
Release Notes
v2.0.0- Updated architecture to support IO via filesystem
Updated about 1 year ago