Oracle

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.

Integration with LogicHub

Connecting with Oracle

To connect to Oracle following details are required:

  • Label: 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.
  • 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.

Actions with Oracle

Query

Query Oracle Database

Inputs to this Action:

  • Connection: Choose connection that you have created
  • 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.

Output of Action:
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:


Did this page help you?