Sisense on Linux vs Windows
The following table provides a feature comparison between Sisense on Windows and Sisense on Linux:
Feature | Sisense Windows | Sisense Linux |
---|---|---|
ElastiCube design via desktop ElastiCube Manager | ✓ | Replaced by the data tab in the Sisense web application |
ElastiCube sets | ✓ | EC sets are unneeded in the native cloud architecture |
Data Groups | X | ✓ |
Dashboard Usage Analytics | ✓ | ✓ |
Build and query usage analytics | X | ✓ |
NLQ | X | ✓ |
Funnel chart | Certified add-on | ✓ |
Explanations | X | ✓ |
Statistics on data preview | X | ✓ |
Pivot Table | ||
Sorting by subtotals | ✓ | ✓ |
Data bars | ✓ | ✓ |
Export to PDF (by rows) | 1,000 | 1,000 |
Export to Excel | ✓ |
✓ (New improved export engine, increased capacity, supports native Excel types) |
Embedded images | ✓ (certified add-on) | ✓ |
Exporting
|
||
PNG & PDF | ✓ |
✓ New Exporting Engine (enables script operation, improved security and performance) |
Build | ||
Concurrent build scale | 4 builds | 20 builds |
Build queue | X | ✓ |
Build nodes | 1 | Unlimited (auto-scale) |
Pre-pst build plugins | dll | bash |
Custom code/jupyter notebook | X | ✓ |
Build to destination | X | ✓ |
Export and Import of Add-ons | X |
✓ |
Connectors | ||
Synapse | X | ✓ |
Connector plug-ins | X | ✓ |
Connectors memory consumptions | 5GB | 2GB (no memory consumption in a future release) |
Augmented Analytics | ||
Notebook tab | X | ✓ |
Sisense narratives | ✓ | ✓ (excluding pivots) |
Live | ||
Live IN for Filters | X |
✓ |
Live multi-schema | X | ✓ |
Live prevent random path - Samba | X |
✓ |
Live Date -> Time Hierarchy |
X |
✓ |
Live Weeks support | X |
✓ |
Live custom table and column | X | ✓ |
Live optimized query | X | ✓ |
Live pivot query limit | X |
✓ |
Live show SQL | X | ✓ |
Live cancel query | X | ✓ |
Live readable query | X |
✓ |
Pulse alerts over Live | X | ✓ |
Leverages new translation engine and improved SQL functions | X | ✓ |
Case insensitive text filters |
X |
✓ (configurable) |
Live dynamic connections | X | ✓ |
Live Box and Whisker plot widget | X |
✓ |
Live Statistical Functions: Rsum, Ravg, XTD, Median, Mode, PERCENTILE, QUARTILE, VARP | X |
✓ |
Original data types | X |
✓ |
Fiscal year | X |
✓ |
Administration | ||
UI Customization | ✓ |
✓ |
Themes and user based re-branding | X | ✓ |
Custom fonts | X |
✓ |
Web Access Token | X | ✓ |
Internal monitoring for offline | X | ✓ |
Granular email management | X | ✓ |
Administrative search | X | ✓ |
Log collection (combined from GUI) |
X | ✓ |
Audit | X | ✓ |
Web file management | X | ✓ |
Desktop ECM | ✓ | X |
Pre-installed certified plug-ins | X |
✓ |
Limit Shares (OOB) | X |
✓ |
Server side plug-ins | Unmanaged | Managed with resource in a single process |
Change user activation period |
X |
✓ |
Configuration if new users can be created through sharing |
X |
✓ |
Deployment | ||
Multi-Node static assets, configuration sync | Manual | Automatic shared storage |
High availability for clustered deployment | Legacy | Kubernetes |
Cluster auto-scale | X | ✓ |
Multi-namespace | X | ✓ |
Auto recovery | X | ✓ |
Service health and recovery | X | ✓ |
Kubernetes and container deployment | X | ✓ |
Helm deployment | X | ✓ |
Resource limits | X | ✓ |
Monitoring API | X | ✓ |
Enhanced internal monitoring (Grafana) | X | ✓ |
Git integration | X | Supported in a future release |
Open shift support | X | ✓ |
Inline upgrade | X | ✓ |
Secure communication between nodes | Complex SSL tunnels | Secure weave network |
Centralized log aggregation | X | ✓ |
Logging retention | X | ✓ |
Configurable log level | Manual | CLI and UI |
APIs | ||
CLI | X | ✓ |
Multi tenancy | X | Supported in a future release |
PSM.exe | ✓ | Functionality replaced by the Linux CLI and REST API |
Backup and restore | X | ✓ |
Scale and performance | X | ✓ |
Front End Add-ons (Note: Some functionalities exist as add-ons in Windows and are out-of-the-box in Linux) | ||
Advanced formula | ✓ | X |
Filters | ||
AND/OR Filter blocks relationship |
X |
✓ |
Filter editors |
Limited functionality |
Enhanced functionality |
Design Capabilities
|
||
Admin Look & Feel (dashboard & widget design) |
X |
✓ |
Individual group rebranding |
X |
✓ |
Note:
For the list of supported connectors, see Introduction to Data Sources.
General Limitations
- Sisense for Windows handles boolean field types differently to Sisense for Linux. If you use the boolean field type, when migrating to Sisense for Linux, enable the boolToTextCapitalized feature so that Sisense for Linux correctly resolves lower-case boolean values as upper-case.
- Windows authentication can’t be used as an authentication method in Sisense for Linux.
- Generic ODBC and OLE DB drivers aren't supported in Sisense for Linux. Instead, use JDBC connectors. For more information, see Creating a JDBC Connection.
.r.