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 (e.g., 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. Open the Cloud Workflow Development Studio.

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

Step 2: Select a Data Source

1. Choose a database from the Data Source dropdown.

2. Only adapters of type DatabaseAdapter 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

Use {{...}} to reference dynamic variables in your query.

Example: Dynamic Query

SELECT id, name FROM orders WHERE status = '{{order_status}}'

This pulls orders with a status provided by an earlier step in the workflow.

Output & Execution

1. Click Run to preview the results.

2. SELECT → Displays data in tabular format.

3. INSERT/UPDATE/DELETE → Shows how many records were affected.

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.