Oracle Database Integration

Read and change rows in an Oracle Database (12.2 or newer), run your own query, and start a workflow when new rows appear. Connects straight to the database; no Oracle client software needed. Add Oracle Database as a step in any automation on WEXTL. Combine it with app integrations and other built-in workflow nodes to move data, coordinate teams, or route logic across your stack.
3-day trialCancel anytimeUp to 10 minutes quick set up
  • GDPR
  • Data Encryption
  • 2FA
  • Local Data Region

Supported triggers and actions for Oracle Database integration

Triggers can detect changes in Oracle Database and run actions that can create, search or modify data inside Oracle Database automatically [3] — exactly how you set them.

  • Watch rowsStart a workflow when new or changed rows appear in a table. Checks on your workflow schedule.
  • Delete rowsDelete the rows that match your conditions.
  • Execute a queryRun your own SQL or PL/SQL block, with values passed as parameters.
  • Insert a rowAdd a row to a table and get its ROWID back.
  • Select rowsRead rows from a table with simple conditions, a sort and a limit.
  • Update rowsChange the rows that match your conditions.

How to integrate Oracle Database in automation workflow?

3 simple steps to make your Oracle Database connected with other apps in automation workflows on WEXTL. Up to 10 minutes integration set up.

Connect Oracle Database to popular apps on WEXTL

Enter a name of the other app you want to sync with Oracle Database below. Click on selected app to explore integration options with Oracle Database. If the app you search for is not available in WEXTL yet, you can use HTTP node [10] instead to integrate it directly.

Example automation with Oracle Database integration

Select Watch rows trigger from Oracle Database - this will be a starting point in your automation. Whenever event happens in Oracle Database, workflow will start [7] from Watch rows node.

Search for Delete rows, connect it as the next step of integration sequence. You can use filters between Watch rows and Delete rows, so only important data pass from Watch rows to the next step. WEXTL gives you full control over the process of Oracle Database automation. All parts of workflow are visible on the canvas [4].

Oracle Database on WEXTL has 6 modules for building built-in automations. Explore Oracle Database documentation for more.

Oracle Database
Watch rows
Database
Performs action
OR
Database
Triggers
Oracle Database
Delete rows

Demonstration of how visual Oracle Database automation [6] looks in WEXTL.

Frequently asked questions

Common questions about automating Oracle Database in your workflows.

Try Oracle Database on WEXTL®

Claim your 3-day trial to build Oracle Database integrations and access every WEXTL® feature.

Cancel anytime.

References

List of sources used to gather information about the Oracle Database integration.

  1. Oracle Database integration source code, module specs and credentials implementation.
  2. Internal Oracle Database integration documentation, structured input and output parameters, scopes, and authentication methods.
  3. This is a built-in WEXTL® workflow node — see the Visual Workflow Builder capability page for how it's used on the canvas.
  4. WEXTL® Visual Workflow Builder, anonymized data from our technical support team.
  5. WEXTL® Apps Library
  6. WEXTL® Oracle Database App Documentation
  7. WEXTL® Workflow Scheduler
  8. WEXTL® HTTP node documentation