Consuming and visualizing data from HDInsight
From: Developing big data solutions on Microsoft Azure HDInsight
This section of the guide describes a variety of ways to consume data from HDInsight for analysis and reporting. It explores the commonly used tools in the Microsoft data platform that can integrate directly or indirectly with HDInsight. It also demonstrates how you can create useful and attractive visualizations of information that you generate using HDInsight. Figure 1 shows a high level view of the options for consuming and visualizing data from HDInsight.
Figure 1 - Some typical options for consuming data from HDInsight
Figure 1 represents a map that shows the various routes through which data can be delivered from an HDInsight cluster to client applications. The client application destinations shown on the map include Excel and SQL Server Reporting Services (SSRS). You can also create custom applications, or use common enterprise BI data visualization technologies such as PerformancePoint Services in SharePoint Server to consume data from HDInsight—directly or indirectly—using the same interfaces.
The topics and technologies discussed in this section of the guide are:
- Microsoft Excel
- SQL Server Reporting Services
- SQL Server Analysis Services
- SQL Server database
- Building custom clients
Security is also a fundamental concern in all computing scenarios, and big data processing is no exception. Security considerations apply during all stages of a big data process, and include securing data while in transit over the network, securing data in storage, and authenticating and authorizing users who have access to the tools and utilities you use as part of your process. For more details of how you can maximize security of your HDInsight solutions see the topic Security in the section Building end-to-end solutions using HDInsight.
More information
For more information about HDInsight, see Microsoft Azure HDInsight.
For more information about the tools and add-ins for Excel see Power BI for Office 365.
For more information about the HDInsight .NET SDKs see HDInsight SDK Reference Documentation on MSDN.