| Table of Contents | ||||||
|---|---|---|---|---|---|---|
|
Introduction
What’s in this Guide
...
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 userUSERNAMEidentified byPASSWORD;
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> connUSERNAME/PASSWORD
Result: Connected.
SQL>exit
2. Import Data in DB User Schema
...
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
...
VA Website Hosting in IIS
IIS Manager
Open IIS Manager to host VIENNA Advantage files in IIS server
Goto Start >> Windows Administrative Tools >> Internet Information Service (IIS)
...
Add VA Website in IIS
Right click on “Sites” and Select “Add Website”
...
Website Name & Physical Path
Site Name: Enter Name as VA-APP
Physical Path: Browse the location where Vienna Advantage downloaded application files are extracted. (Assuming you moved them to webroot use "C:\inetpub\wwwroot\ViennaAdvantage")
Binding: Select type as http, and Port where you want run this website. Please make sure that port is open on firewall and accessible via internet.
Start Website: Check/Enable Start Website Immediately box
Please refer screenshot for more details and Click OK
...
Setup Application Pool
Click on Application Pool >> Right click on corresponding application pool (same name as website name) >> Select Advance settings.
...
Update Identity Settings
Update Identity settings by clicking button(…)
select Network Services under Build-in Account and Click OK.
...
Advanced Settings changes
Set .Net CLR Version to Framework base version to v4.0.
Set 'Enable 32-Bit Applications' to ‘False'.
Set idle time out >= 20
Click OK
...
Edit Website Permissions
Please verify and update below settings under Advance Setting window.
Goto Sites on Left pane
Right click on the Website and choose 'Edit Permissions’.
Give Full Control access to ‘Network Service’ and ‘IUSR’.
Click OK
...
Update web.config with DB info.
Goto the physical location where VIENNA Advantage application and Open web.Config file in notepad for edit.
(Assuming you moved them to webroot use "C:\inetpub\wwwroot\ViennaAdvantage")
Update below highlighted entries in web.config as per your environment and Database information
Oracle DB web.config Changes
<add key="oracleConnectionString" value="Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVI CE_NAME=orcl));User Id=USERNAME;Password=PASSWORD" />
PostgreSQL DB web.config Changes
<add key="postgresqlConnectionString" value="Server=localhost;Port=5432;MaxPoolSize=100;SearchPath=public;User Id=USERNAME;Password=PASSWORD;Database= DBNAME" />
Note: In above example we have used default Port, and Service_Name or Server as per Oracle & PostgreSQL, Please update these values according to DB configuration in your environment.
...
Access VIENNA Advantage
Create incoming rule for port (if you want to allow on the network). Allow port you selected when adding the website through window firewall.
To access VIENNA Advantage Application please open Google Chrome Browser.
Type website url with port# in browser as below http://ipaddress:port/
VIENNA Advantage Application Login Details
...
System Administrator's credentials
Super username: SuperUser
Super user password: System@123
Demo Environment credentials
Demo username: IdeasIncAdmin
Demo user password: IdeasIncAdmin
Demo company name: Ideas Inc
...
Register VIENNA Advantage
After Successful login into VIENNA Advantage application You will be prompted to enter Key.
Enter the Market Key you have/copied from VIENNA Advantage Community Portal Dashboard, or get it by visiting https://login.viennaadvantage.com/login.aspx
...
The VIENNA advantage application is now hosted successfully in the system.
...
About VIENNA Advantage Market
...