For more information on connections using the ODBC generic connector, visit our How to guide for configuring ODBC generic types.
The following table highlights the PolyBase features available in SQL Server 2019 (15.x) stand-alone install and SQL Server 2019 (15.x) big data cluster:
FeatureBig Data ClusterStand alone instance Create external data source for SQL Server, Oracle, Teradata, and Mongo DBXX Create external data source using a compatible third-party ODBC DriverX Create external data source for HADOOP data sourceXX Create external data source for Azure Blob StorageXX Create external table on a SQL Server data poolX Create external table on a SQL Server storage poolX Scale-out query executionXX (Windows only)
Important
The Microsoft SQL Server 2019 Big Data Clusters add-on will be retired. Support for SQL Server 2019 Big Data Clusters will end on February 28, 2025. All existing users of SQL Server 2019 with Software Assurance will be fully supported on the platform and the software will continue to be maintained through SQL Server cumulative updates until that time. For more information, see the announcement blog post and Big data options on the Microsoft SQL Server platform.