PacktLib: Microsoft SQL Server 2012 with Hadoop

Microsoft SQL Server 2012 with Hadoop

Credits

About the Author

About the Reviewer

www.PacktPub.com

Preface

Introduction to Big Data and Hadoop

Big Data – what's the big deal?

The Apache Hadoop framework

Summary

Using Sqoop – The SQL Server Hadoop Connector

The SQL Server-Hadoop Connector

Downloading the SQL Server-Hadoop Connector

Installing the SQL Server-Hadoop Connector

The Sqoop import tool

The Sqoop export tool

Summary

Using the Hive ODBC Driver

The Hive ODBC Driver

SQL Server Integration Services (SSIS)

Developing the package

Summary

Creating a Data Model with SQL Server Analysis Services

Configuring the SQL Linked Server to Hive

Creating an SSAS data model

Summary

Using Microsoft's Self-Service Business Intelligence Tools

PowerPivot enhancements

Power View for Excel

Summary

Index