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

  1. Navigate to Automations > Integrations.
  2. Search for Oracle.
  3. 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.
  4. 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 NameDescriptionRequired
Query TemplateJinja2 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.

1156

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:

1244

Release Notes

  • v2.0.0 - Updated architecture to support IO via filesystem

© 2017-2021 LogicHub®. All Rights Reserved.