Frequently asked questions

APPLIES TO: yesSQL Server noAzure SQL Database noAzure SQL Data Warehouse noParallel Data Warehouse

PolyBase VS. linked servers

The following table highlights the differences between PolyBase and linked server features:

PolyBase Linked Servers
Database scoped object Instance scoped object
Uses ODBC drivers Uses OLEDB providers
Supports read-only operations for all data sources and insert operation for HADOOP & data pool data source only Supports both read and write operations
Queries to remote data source from a single connection can be scaled-out Queries to remote data source from a single connection cannot be scaled-out
Predicates push-down is supported Predicates push-down is supported
No separate configuration needed for availability group Separate configuration needed for each instance in availability group
Basic authentication only Basic & integrated authentication
Suitable for analytic queries processing large number of rows Suitable for OLTP queries returning single or few rows
Queries using external table cannot participate in distributed transaction Distributed queries can participate in distributed transaction

What's new in PolyBase 2019?

PolyBase in SQL Server 2019 can now read data from a larger variety of data sources. The data from theses external data sources can be store as external tables on your SQL Server. PolyBase also supports push-down computation to these external data sources, excluding ODBC generic types.

Compatible Data Sources

  • SQL Server
  • Oracle
  • Teradata
  • MongoDB
  • Compatible ODBC generic types

Note

PolyBase can allow connection to external data sources using third party ODBC drivers. These drivers are not provided along with PolyBase and may not work as intended. For more information, visit our guide for PolyBase ODBC generic configuration.

PolyBase in big data clusters vs. PolyBase in stand-alone instances

The following table highlights the PolyBase features available in SQL Server 2019 stand-alone install and SQL Server 2019 big data cluster:

Feature Big data cluster Stand alone instance
Create external data source for SQL Server, Oracle, Teradata, and Mongo DB X X
Create external data source using a compatible third-party ODBC Driver X
Create external data source for HADOOP data source X X
Create external data source for Azure Blob Storage X X
Create external table on a SQL Server data pool X
Create external table on a SQL Server storage pool X
Scale-out query execution X X

Note

The table does not describe the functionality available in the latest SQL Server 2019 CTP. For the available features, please reference the release notes. For more information on connections using the ODBC generic connector visit our How to guide for configuring ODBC generic types.