Integrating SQL Server Analysis Services with Hadoop

on YouTube ↗01h 13m

" summary

Shows a working pipeline that ingests IIS web logs into a Cloudera quickstart VM, creates Hive tables and views, and exposes that data to Analysis Services so cubes and tabular models query it. Demonstrates Hive ODBC + linked server for multidimensional SSAS and tabular connects direct via ODBC, uses SSDT for development, notes need for 32‑bit dev drivers vs 64‑bit production, and reports demos succeed though query latency can be significant on large file sets.

AI-written summary · about

" chapters (9)

1. 0:00Start
2. 2:09Sponsors
3. 7:23Hadoop Architecture
4. 9:40The Big Data Bandwagon
5. 32:32Odbc Data Source Administrative Window
6. 44:42Difference between a Multi-Dimensional and a Tabular Model
7. 47:42Configuring Hive Odbc Drivers
8. 57:14Is It Possible To Link To Hadoop Directly from Ss Is To Read Write without Creating Linked Server
9. 1:01:04Do We Need To Create Same Odbc Dsn Name in 32 vs 64 Bit

" related talks

• 59mPeanut Butter and Chocolate: Integrating Hadoop with SQL ServerKevin Feasel · NDC Sydney 2017
• 53mHailing Frequencies: Analysis Services Terms and ConceptsMark Vaillancourt · PASS Business Analytics Conference 2013
• 07mIn-Hadoop Analytics: Bringing analytics to big dataAnjul Bhambhri · Strata Conference 2014
• 49mAnalytics in SQL Server and Azure SQL Databasechuck heinzelman, Ajay Jagannathan · SQLBits 2023
• 52mPower BI + Azure Synapse Analytics. All you need to start creating a unified analytics solutionPawel Potasinski · SQLBits 2023
• 47mImplement a Serverless Data Analytics strategy with Microsoft AzureRoberto Freato · DevDays Europe 2022
• 52mApache Lens: Cut Data Analytics Silos In Your EnterpriseAmareshwari Sriramadasu · Great Indian Developer Summit 2015
• 07mComplementary Solutions with HadoopTasso Argyros · Strata Conference New York + Hadoop World 2013