Profitbase Studio Server service is configured by Profitbase Studio Clients to update the data warehouse and the SSAS business cubes defined in the Solution. The recommendation is to install Profitbase Studio Server on the same server platform as Microsoft SQL Server. Below are the recommended minimum specifications for this platform.
Operating System | Recommended: Windows 2017 Server or newer |
Software
|
PS 2023: .Net Framwork 4.7.2 MS Sql Server 2014 -> 2022 ( older version: PS 6.0, 6.1: .NET Framework 4.5 or newer. Microsoft SQL Server 2008, 2012, 2014, 2016 (PS 6.2+), 2017 (PS 6.3+) or 2019 (PS 6.5) Enterprise or BI Edition with:
|
Hardware | 2.6GHz processor with 4 cores and minimum 16 GB memory (or better). |
Storage recommendations | Minimum 100 GB available for data storage. High performance disk system. Several physical disks. Data and log files on different drives for better performance. Consider RAID. Additional disk space is required for large MS SQL and SSAS databases. |
Notes: Every solution should be assessed independently and sized accordingly. For solutions with large volumes and large number of users, a multi-server configuration is recommended. Profitbase Studio Server will also run on Windows 7/8/10.
Profitbase Studio is used to configure and maintain the data warehouse. Profitbase Studio can run standalone with the application and databases running locally which is necessary for demonstrations and recommended for working on data warehouse deployment projects; or can run in conjunction with a Server platform where the SQL Server database and the Profitbase Studio Server are running. Below are the minimum recommended specifications for this platform.
Operating System | Microsoft Windows 10+ or Microsoft Server 2017+ |
Display Resolution |
1280 x 1024 |
Software
|
PS 2023: .Net Framwork 4.7.2 ( older version: PS 6.0, 6.1: .NET Framework 4.5 or newer.PS 6.2, 6.3, 6.4: .NET Framework 4.6 or newer. PS 6.5: .NET Framework 4.6.2 or newer. Standalone installation: Microsoft SQL Server 2008, 2012, 2014, 2016 (PS 6.2+),(2017 (PS6.3+) or 2019 (PS6.5+) Enterprise or BI Edition with Analysis Services and Integration Services is recommended when running in a standalone configuration. Multi-Server installation: When SQL Server is on a different Server, then install: Either
Or from the Microsoft SQL Server feature packs:
|
Hardware |
2.6GHz processor with minimum 4 GB memory (or better). If MS SQL server is installed, see the server requirements. |
Storage | Minimum 10GB available storage for databases and software installation. More disk space may be required depending on space required for local source/demo databases. |
Optional Software |
Internet browser for online help etc. |