Integration with SQL Server is one of the most exciting aspects of PolyBase V2, but it is by no means the only one. Microsoft has also provided out-of-the-box support for three major providers: Oracle, MongoDB, and Teradata. Because the mechanisms are the same between these three drivers, we will focus in this chapter on connecting to Microsoft’s Cosmos DB using the MongoDB connector rather than performing a deep dive into each provider separately. We will then briefly review integration with Oracle and wrap up this chapter with a note on integration with Teradata.
Get PolyBase Revealed: Data Virtualization with SQL Server, Hadoop, Apache Spark, and Beyond now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
