System Setup

System landscape requirements

VPN

Preferable L2TP, OpenVPN or other secure VPN to access the application server and database.

Applications Server

Requirement

Description

Requirement

Description

Operating system

Preferable Ubuntu or another unix* without graphical interface installed in virtual machine.

Language: utf-8, en-usa.

If you use Windows environment, you can install unix* under Microsoft Hyper-V.

CPU

4 Cores

Memory

6 GB

Network

Preferable near database server (in same network / switch)

Other

Services: SSH Access
Username: mysales with sudo privileges.

Due to huge data transfer between Application and Database servers, we strongly recommend that you place the application server and the database server side by side so that they are on the same network and connected to the same network switch.

Database

Requirement

Description

Requirement

Description

Requirement

We strongly recommend to use same database as ERP database for easy data exchange and integration. That's why we support all databases:

  • Microsoft SQL Server

  • Oracle

  • PostgreSQL

  • MySQL

  • Oracle Teradata

You can also reduce license costs by using the ERP database for MySales.

Requirement

Depending on the amount of data. Usually 160GB is enough.

We strongly recommend using SSD drive or Storage System.

Requirement

Username: mysales

Separate DB (mysales) or database schema (dbo, msls, mysales)

The main highload on the system falls at night, when forecasts and orders are calculated. Therefore, you can use the ERP database and the ERP application server to install and run the MySales system.

Network Requirements

NodeJS Installation

Ubuntu

sudo apt-get install curl
curl -sL https://deb.nodesource.com/setup_16.x | sudo -E bash -
sudo apt-get install nodejs
sudo npm i n -g

NVM remove

rm -rf ~/.nvm
remove any nvm lines from ~/.bash_profile (and/or ~/.profile)

System setup

Installing the MySales application on the server and creating tables in the database is done by MySales employees.