Introduction
What’s in this Guide
The main scope of this document is to let the user understand the VIENNA Advantage installation process and the hosting configuration in a system. The VIENNA Advantage hosting configuration process is just like any normal software application installation in the system.
Preface
Learn how to install and configure VIENNA Advantage, web server configuration, database installation, and perform post-installation tasks.
Audience
This guide is intended for anyone interested in installing VIENNA Advantage.
To use this document, you need the following:
A supported Microsoft Windows operating system is installed and tested on your computer system or network.
Administrative privileges on the computer where you will be installing the application & database.
Knowledge of Installing & Managing RDBMS i.e., Oracle or PostgreSQL
Installation Checklist
Use checklists to review system requirements, and to plan and carry out the installation.
We recommend you use checklists as part of your installation planning process. Using a checklist ensures that your server hardware and configuration meets minimum requirements for this release and enables you to carry out a successful installation.
Server Hardware Checklist for the Installation
Use this checklist to check hardware requirements for installing VIENNA Advantage & Database.
Table 1-1 Server Hardware Checklist for VIENNA Advantage Installation
Requirement | Value |
---|---|
Server Make | VIENNA Advantage can be installed on any machine running Windows OS. The Server can be a Physical Server or Virtual machine running on any cloud or VMWare environment |
System Architecture | Processor: AMD64 and Intel EM64T |
Minimum RAM | 8 Gb or above |
Minimum CPU/vCPU | On Physical Server i5 or above On VM 4 vCPU or above |
Storage | At least 50Gb |
Network connectivity | The Server connects with the internet to register the Application. Network access to the application link is required if connection to Vienna Advantage are to be made. |
Operating System Checklist for Installation
Use this checklist to check Windows OS requirements for installing VIENNA Advantage & Database.
Table 1-2 Operating System Checklist for VIENNA Advantage Installation
Requirement | Value |
---|---|
Operating System General Requirements | VIENNA Advantage is supported on the following operating system versions:
|
Features & Database Checklist for Installation
Use this checklist to check additional software's, features & Database requirements for installation
Table 1-3 OS Features & Database Checklist for VIENNA Advantage Installation
Requirement | Value |
---|---|
Web Browser | Google Chrome browser |
.NET framework | Microsoft .Net framework 4.5 or higher |
Web Server | IIS version 7.0 or higher |
Database (RDBMS) | VIENNA Advantage supports Oracle or PostgreSQL
|
VIENNA Advantage Community Registration.
Community Registration
IIS & .NET Installation
IIS 7.0 or Above is required to configure and run the VIENNA Advantage Application.
To enable IIS and the required IIS components on Windows, complete the following steps.
Open Server Manager and click Manage > Add Roles and Features. Click Next.
Select Role-based or feature-based installation and click Next.
Select the appropriate server. The local server is selected by default. Click Next.
Enable Web Server (IIS) and click Next.
No additional features are necessary to install, so click Next.
On the Web Server Role (IIS) dialog box, click Next.
On the Select role services dialog box, verify that the web server components listed below are enabled. Click Next.
Verify that your settings are correct and click Install.
When the installation completes, click Close to exit the wizard.
Reference Link:
https://docs.microsoft.com/en-us/iis/get-started/whats-new-in-iis-8/installing-iis-8-on-windows-server-2012IIS Web Server Components
Required IIS Web Server components for hosting the VIENNA Advantage Application.
Common HTTP Features
Security
Performance
| Application Development
Application Initialisation Management Tools
|
Database Installation
VIENNA Advantage framework supports 2 different RDBMS, and you can choose either of them.
Oracle
Oracle 12cR2 & 19c database versions are supported.
Make sure Character set is AL32UTF8
Make sure Database deferred segmentation is False before creating new user in database to import database file. (alter system set DEFERRED_SEGMENT_CREATION = false;)
Reference Link: https://www.oracletutorial.com/getting-started/install-oracle/
PostgreSQL
PostgreSQL 12 version is supported.
Make sure Character set is UTF8 before creating new database
Create new database and grant user permission on this database.
Reference Link: https://www.postgresqltutorial.com/install-postgresql/
Download VIENNA Advantage
IIS 7.0 or Above is required to configure and run VIENNA Advantage Application.
Using below link you can download VIENNA Advantage released files and database schema (Oracle or PostgreSQL).
Reference Link: https://www.viennaadvantage.com/installation-packages.php
VIENNA Advantage Installation Sequence
Please follow below Sequence to setup and configure VIENNA Advantage in your environment.
Extract Application and Database dump-file
ViennaAdvantage Database Import
VIENNA Advantage website IIS Hosting instructions
Edit configuration file with database information
Access VIENNA Advantage Application.
Register VIENNA Advantage application.
Install/Update Application/Module.
Extract
Extract Application files from Archive (here we assume to "C:\Tmp\")
Move or copy Folder "C:\Tmp\VIENNA_Advantage_ERP_CRM_HTML5_4_6_3_Oracle\ViennaAdvantageHtml5_HostingFiles\ViennaAdvantage"
TO
Webroot (here we assume "C:\inetpub\wwwroot\")
ViennaAdvantage Database Import
VA Data Import - Oracle
Please follow below steps if you are going to use Oracle Database 12cR2 or above only and not PostgreSQL.
Create VA User in Oracle
Connect to DB via SQLPLUS or SQLDeveloper with sys or system user and execute below commands.(For pluggable database change to the appropriate container first for example using Oracle 21XE: alter session set container = xepdb1)
SQL> alter session set "_ORACLE_SCRIPT"=true;
Result: Session altered.
SQL> create user USERNAME identified by PASSWORD;
Result: User created.
SQL> grant dba, connect, resource , create view to USERNAME;
Result: Grant succeeded.
SQL> alter user USERNAME default tablespace users;
Result: User altered.
SQL> conn USERNAME/PASSWORD
Result: Connected.
SQL>exit
2. Import Data in DB User Schema
Assuming you extracted to "C:\Temp" the oracle dump will be in "C:\Temp\VIENNA_Advantage_ERP_CRM_HTML5_4_6_3_Oracle\ViennaAdvantageHTML5_DB\vacommunity.DMP"
Open command prompt in administrator mode and execute below command to import VA Data in DB user
imp USERNAME/PASSWORD File=’DB-Dump-File-Path.dmp’ Full=Y
Note: Please change USERNAME & Password in above commands as per your requirement
VA Data Import - PostgreSQL
Please follow below steps if you are going to use PostgreSQL Version 12 only and not Oracle DB.
Create VA User in PostgreSQL
Connect to DB via PSQL or PGAdmin4 with postgres user and execute below commands.
postgres=# Create Database DBNAME;
Result: CREATE DATABASE
postgres=# Create user USERNAME with ENCRYPTED PASSWORD 'PASSWORD’;
Result: CREATE ROLE
postgres=# Grant ALL PRIVILEGES ON DATABASE DBNAME TO USERNAME;
Result: GRANT
postgres=# Exit
2. Import Data in created database
Open command prompt in administrator mode and execute below command to import VA Data in database
psql -U USERNAME DBNAME < "DB-Dump-File-Path.sql“
Note: Please change USERNAME & Password in above commands as per your requirement