Database Reference
In-Depth Information
Figure 1-6.
Enterprise BI solution
Data sources for such models are typically external data that can be matched on a key to existing data in your data
store so that it can be used to augment the results of analysis and reporting processes. Following are some examples:
•
Social data, log files, sensors, and applications that generate data files
•
Datasets obtained from Windows Data Market and other commercial data providers
•
Streaming data filtered or processed through SQL Server StreamInsight
■
Microsoft streamInsight is a Complex event processing (Cep) engine. the engine uses custom-generated
events as its source of data and processes them in real time, based on custom query logic (
standing queries
and
events
).
the events are defined by a developer/user and can be simple or quite complex, depending on the needs of the business.
Note
You can use the following techniques to integrate output from HDInsight with enterprise BI data at the report
level. These techniques are revisited in detail throughout the rest of this topic.
•
Download the output files generated by HDInsight and open them in Excel, or import them
into a database for reporting.
•
Create Hive tables in HDInsight, and consume them directly from Excel (including using
Power Pivot) or from SQL Server Reporting Services (SSRS) by using the Simba ODBC driver
for Hive.
