MQTT and Oracle Database Integration

MQTT
Oracle Database

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

MQTT is a WEXTL® built-in workflow node — it ships with the platform and drops straight into any Oracle Database workflow you build. Pick a Oracle Database trigger or action below, then add MQTT to the canvas in one click. Full visual setup, 3 simple steps, no code and no extra credentials to configure.

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

Learn about MQTT and Oracle Database

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

MQTT

Built-in1 trigger1 actionPublish messages to an MQTT broker, and start a workflow when messages arrive on the topics you subscribe to. Works with MQTT 5 brokers such as Mosquitto, EMQX, HiveMQ and AWS IoT Core. [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 MQTT to Oracle Database

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

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

WEXTL exposes actions and triggers for MQTT 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.

MQTT (built-in)Oracle Database (built-in)

MQTT modules
  • M
    Publish a messagePublish a message to a topic and wait for the broker to confirm it (QoS 1).
  • M
    Watch messagesStart a workflow when messages arrive on the topics you subscribe to. Checks on your workflow schedule.
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.

Explore alternative integrations

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

Alternative integrations to MQTT [5]

Alternative integrations to Oracle Database [6]

Try MQTT and Oracle Database on WEXTL®

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

Cancel anytime.

Frequently asked questions

Common questions about connecting MQTT and Oracle Database.

References

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

  1. MQTT and Oracle Database integration source code, module specs and credentials implementation.
  2. Our MQTT and Oracle Database integration documentation, structured input and output parameters, scopes, and authentication methods.
  3. Official vendor API documentation for MQTT 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. MQTT integration information
  6. Oracle Database integration information
  7. WEXTL® Scheduling
  8. WEXTL® Pricing and Trial
  9. WEXTL® Apps Library

Explore MQTT and Oracle Database, or get started