Supported SQL Server Versions

2016, 2017

Encoding Support

Automatically recognizes the encoding of SQL Server, no need for setup.

Connection Preview Support

Supports regular tables, does not support views or other special tables.

SQL Query Dataset Support for SQL

Only supports SELECT statements, supports all SELECT-related features supported by the connected SQL Server. Users need to ensure the syntax complies with SQL Server standards.

SQL Server Authentication Method Support

Supports username and password methods, does not support SSL authentication methods.

Unsupported Field Types

The following types of columns in SQL Server tables cannot be processed correctly. If you need other fields from this table, you can input a SELECT statement in the SQL query, excluding this field.

• hierarchyid
• rowversion
• sql_variant
• xml
• geometry
• geography