Database Reference
In-Depth Information
•
Use Sqoop to transfer the results from HDInsight into a relational database for reporting. For
example, copy the output generated by HDInsight to a Windows Azure SQL Database table
and use Windows Azure SQL Reporting Services to create a report from the data.
•
Use SQL Server Integration Services (SSIS) to transfer and, if required, transform HDInsight
results to a database or file location for reporting. If the results are exposed as Hive tables, you
can use an ODBC data source in an SSIS data flow to consume them. Alternatively, you can
create an SSIS control flow that downloads the output files generated by HDInsight and uses
them as a source for a data flow.
Summary
In this chapter, you saw the different aspects and trends regarding data processing and analytics. Microsoft HDInsight
is a collaborative effort with the Apache open source community toward making Apache Hadoop an enterprise-class
computing framework that will operate seamlessly, regardless of platform and operating system. Porting the Hadoop
ecosystem to Windows, and combining it with the powerful SQL Server Business Intelligence suite of products, opens
up different dimensions in data analytics. However, it's incorrect to assume that HDInsight will replace existing
database technologies. Instead, it likely will be a perfect complement to those technologies in scenarios that existing
RDBMS solutions fail to address.
