Create entry

Essbase vs. Microsoft SQL Server 2017

Essbase Microsoft SQL Server 2017 + Add column
Preference (71% global votes) (20% global votes)
Website www.​oracle.​com/​bi www.​microsoft.​com/​sqlserver
Database model
Data storage
Embeddable No Yes
Query language
Data types
Conditional entry updates Yes Yes
Map and reduce Yes No
Unicode Yes Yes
TTL for entries ? No
Compression Yes Yes
Integrity model ?
Atomicity ? Yes
Consistency ? Yes
Isolation ? Yes
Durability (data storage) Yes Yes
Transactions ? Conditional
Referential integrity ? Yes
Locking model
Secondary Indexes ? Yes
Composite keys ? Yes
Full text search ? Yes
Geospatial Indexes ? Yes
Horizontal scalable Yes Yes
Replication Yes Yes
Replication mode ?
Sharding Yes ?
Shared nothing architecture ? Yes
Value size max. ? 2.15 GB
System requirements
Operating system
Native driver
Memory minimum 64 MB ?
Programming language
Multi-user system Yes Yes
Database ?
Multilingual content Yes ?
Price rating ★★★★☆ ?
Multiple projects Yes ?
Standard compliance Yes Yes
Documentation level ★★★★☆ ★★★★☆
Programming paradigm ?
Free to use No Conditional
Active Yes ?
Real time analytics Yes Yes
Community Driven No No
Web interface Yes Yes
API Good ?
Online backup Yes Yes
Log Yes ?
Implementation flexibility (100% global votes) (0% global votes)
Backup functionality Good Good
Query Cache Yes Yes
Community feedback ★★★★☆ ?
Ease of use ★★★★☆ ?
In-Place Update Yes ?
Free for commercial use No Yes
Sorts Yes Yes
Easy of Use Yes ?
Open Source No No
Triggers Yes Yes
Perfomance ★★★★☆ ★★★★☆
Revenue Tracking Yes ?
Predictive Analytics Yes ?
Stored Procedure Yes Yes
Description ? Relational Database Management System
Object-Relational Mapping (ORM) ? Yes
Database Connection Pooling ? Yes
Data encryption ? Yes
Cloud platform support ?
Key length max ? 68
Materialized Views ? Yes
Server Side Java Script ? No
JSON ? Yes
Flexible Table(Schema) ? Yes
Free edition ? Yes
User and Group role based security model ? Yes
Does your mom understand it ? No
+ Add row ++
Essbase Microsoft SQL Server 2017
  • vsChart is like a wiki

    Just click a data cell to edit it.
    Take part and share your knowledge with the world.

  • blue
    = good
    = better
  • Embed it on your site
  • Copy & Share
  • Creative Commons License License
  • EnglishGerman (Deutsch)

Write a review or comment

Please login (with Facebook, Twitter or OpenID) to use this form.