SQL

Learn how to use the SQL action item to build your workflows

Introduction

The SQL Action in DBSync Cloud Workflow enables you to interact with databases directly within your integration flows. Use it to write custom SQL queries that retrieve, insert, update, or delete records in supported databases — whether cloud-based or on-premise.

Use Cases

• Fetch records from a database to feed into the data stream.

• Update records dynamically based on workflow logic.

• Insert new data from integrated apps.

• Delete outdated or unnecessary records.

Key Features

• Works with any connected database (for example, MySQL, PostgreSQL, SQL Server, Oracle).

• Supports dynamic queries using Fx-enabled variables.

• Real-time query results or update counts.

• Customizable batch size for optimized performance.

• Code editor with SQL syntax highlighting.

How to Configure SQL Action

Step 1: Add SQL Action to the Flow

1. In the Flow screen, drag the SQL action from the Actions palette on the left and drop into your flow.

2. Click Configure on the flow panel to configure the flow. Open the Cloud Workflow Development Studio.

3. Drag and drop the SQL Action into your flow.

Step 2: Select a Data Source

1. Choose a database from the Source dropdown.

2. Only connectors of type Database will be shown.

Step 3: Write Your SQL Query

1. Use the SQL editor (with CodeMirror) to build your query.

2. You can insert dynamic fields using the Fx Panel (right-hand side).

SELECT * FROM customers WHERE created_at > 'last_sync_date'

Supported Query Types

Query Type	Result
SELECT	Tabular output in data preview
INSERT	Count of rows inserted
UPDATE	Count of rows updated
DELETE	Count of rows deleted

Output & Execution

1. Preview the results. The data is displayed in a tabular format.

2. Click Run to execute the integration and observe how the flow operates with the connected queries and variables.

Batch Size

You can control processing by setting a custom Batch Size. Useful for large data syncs.

Best Practices

• Use Query Preview before saving changes.

• Sanitize dynamic inputs using filters/validation.

• Keep queries optimized to avoid long-running transactions.

• Leverage batch control in high-volume flows.

Troubleshooting

Problem	Likely Cause	Solution
No results returned	Filters too narrow	Check query logic and variable values
Column not found	Column name mismatch	Check column names in database
Access denied / auth error	Connector credentials invalid	Re-authenticate the connector

The SQL Action is a powerful addition to your DBSync Cloud Workflow, enabling direct and dynamic access to your databases within any flow. Use it to automate data syncing, enrichment, and control - all from a single visual interface.