Requirements and compatibility
Lyftrondata operates as a Windows Service and is entirely self-hosted, therefore no additional Windows components are required, besides explicitly stated dependencies below.
Lyftrondata makes the following recommendations for Lyftrondata Server deployments:
- A dedicated machine to simplify tuning, management, and diagnostics
- Windows Active Directory
- Multi-core server hardware with two or more cores for production deployments
The disk I/O performance of any modern server-class system should be sufficient. Memory requirements are highly dependent on the product target usage, but 8 GB of RAM is sufficient for most deployments that do not heavily utilize built-in Apache Spark. For small deployments, 4 GB of RAM is sufficient and should be considered a minimum, unless the specific deployment is tested and verified to require less memory.
Supported database management systems for caching
Lyftrondata supports multiple database platform to cache and process materialized data:
- Apache Spark™
- 2.3.x (built-in)
- Azure HDInsight™
- SAP HANA™
- Microsoft SQL Server™
- Microsoft SQL Data Warehouse™
Deployment of each of the platforms is project specific. Please follow the recommendations and practices documented by respective vendors.
NOTE: regarding Spark 2.1.1 - there's a known bug that causes this version to fail during startup. Please contact us if you are using this version of Spark.
Server operating systems
- Windows Server 2019 (This version is recommended)
- Windows Server 2016
- Windows Server 2012 R2 (Essentials, Standard, Datacenter)
- Windows Server 2012 (Essentials, Standard, Datacenter)
- Windows Server 2008 R2 (minimum SP1) (Standard, Enterprise, Datacenter)
Server core Windows Server installations are not supported.
Lyftrondata Server can be installed on a 64-bit Windows operating system. We recommend using a server OS unless your Lyftrondata instance is for evaluation or personal use.
Client operating systems
- Windows 10 x64 (Professional, Enterprise)
- Windows 8.1 x64 (Professional, Enterprise)
- Windows 7 x64 (minimum SP1) (Professional, Enterprise, Ultimate)
Required platforms and components
.Net Framework 4.5.2 or later
Note that only Windows 10 client operating systems have .Net 4.5.x built-in. All other systems require .Net 4.5.x from Windows Update or from an offline installer, that can be found under .Net 4.5.2 offline installer.
.Net Framework 4.6 or later is recommended
Oracle JRE x64 v8 or higher (optional)
If compatible JRE is found at the time of installation it will automatically be used. In other cases, a built-in Zulu JRE 1.8 will be installed and used as Java runtime.
Lyftrondata supports the virtualization of Lyftrondata Server in supported virtualization environments: Microsoft Hyper-V or VMWare. Other platforms were not tested with Lyftrondata but every virtualizer that is certified to work with the supported version of Windows should work fine.
Two databases are required: Lyftrondata Metadata Database and Apache Spark MetaStore Database, each hosted on the supported Microsoft SQL Server instance specified during installation.
The following versions of SQL Server are supported for Lyftrondata MetaBase and Apache Spark MetaStore:
- Sql Server 2019 or later (This version is recommended)
- SQL Server 2016
- SQL Server 2014
- SQL Server 2012 (minimum SP1)
Your limits on database read operations
Lyftrondata does not support any read operations against the Lyftrondata or Apache Spark databases that originate from queries, scripts, .dll files, etc, not provided by Lyftrondata or its support teams. If Lyftrondata Support determines that those read operations prevent them from solving your problem, the entire database will be unsupported. To return the database to a supported state, all unsupported read operations must stop.
SQL Server editions
Lyftrondata supports Express, Standard, and Enterprise editions of SQL Server or SQL Azure v11 or later. The Express edition is only recommended for evaluation purposes, personal use, or for small teams. We recommend SQL Server Standard, Enterprise or SQL Azure v11 or later for all other scenarios.
You can install Lyftrondata on a single server that is joined to an Active Directory domain or that is a member of a workgroup.
Active Directory environment is not required by Lyftrondata but is fully supported and recommended for enterprise deployments.
You may use different accounts to install and run Lyftrondata Server:
- Dedicated local account
- Dedicated domain account
Best practices for accounts:
- Use Network Service or a dedicated domain account, because they present network credentials, allowing Lyftrondata to transparently authenticate against data sources that support Windows Integrated Authentication
- Use accounts that have permissions to authenticate users against a domain, because it allows Lyftrondata to authenticate incoming users by Windows Integrated Authentication
Lyftrondata Server requires a service account. That service account becomes the identity for the installed Windows Service handling requests to Lyftrondata.
During installation, you have to specify a user account. The Log on as a service permission will be granted by installer automatically. You must not use the account that you use to install Lyftrondata. For example, if you are logged in as domain\user1 when you install Lyftrondata, do not use domain\user1 as the account for Lyftrondata.
Warning: The service user account should not be a member of Local Administrators group on Windows. In such case, required permissions will be granted to Administrators group, not the account itself. If at a later time, such account administrators group membership is revoked, you will have to manually grant necessary permissions or reinstall Lyftrondata.
Installer grants Log on as a service permission to selected account only during installation.
It is not recommended to manually change the service user account after installation. Please reinstall Lyftrondata Server if you need to change the service user account.
If reinstallation of Lyftrondata Server is not desired or possible, and manual change of the service user account after installation is absolutely necessary, you must ensure that:
- The Log on as a service permission is granted to the new service user,
- The read and write permissions to Apache Spark warehouse directory are granted to the new service user,
- Necessary permissions to access Lyftrondata Metabase and Spark Metabase deployed on SQL Server are granted to the new service user,
- Necessary permissions to access data sources are granted to the new service user,
- Necessary http.sys port reservations are available to the new service user.
Lyftrondata can scale from a basic installation on a laptop used by a single person all the way up to a highly available deployment used by thousands of people. The following recommendations should apply to most Lyftrondata deployments, but your requirements may vary depending on the usage of your team. For example, if you have a particularly large data set that you want to materialize using built-in Apache Spark, you may need higher specification machines than what is listed below. Note that all of the machines discussed below could be either physical or virtual.
A single machine, with one dual-core processor, 8 GB of RAM, and a fast hard disk drive. Scaling the server up can enable it to handle a larger number of users and workload.
For evaluation or personal use, you can use a basic configuration with as little as 4 GB of RAM, but this would not be recommended for a production server used by more than one person.
You can install Lyftrondata on supported operating systems in various languages. However, Lyftrondata user interface is available only in US English.
You can use these browsers with Lyftrondata to access it with the web client.
|Browser||Supported Version||Known issues|
|Chrome||most recent (recommended)|
|Internet Explorer||11 and later||May not render Apache Spark application portal properly. For example, query plans will not show up|
Edge, Firefox, and Chrome automatically update themselves, so Lyftrondata supports the most recent version.
Lyftrondata software may be provided with certain third-party software, including but not limited to open-source software, which is licensed under its applicable third-party software license agreement. For license information about third-party software distributed with Lyftrondata software, refer to your Lyftrondata license agreement.