9.08.2012

Tabular Models vs PowerPivot

Difference between Tabular Models and PowerPivot in SQL Server 2012

S.No
Tabular Models
PowerPivot
1
Scalability:
i.No specified upper size limit
ii.Partitions to process large volumes of data
iii.Supports Direct Query and VertiPaq
Scalability:
i. 2 GB Excel file size limit (for uploading to SharePoint)
ii. No partitioning
iii. VertiPaq only
2
Manageability:
SSMS, AMO, ADOMD, XMLA, Deployment Wizard, PowerShell, Integration Services
Manageability:
Excel / SharePoint
3
Securability:
Row level and dynamic security
Securability:
Excel workbook file security
4
Deveolopment Tool:
Visual Studio
Deveolopment Tool:
Excel

No comments:

Post a Comment