Oracle Database [On-Prem] Integration in Zoho Flow

Oracle Database [On-Prem]

What is Oracle Database?   

Oracle Database is an enterprise-grade relational database management system (RDBMS) used to store, manage, and securely retrieve structured data at scale, offering high performance, reliability, and advanced data management features.

 How to connect your Oracle Database account to Zoho Flow 

  1. Select the required trigger or action. If you select a trigger, click Next.
  2. Oracle Database connection
    3. i. If there are no existing Oracle Database connections in your account, click Connect.

             

      Else, choose a connection from the dropdown and click Test to check if the connection is working fine.
    ii. Alternatively, you can create a new connection by navigating to Settings, then Connections. Click Create connection and          choose Oracle Database.
    iii. Configure the following fields to create the connection:
                
                

    • On-Prem Agent: Select the installed On-Prem Agent to connect to your Oracle Database securely.

    • Connection Name: A unique name to identify this Oracle Database connection within Zoho Flow.

    • Host: The URL of your hosted server

    • Port: The port number that your server is running on, typically 1521.

    • Username: Your Oracle Database username

    • Password: Your Oracle Database password

    • Service Name: The name of the Oracle Database service that you want to access

    • Enable SSL?: The option to use SSL (Secure Sockets Layer) for encrypted communication between the Oracle Database client and server

    iv. Once configured, click Authorize.
  3. Choose either Table or View from the dropdown 'Type' depending on the data source you want to work with.
  4. Fill in all the required fields such as Table and Trigger column and then click Done.

 Triggers and actions available in Zoho Flow 

Triggers
Actions
Triggers

Row added

Use this trigger to automate actions whenever a new record is added to a Oracle Database table. For example, you can send a notification or update another database when a new order is added to your ecommerce platform.

Row added or updated

This trigger can be used to keep data synchronised between different systems. For example, if a customer's contact information is added or updated in your Oracle database, you can automatically update their profile in your email marketing tool.

Note:

To use the Row added and the Row added or updated triggers, you need to configure the following fields:

  • Trigger column: Select a unique column with incremental values — ideally timestamp columns such as created_at, updated_at, published_at, etc.  By default, the result is sorted in ascending order, and the limit is 100.

  • Where condition: Use a Where condition to filter the rows. Zoho Flow will retrieve only rows added after the last execution of the flow, so you receive only the latest updates that satisfy the Where condition.


You can use Filter criteria when using these triggers to selectively pass information based on your custom criteria instead of passing the entire payload.
Actions

Fetch row

This action is useful for scenarios where you need to access specific data based on a primary or unique key. For example, if you have an order number and want to retrieve all details of that order, you can use this action to fetch the row and perform further actions like sending order confirmation emails.
Note: Up to 100 records can be fetched in a single execution.

To use the Fetch row action, you need to configure the following fields:

  • Unique key: A primary key or a column with a unique constraint to deduplicate rows. An indexed column will give better results.

  • Unique key - Value: The value of the unique key.

  • Additional key: Apart from the unique key, you can also add another column as an additional key for deduplication.

  • Additional key - Value: The value of the additional key.

 

Insert row

Use this action to add new data to your Oracle database. For example, when a user submits a form on your website, you can use this action to insert their information into your customer database.

Update row

This action allows you to update existing records in your Oracle Database table. For example, if a customer requests to change their email address, you can use this action to update the email field in your database.