{"product_id":"0881626960813","title":"Cuatro Tigres","description":"Getting SQL Server talking to Hadoop is a smooth process when you follow this tutorial. Learn all the tools and techniques you need integrate the data and then extract powerful business insights from the merged result.\u003cp\u003eOverview\u003c\/p\u003e\u003cp\u003eIntegrate data from unstructured (Hadoop) and structured (SQL Server 2012) sources\u003cbr\u003e Configure and install connectors for a bi-directional transfer of data\u003cbr\u003e Full of illustrations, diagrams, and tips with clear, step-by-step instructions and practical examples\u003c\/p\u003e\u003cp\u003eIn Detail\u003c\/p\u003e\u003cp\u003eWith the explosion of data, the open source Apache Hadoop ecosystem is gaining traction, thanks to its huge ecosystem that has arisen around the core functionalities of its distributed file system (HDFS) and Map Reduce. As of today, being able to have SQL Server talking to Hadoop has become increasingly important because the two are indeed complementary. While petabytes of unstructured data can be stored in Hadoop taking hours to be queried, terabytes of structured data can be stored in SQL Server 2012 and queried in seconds. This leads to the need to transfer and integrate data between Hadoop and SQL Server.\u003c\/p\u003e\u003cp\u003eMicrosoft SQL Server 2012 with Hadoop is aimed at SQL Server developers. It will quickly show you how to get Hadoop activated on SQL Server 2012 (it ships with this version). Once this is done, the book will focus on how to manage big data with Hadoop and use Hadoop Hive to query the data. It will also cover topics such as using in-memory functions by SQL Server and using tools for BI with big data.\u003c\/p\u003e\u003cp\u003eMicrosoft SQL Server 2012 with Hadoop focuses on data integration techniques between relational (SQL Server 2012) and non-relational (Hadoop) worlds. It will walk you through different tools for the bi-directional movement of data with practical examples.\u003c\/p\u003e\u003cp\u003eYou will learn to use open source connectors like SQOOP to import and export data between SQL Server 2012 and Hadoop, and to work with leading in-memory BI tools to create ETL solutions using the Hive ODBC driver for developing your data movement projects. Finally, this book will give you a glimpse of the present day self-service BI tools such as Excel and PowerView to consume Hadoop data and provide powerful insights on the data.\u003c\/p\u003e\u003cp\u003eWhat you will learn from this book\u003c\/p\u003e\u003cp\u003eUse the Native SQOOP Connector for data movement between SQL Server 2012 and Hadoop\u003cbr\u003e Configure and use the Hive ODBC driver to enable any ODBC compliant client to consume Hadoop data\u003cbr\u003e Create ETL solutions and automate data movement jobs between SQL Server 2012 and Hadoop using SQL Server Integration Services\u003cbr\u003e Provide powerful reporting on the integrated data with just a matter of a few clicks using Microsoft self-service BI tools\u003cbr\u003e Merge structured and unstructured data together in a common warehouse for analysis, which is essential\u003c\/p\u003e\u003cp\u003eApproach\u003c\/p\u003e\u003cp\u003eThis book will be a step-by-step tutorial, which practically teaches working with big data on SQL Server through sample examples in increasing complexity.\u003c\/p\u003e\u003cp\u003eWho this book is written for\u003c\/p\u003e\u003cp\u003eMicrosoft SQL Server 2012 with Hadoop is specifically targeted at readers who want to cross-pollinate their Hadoop skills with SQL Server 2012 business intelligence and data analytics. A basic understanding of traditional RDBMS technologies and query processing techniques is essential.\u003c\/p\u003e","brand":"Boston: David C. Cook Publishing Company, 1908","offers":[{"title":"Default Title","offer_id":47089917722864,"sku":"0881626960813","price":11.99,"currency_code":"USD","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0737\/7593\/9824\/files\/0881626960813_p0.jpg?v=1763531444","url":"https:\/\/shop-qa.barnesandnoble.com\/products\/0881626960813","provider":"Barnes \u0026 Noble (DEV)","version":"1.0","type":"link"}