Microsoft SQL Server and MySQL Integration

Microsoft SQL Server
MySQL

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

Extend your MySQL other workflows with the built-in Microsoft SQL Server node from WEXTL®. Trigger events from MySQL, add the Microsoft SQL Server node where you need it in the flow, and let WEXTL®'s visual builder run the whole automation for you — smart decisions handled by AI, no coding skills required.

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

Learn about Microsoft SQL Server and MySQL

Detailed info you need to know about Microsoft SQL Server and MySQL integrations in WEXTL. Explore which modules apps support and how you connect them.

Microsoft SQL Server

Built-in1 trigger5 actionsRead and change rows in a Microsoft SQL Server or Azure SQL database, run your own query, and start a workflow when new rows appear. Works with SQL Server 2016 or newer, Azure SQL Database, and Amazon RDS for SQL Server. [5]

MySQL

Built-in1 trigger6 actionsRead and change rows in a MySQL or MariaDB database, run your own query, and start a workflow when new rows appear. Works with MySQL, MariaDB, Amazon RDS and Aurora, and other MySQL-compatible servers. [6]

How to connect Microsoft SQL Server to MySQL

Set up your Microsoft SQL Server and MySQL integration in 3 simple steps [2] — no coding required. Up to 10 minutes setup.

How does the integration between Microsoft SQL Server and MySQL work in WEXTL?

WEXTL exposes actions and triggers for Microsoft SQL Server and MySQL 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.

Microsoft SQL Server (built-in)MySQL (built-in)

Microsoft SQL Server modules
  • M
    Delete rowsDelete the rows that match your conditions.
  • M
    Execute a queryRun your own T-SQL, with values passed as parameters.
  • M
    Insert a rowAdd a row to a table and get its new identity value back.
  • M
    Select rowsRead rows from a table with simple conditions, a sort and a limit.
  • M
    Update rowsChange the rows that match your conditions.
  • M
    Watch rowsStart a workflow when new or changed rows appear in a table. Checks on your workflow schedule.
MySQL modules
  • M
    Delete rowsDelete the rows that match your conditions.
  • M
    Execute a queryRun your own SQL, with values passed as parameters.
  • M
    Insert a rowAdd a row to a table and get its new id back.
  • M
    Insert or update a rowAdd a row, or update it when a row with the same key already exists.
  • M
    Select rowsRead rows from a table with simple conditions, a sort and a limit.
  • M
    Update rowsChange the rows that match your conditions.
  • M
    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 Microsoft SQL Server and MySQL integrations. Pick any from the list below if the current combination isn't the one you need.

Alternative integrations to Microsoft SQL Server [5]

Alternative integrations to MySQL [6]

Try Microsoft SQL Server and MySQL on WEXTL®

Claim your 3-day trial to build Microsoft SQL Server with MySQL integration and access every WEXTL® feature.

Cancel anytime.

Frequently asked questions

Common questions about connecting Microsoft SQL Server and MySQL.

References

List of sources used to gather information about the Microsoft SQL Server and MySQL integration.

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

Explore Microsoft SQL Server and MySQL, or get started