Configure an On-Premise Application Server and Storage
This guide walks through the steps to configure an on-premises server for Jet Analytics Data Integration. For a cloud-based deployment or the remaining configuration steps, see Configure your Data Integration Environment.
Choose and deploy the desired server configuration
There are multiple options for server configuration depending on where you want to host the Jet Analytics Data Integration application, services, and SQL Server databases.
Consolidated BI server
- Jet Analytics services and SQL Server databases are all installed on the same Windows server.
- Easier to maintain and offers some performance advantages due to zero network latency.
Separate application and database servers
- Jet Analytics services are installed on an application server and the SQL databases are stored on a separate database server.
- This setup reduces risk by ensuring additional applications are not installed on the database server and users do not need to sign in to it directly.
Hardware configuration
There are no minimum hardware requirements for Jet Analytics Data Integration beyond those required by Microsoft SQL Server. Analytics environments vary significantly between organisations and performance is affected by many factors. We recommend conducting your own testing and/or obtaining a recommendation from a qualified professional. The following table provides general guidelines for optimal performance.
| Server | Hard disk | 64-bit CPU | RAM |
|---|---|---|---|
| Application Server | 256 GB SSD | 4 core | 16 GB |
| Application Server (greater than 1 TB of source data) | 256 GB SSD | 4 core | 32 GB |
| Database Server | 1 TB SSD | 8 core | 32 GB |
| Database Server (greater than 1 TB of source data) | 25 TB SSD | 16 core | 64 GB |
Note: When creating databases in SQL Server, always place the data files and log files on separate disk drives. Placing them on the same disk creates contention between the files and results in poor performance. Separate disks allow both to be written to simultaneously, ensuring optimal I/O throughput.
Install Jet Analytics Data Integration and set up instances
Install Jet Analytics Data Integration, the Jet Analytics Ingest Service, and the Jet Analytics Execution Service on your application server, then set up your instances. See Install Jet Analytics Data Integration and How to Configure Data Integration for instructions.