Archive and Oracle Database Integration

Archive
Oracle Database

Demonstration of how apps are integrated in WEXTL workflow builder [4]

Combine the built-in Archive node with Oracle Database on the WEXTL® visual workflow builder. Drop Archive anywhere in your Oracle Database automation to run its logic between steps — the two live side by side on the same canvas, so you build the whole flow visually without a single line of code.

3-day trialCancel anytimeUp to 10 minutes quick set up
  • GDPR
  • Data Encryption
  • 2FA
  • Local Data Region

Learn about Archive and Oracle Database

Detailed info you need to know about Archive and Oracle Database integrations in WEXTL. Explore which modules apps support and how you connect them.

Archive

Built-in8 actionsCompress, decompress, and archive files inside a workflow. Create and extract ZIP, tar, tar.gz, and gzip archives, or compress raw data on the fly. [5]

Oracle Database

Built-in1 trigger5 actionsRead 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. [6]

How to connect Archive to Oracle Database

Set up your Archive and Oracle Database integration in 3 simple steps [2] — no coding required. Up to 10 minutes setup.

How does the integration between Archive and Oracle Database work in WEXTL?

WEXTL exposes actions and triggers for Archive and Oracle Database that help you connect apps and automate repetitive tasks [1]. A trigger is an event that happens, an action — a step that performs when the event has occurred.

Oracle Database (built-in)Archive (built-in)

Oracle Database modules
  • O
    Delete rowsDelete the rows that match your conditions.
  • O
    Execute a queryRun your own SQL or PL/SQL block, with values passed as parameters.
  • O
    Insert a rowAdd a row to a table and get its ROWID back.
  • O
    Select rowsRead rows from a table with simple conditions, a sort and a limit.
  • O
    Update rowsChange the rows that match your conditions.
  • O
    Watch rowsStart a workflow when new or changed rows appear in a table. Checks on your workflow schedule.
Archive modules
  • A
    Create TAR / TAR.GZCombine one or more files into a tar or tar.gz archive.
  • A
    Create ZIPCombine one or more files into a ZIP archive.
  • A
    Deflate CompressCompress data using the deflate method.
  • A
    Extract TAR / TAR.GZExtract the files from a tar or tar.gz archive, as separate items or one bundle.
  • A
    Extract ZIPExtract the files from a ZIP archive, as separate items or one bundle.
  • A
    Gunzip DecompressDecompress a gzip file back into its original data.
  • A
    Gzip CompressCompress data into a gzip file.
  • A
    Inflate DecompressDecompress deflate-compressed data back into its original form.

Explore alternative integrations

There are other apps [9] supported by WEXTL that can be paired with Archive and Oracle Database integrations. Pick any from the list below if the current combination isn't the one you need.

Alternative integrations to Archive [5]

Alternative integrations to Oracle Database [6]

Try Archive and Oracle Database on WEXTL®

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

Cancel anytime.

Frequently asked questions

Common questions about connecting Archive and Oracle Database.

References

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

  1. Archive and Oracle Database integration source code, module specs and credentials implementation.
  2. Our Archive and Oracle Database integration documentation, structured input and output parameters, scopes, and authentication methods.
  3. Official vendor API documentation for Archive and Oracle Database — used to verify field meanings, authentication flows, and anything our own specs don't fully capture.
  4. WEXTL® visual workflow builder, anonymized data from our technical support team.
  5. Archive integration information
  6. Oracle Database integration information
  7. WEXTL® Scheduling
  8. WEXTL® Pricing and Trial
  9. WEXTL® Apps Library

Explore Archive and Oracle Database, or get started