With the rise of Hadoop in the world of data, SQL Server has responded with the ability to query Hive tables using Polybase technology. See how to create connections, formats and external tables from within SQL Server 2016. Once the External tables are created, you can reference them like any other table. We also have new components within SSIS to perform HDFS File Transfers, Hive and Pig commands without logging into Hadoop. This presentation will review Polybase and SSIS Component features to get you up and running into Hadoop and SQL Server integration.
Guest Speaker: Jonathan Bloom
Jon is Senior Data Analytics Consultant at Allegient with a primary focus on Business Intelligence and Data Warehousing. Jon has over 25 years professional experience with experience in Azure Data Platform and Cortana Analytics, Data Warehousing, Hadoop, ETL, OLAP, Reports, Dashboards, Master Data Services, Data Quality Services, Hadoop, Power BI and Tableau. He has also maintains a well followed technical blog for over ten years on current trends in information technology.