Execute SQL using OLE DB / ODBC / AS400

What it does

This action reads from, writes to, or queries a database-style data source. The migration depends on the original provider, table or query shape, credentials, gateway requirements, and how returned values are used later in the workflow.

How Flow Migrator maps it

Flow Migrator maps this to HTTP/API database review placeholder using HTTP / Custom connector / Database connector. Preserves provider, connection constant, SQL query, and output variables. Replace with DB2/IBM i, custom connector, or another final database implementation. Flow Migrator can preserve and generate the core mapping, but this action should be reviewed after import.

Common migration issues

• Review the generated action after import because some Nintex behavior does not map one-to-one to Power Automate.
• Confirm connection references, gateway setup, server/database names, table names, primary keys, credentials, and returned result shape.
• Review HTTP method, URI, headers, authentication, retry behavior, premium licensing, and response parsing.

Validation checklist

1. Review this item before export or immediately after import.
2. Open the generated flow and confirm the action card imported correctly.
3. Validate connection references and required settings before running the flow.
4. Test with representative source data from the original workflow.
5. Confirm gateway connectivity, primary key handling, query filters, and returned data shape.