Microsoft SQL Server 2012 with Hadoop

Integrate data between Apache Hadoop and SQL Server 2012 and provide business intelligence on the heterogeneous data.

 DETAIL

• Author: Debarchan Sarkar
• Language: English
• Published: 2013
• Page: 96
• Size: 3 MB
• Format: pdf

CONTENTS

Preface

Chapter 1: Introduction to Big Data and Hadoop

Big Data – what's the big deal?

The Apache Hadoop framework

Chapter 2: 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

Chapter 3: Using the Hive ODBC Driver

The Hive ODBC Driver

SQL Server Integration Services (SSIS)

Developing the package

Chapter 4: Creating a Data Model with SQL Server Analysis Services

Configuring the SQL Linked Server to Hive

Creating an SSAS data model

Chapter 5: Using Microsoft's Self-Service Business Intelligence Tools

PowerPivot enhancements

Power View for Excel

Index

DOWNLOAD HERE