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 |
|---|---|---|
| Compose SDK | X | ✓ |
| 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 available, with increased capacity and support for 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 | ||
| Databricks | X | ✓ |
| Athena Live | X | ✓ |
| Custom Connector Platform | X | ✓ |
| Synapse | X | ✓ |
| Connector plug-ins | X | ✓ |
| Connectors memory consumptions | 5GB | 2GB
(no memory consumption in a future release) |
| Analytical Experience | ||
| Analytical Engine | X | ✓ |
| Improved formula validation | X | ✓ |
| Shared Formula | X | ✓ |
| Augmented Analytics | ||
| Notebook tab | X | ✓ |
| Sisense Narratives | ✓ | ✓ (excluding pivots) |
| Live | ||
| Dynamic Import Query | X | ✓ |
| 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 | ||
| Self-contained Multitenancy | X | ✓ |
| UI Customization | ✓ | ✓ |
| Themes and user based rebranding | 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 | ✓ |
| OpenShift 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 | ✓ |
| 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 Data Source Connectors.
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 cannot 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 Deploying a Custom Connector.