SQL Server Setup Guide

SQL Server Connector

Bidirectional SQL Server connector via agent. Supports table scans, custom queries, INSERT/UPSERT/UPDATE.

Overview

SQL Server connector dispatched to agent for secure on-premises access. Handles column mapping, type coercion, incremental sync.

  • • Table scan or custom SQL query modes
  • • MERGE/UPSERT/UPDATE operations
  • • Primary key-based incremental sync

Prerequisites

AetherFlow Agent with sqlserver capability and DB network access.

Configuration

Source Configuration

server / database
SQL Server details
queryMode
table or custom
tableName / customQuery
Depending on mode

Target Configuration

tableName
Target table
operationMode
insert, upsert, update
primaryKeyColumn
Required for upsert/update

Connection Testing

Success: Agent-dispatched connection verified.

Common Issues

No agent with sqlserver capability
Install agent and add --capabilities sqlserver.