Installing SQL Server

If you intend to use the SQL Agent to replicate data into a Microsoft SQL Server database then please refer to the notes below when installing or configuring the SQL Server for use with the SQL Agent.

SQL Server Version

When replicating data into SQL Server the Streaming Integration Platform makes use of an optional SQL Server component called PolyBase, and specifically PolyBase support for streaming data from a remote Parquet datasource where the Parquet files are hosted in an Amazon S3 compatible network data store. Although PolyBase was released with SQL Server 2019, this support for Parquet file data sources was not supported until SQL Server 2022.

For that reason, the MINIMUM version of SQL Server that can be supported is SQL Server 2022, but the recommended solution is to use the latest GA version, which is currently SQL Server 2025.

SQL Server Edition

The PolyBase feature is available in all editions of SQL Server, so it is appropriate to use one of the Developer or Express editions for development and testing workloads, and either Standard or Enterprise editions for production workloads.

PolyBase

When installing SQL Server, the PolyBase environment is not installed by default. During the installation there is a checkbox to select the feature for installation. Please ensure that you select that option.

Authentication

When the SQL Agent connects to your SQL Server database is does so using SQL Server Authentication. By default when installing SQL Server, only Windows Authentication is supported, so please make sure to select the option to enable both Windows and SQL Server authentication during the installation.