On-Premise Installation Guide

This document guides system administrators in a step-by-step process to install Data+ 5 on premise.

What do I need in order to start?

  • SQL Server
  • IIS with Web Platform Installer
  • Open firewall (Details)
  • Sublime text editor
  • Our installation files

Data+ 5 system requirements

The system and hardware requirements to run Data+ are listed below. For information about earlier versions, contact our support. Data+ 5 does not include any deprecated features.

Operating system requirements

The following 32/64-bit operating systems satisfy the minimum operating system requirements.

Supported operating systems Comments
Windows Server 2016 Standard, Enterprise and Datacenter Latest update
Windows Server 2014 R2 Standard, Enterprise and Datacenter Latest update
Windows Server 2014 Standard, Enterprise and Datacenter Latest update
Windows Server 2012 R2 Standard, Enterprise and Datacenter Latest update
Windows Server 2012 Standard, Enterprise and Datacenter Latest update
Windows Server 2008 R2 Standard, Enterprise, and Datacenter Latest update
Windows Server 2008 Standard, Enterprise, and Datacenter Latest update

Prior and future updates or service packs on these operating systems are supported unless otherwise stated. The operating system version and updates must also be supported by the operating system provider.

Supported operating systems Latest update or service pack tested

Windows 10 Pro and Enterprise

Last update

Windows 8.1 Pro and Enterprise

Last update

Windows 7 Ultimate, Professional, Enterprise, and Home Premium

Last update

Hardware requirements

The minimum RAM requirement for Data+

Web Server: 4GB.

SQL Server: 8GB

For a production environment, minimum hardware requirements are not listed because the user and business needs of the software may vary. These requirements must be considered in determining hardware needs to meet performance and scalability expectations.

Data+ requires a minimum of 5 GB of available disk space.



Install a compatible SSMS (SQL Server Management Studio) version

Firewall settings

Data+ communicates on ports
HTTP(S) – 80, 433 – according to your implementation.
Email – 25, 587 – according to your mail server.
Required ports: 8443, 22, 1433.

It also requires the ability to communicate with the external domains:

  • packagist.org
  • *.github.com
  • ssl.google-analytics.com
  • www.google-analytics.com
  • *.intercom.io

You’ll need to open the above on your firewall before installing the software. (Git Source)

Domain setup

We usually recommend to create the domain “dataplus.yoursite.com” and redirect “http://dataplus/” to the full URL in order to enable users easy access to the system. You can decide on any domain name.

  1. Log into your IIS server.
  2. Once logged, click Start, select Administrative Tools, and then click Internet Information Services (IIS) Manager.
  3. Under the Connections menu, right-click the server name, and then click Add Web Site.
  4. Enter the following:
    • Site name: dataplus.example.com (where example.com is the name of your domain name).
    • Physical path: Click , and then enter c:\inetpub\wwwroot\DATAPLUS_INSTALLATION_FOLDER\public (where DATAPLUS_INSTALLATION_FOLDER is the name of the folder).
    • Binding: Port 80.
    • Hostname: dataplus.example.com (where example.com is the name of your domain name).
  5. Click OK.


IIS Configuration

  1. Allow PUT and DELETE verbs:
    • Go to Handler Mappings
    • PHPXX_via_FastCGI (XX = the version you are using)
    • Edit (right click) > Request Restrictions > Verbs
    • Add PUT and DELETE to the list


Install SSL certificate

  1. Click Start, mouse-over Administrative Tools, and then click Internet Services Manager.
  2. In the Internet Information Services (IIS) Manager window, select your server.
  3. Scroll to the bottom, and then double-click Server Certificates.
  4. From the Actions panel on the right, click Complete Certificate Request….
  5. To locate your certificate file, click .
  6. In the Open window, select *.* as your file name extension, select your certificate (it might be saved as a .txt, .cer, or .crt), and then click Open.
  7. In the Complete Certificate Request window, enter a Friendly name for the certificate file, and then click OK. For Wildcard SSL certificates make sure your Friendly Name to matches your Common Name (i.e. *.example.com).
  8. In the Internet Information Services (IIS) Manager window, select the name of the server where you installed the certificate.
  9. Click + beside Sites, select the site to secure with the SSL certificate.
  10. In the Actions panel on the right, click Bindings….
  11. Click Add….
  12. In the Add Site Binding window:
    • For Type, select https.
    • For IP address, select All Unassigned, or the IP address of the site.
    • For Port, type 443.
    • For SSL Certificate, select the SSL certificate you just installed, and then click OK.
  13. Close the Site Bindings window.
  14. Close the Internet Information Services (IIS) Manager window. Your SSL certificate installation is complete.


Install PHP / PHP.INI Configuration

If you are using IIS 8, you can install PHP easily with Microsoft’s Guide.
Install PHP, SQL connectors & URL Rewrite. Add the ldap extension and change the configurations.

If you are not using IIS 8 –

  1. Install PHP 7 (NTS – non thread safe)
  2. Install SQL Server extensions (pdo & pdo_sql) – (Microsoft Official Download)  
  3. Enable/Install extensions:
    1. php_mcrypt
    2. php_openssl
    3. php_mstring
    4. php_zip
    5. php_xmlreader
    6. php_simplexml
    7. php_ldap
    8. php_sqlsrv
    9. php_pdo_sqlsrv
    10. php_curl
    11. php_xsl
    12. php_soap
    13. php_fileinfo
  4. Change configurations
    1. max_execution_time = -1
    2. max_upload_size = 100M


Install Git

Validate github connection: https://help.github.com/articles/testing-your-ssh-connection


Install Composer (globally)

Validate composer connection: https://getcomposer.org/doc/articles/troubleshooting.md#general


Add PHP & Git as PATH Variables

  1. Click the Advanced system settings link.
  2. Click Environment Variables. In the section System Variables, find the PATH environment variable and select it. Click Edit. If the PATH environment variable does not exist, click New.
  3. In the Edit System Variable (or New System Variable) window, specify the value of the PATHenvironment variable. Click OK. Close all remaining windows by clicking OK.
  4. Reopen Command prompt window, and run your java code.


Add Scheduled Task

Run this scheduled task every 1 minute.

  1. Enter scheduled tasks.
  2. Create a basic task, repeating daily
    1. Trigger: daily at 12:00:00
    2. Action: run program
    3.  Select php.exe & edit command: artisan scheduled:run
    4. Change the “repeat task every” field to 1 minute. Note: it seems like it’s not an option, but just write “1” or “1 minute”.
    5. save



Make sure to backup Data+ on a daily basis.

Data+ has internal restoring mechanisms for lost data.


Supported web browsers

Data+ requires one of the following web browsers to be installed:

  • Google Chrome
  • Mozilla Firefox
  • Microsoft Internet Explorer (version 10 [basic functionallity], or 11+)
  • Microsoft Edge
  • Safari


Cloud Deployment

You can deploy Data+ in the cloud. Many organizations do this to increase performance and capacity without having to buy and configure new hardware. We provide Data+ virtual machine images on two popular cloud platforms: Amazon Web Services and Microsoft Azure.