MASTERSAF DW

BASIC INFRASTRUCTURE
MASTERSAF DW BASIC INFRASTRUCTURE

TABLE OF CONTENTS

THAT VALUES [MASTERSAF DW] BRING TO YOU?

INTRODUCTION .......................................................................................................... 4
MASTERSAFDW FEATURES ....................................................................................... 4
MASTERSAFDW COMPONENTS ................................................................................ 4
DATABASE SERVER (COMPULSORY) ..................................................................... 4
WORKSTATIONS (COMPULSORY) .......................................................................... 4
APPLICATION SERVER (OPTIONAL) ....................................................................... 4
ORACLE CLIENT (COMPULSORY) ........................................................................... 5
MASTERSAFDW APPLICATION (COMPULSORY) ...................................................... 5
HARDWARE AND SOFTWARE REQUIREMENTS....................................................... 5
DATABASE SERVER ................................................................................................. 5
Operational systems .............................................................................................. 5
Oracle Server.......................................................................................................... 5
File Server .............................................................................................................. 6
APPLICATION SERVER ............................................................................................ 6
Operational System ............................................................................................... 6
Software for application administration................................................................ 6
Oracle Client .......................................................................................................... 6
WORKSTATIONS ......................................................................................................... 6
OPERATIONAL SYSTEM .......................................................................................... 6
Oracle Client .......................................................................................................... 7
BASIC STRUCTURE ..................................................................................................... 7
CONFIGURATION 1: CLIENT/SERVER OPTION ....................................................... 8
BENEFITS: ................................................................................................................ 8

Version: 11
MASTERSAF DW BASIC INFRASTRUCTURE

CONFIGURATION 2: CLIENTE/SERVIDOR OPTION WITH FILE SERVER ............... 9

BENEFITS ................................................................................................................. 9
CONFIGURATION 3: USING AN APPLICATION SERVER ...................................... 10
BENEFITS ............................................................................................................... 10
MINIMUM RECOMMENDATION ................................................................................ 11
CONSIDERATIONS .................................................................................................. 11
HARDWARE RECOMMENDATIONS .......................................................................... 11
WORKSTATION DESKTOP ...................................................................................... 11
APPLICATION SERVER ........................................................................................... 11
BASIC CONFIGURATION OF A DATABASE SERVER ................................................ 12
DATA VOLUME ........................................................................................................ 12
DATABASE SERVER ................................................................................................ 12
SUGGESTION FOR CONFIGURATION ....................................................................... 12

Version: 11
MASTERSAF DW BASIC INFRASTRUCTURE

INTRODUCTION

This document describes the basic infrastructure for the operation of Mastersafdw application.

MASTERSAFDW FEATURES

Mastersafdw is a Data Warehouse which uses Oracle as a database administrator and programs written in
Power Builder, acting as client, therefore, being a client/server application.
Due to these features, the system requires a large capacity from the processor, communication line
(network), in addition to a continuous database tuning work.

MASTERSAFDW COMPONENTS

DATABASE SERVER (COMPULSORY)

Machine where the Oracle Database Administrator will be installed. This server must have enough disks
and processors to support Mastersafdw requirements.
NOTE: We recommend that the Database Server is unique to mastersafdw.

WORKSTATIONS (COMPULSORY)

Machine with Windows 7 which will be used by the Mastersafdw application users to operate, process and
extract reports from the system.

Note: Mastersafdw is not compatible with Windows 2000.

APPLICATION SERVER (OPTIONAL)

Machine with Windows (2003 or 2008), which will be used as a File Server, thus centralizing the storage
of Mastersafdw application’s executable programs.
The main benefit of this server is to prevent the programs from being saved in each workstation, which
will impair possible updates.

SApplication Server (optional)

Version: 11
MASTERSAF DW BASIC INFRASTRUCTURE

Machine with Windows (2003, or 2008), or TS (Terminal Service) and Metaframe, which may be used as
an application server, centralizing application processing. In this case the workstations start operating
as terminal only.
With this server, in addition to application and processing centralization, the remote users will have the
greater benefits, since the processing will be carried out locally.

ORACLE CLIENT (COMPULSORY)

Despite not being a Mastersafdw package component, the Oracle Client is essential for the operation of
the Mastersafdw application. It is through the same that there is communication between the workstation
and/or the application server and the Database Server.
Note: The use of the Oracle Client 32 bits is compulsory. If the operating system is Windows 7 or Windows
2008 is required using the version of Oracle 11g Release 2, preferably [Link] or higher.
Any version less than 11 g Oracle is no longer supported.

MASTERSAFDW APPLICATION (COMPULSORY)

The Mastersafdw application is the component installed in the workstations/application server, being
comprised by programs written in Power Builder, which provide the visual interface of the products.
The entire processing and report generation actions are commanded by these programs.

HARDWARE AND SOFTWARE REQUIREMENTS

DATABASE SERVER

Operational systems

All 64-bit Operational systems supported and accredited by Oracle Server 11g Release 2 will be accepted,
preferably UNIX-Like.
For further information refer to Oracle at [Link]

Note: When using Windows, use Server instead of Desktop versions.

Oracle Server

Version: 11
MASTERSAF DW BASIC INFRASTRUCTURE

 Oracle Server 11g ([Link]) STD 64 bits.

The supported Oracle Database must be 11G Release 2 (64 bits).

File Server

 Windows 2003, Windows 7 and Windows 2008 as operational system.

APPLICATION SERVER

Operational System

 Windows 2003, Windows 7 and Windows 2008.

Software for application administration

 Terminal Service
 Citrix Metaframe version 1.8 or higher.

Oracle Client

 Oracle Client 11g up to Release 2 (32 bits compulsory).

 If operating system is Windows 7 and / or Windows 2008, it is mandatory to use Oracle 11g Release
2

WORKSTATIONS

OPERATIONAL SYSTEM

The following operational systems are accepted:

 Windows 2003
 Windows 7
 Windows 2008.

Note: Mastersafdw is not compatible with Windows 2000.

Version: 11
MASTERSAF DW BASIC INFRASTRUCTURE

Oracle Client

 Oracle Client 11g (32 bits compulsory)

 If operating system is Windows 7 and / or Windows 2008, it is mandatory to use Oracle 11g Release 2.

Note: In case an application server is used, the installation of Oracle Client at the workstations will not be
necessary.

BASIC STRUCTURE

Transaction Systems (ERP)

Local Users

Server (optional)

Application Server

Interface

MasterSAF

Database Server Remote Users

Version: 11
MASTERSAF DW BASIC INFRASTRUCTURE

CONFIGURATION 1: CLIENT/SERVER OPTION

Local Users
MasterSAF

Database Server

Remote Users

BENEFITS:

 Good performance at program loading when both layers are hosted in the same LAN
 Simple structure
 Low investment.

What is installed in the Database Server:

 Oracle Server
 Mastersafdw Database Objects
 Memory_target = 10G
 CHARACTERSET = WE8MSWIN1252
 NLS_LENGTH_SEMANTICS = BYTE (Default).

Note: Both the database server and the Oracle instance must serve ony the Mastersafdw application.

What is installed in the workstations

 Oracle Client compatible with operational system

 Mastersafdw Application

Version: 11
MASTERSAF DW BASIC INFRASTRUCTURE

CONFIGURATION 2: CLIENTE/SERVIDOR OPTION WITH FILE SERVER

Local Users

File Server

MasterSAF DW

Remote Users

BENEFITS

 Program centralization
 Maintenance in a single place.

What is installed in the Database Server:

 Oracle Server
 Mastersafdw Database Objects
 Memory_target = 10G
 CHARACTERSET = WE8MSWIN1252
 NLS_LENGTH_SEMANTICS = BYTE (Default).

Note: Both the database server and the Oracle instance must serve ony the Mastersafdw application.

What is installed in the workstations

 Oracle Client compatible with operational system

 Shortcuts for Mastersafdw Application.

What is installed in the file server

 Mastersafdw Application.

Version: 11
MASTERSAF DW BASIC INFRASTRUCTURE

CONFIGURATION 3: USING AN APPLICATION SERVER

Local Users

Application Server

Remote Users

MasterSAF DW

BENEFITS

 Program centralization
 Maintenance in one single place
 Good performance for remote users
 Low investment in workstations.

What is installed in the Database Server:

 Oracle Server
 Mastersafdw Database Objects
 Memory_target = 10G
 CHARACTERSET = WE8MSWIN1252
 NLS_LENGTH_SEMANTICS = BYTE (Default).

Note: Both the database server and the Oracle instance must serve ony the Mastersafdw application.

What is installed in the workstations:

 Client Metaframe
 Client Terminal Service.

What is installed in the application server:

 Mastersafdw Application
Version: 11
MASTERSAF DW BASIC INFRASTRUCTURE

 Oracle Client 11g 32 bits up to Release 2

 Citrix Metaframe (optional, IF using application administration tool).
 Terminal Service Server.

MINIMUM RECOMMENDATION

CONSIDERATIONS

The recommendations contained in this document are minimum configurations for the Mastersafdw
system processing, not taking into consideration the level of service desired by the client and separating
all further technical components of the infrastructure used.
TSL is not held responsible for performance or configuration difficulties in the equipment acquired by
client, even if, it has somehow suggested a certain configuration.
We warn that the equipment or configurations contained in this document have to be revised on a
yearly basis, and, if necessary, equipment upgrades or replacement have to be carried out. It is
extremely important that the equipment chosen for the solution installation is scalable.
We also remind that these recommendations are for equipment used solely by the Mastersafdw
application, with the software versions contained in this document.

HARDWARE RECOMMENDATIONS

WORKSTATION DESKTOP

– Pentium Dual Core Processor 2.0 Ghz or Higher

– 2 GB RAM
– 10 GB free space in disk
– Windows 2003, Windows 7 and Windows 2008
– Clearance of SMTP Protocol in the Workstation to send wage and tax statement.

APPLICATION SERVER

– 1 Xenon Dual Core 2.0 Ghz or Higher

– Minimum 4 GB RAM
– 20 GB of free space in disk
– Windows 2003, Windows 7 and Windows 2008
– Terminal Service and/or Citrix Metaframe 1.8 or higher.

Version: 11
MASTERSAF DW BASIC INFRASTRUCTURE

BASIC CONFIGURATION OF A DATABASE SERVER

DATA VOLUME

We recommend an analysis of the data volume in order to enable base sizing.

The recommendations below are for the following data volume (e.g., 40 GB per year).

DATABASE SERVER

 Intel Platform:

– Oracle [Link]
– 2 Xenon Dual Core 2.0 GHz processors or AMD Opteron Dual Core 2.0 GHz or higher
– 16 GB RAM
– 2 73 Gb SAS/RAID 1 Disks.
– Operational system compatible with Oracle [Link].

 Risc Platform

– Oracle [Link]
– 16 GB RAM
– 4 Processors/Core
– 2 73 Gb Raid 1 Disks
– Operational system compatible with Oracle [Link].

SUGGESTION FOR CONFIGURATION

If applicable, TSL may suggest a minimum Database server configuration for Mastersafdw. In this
case, please send a request to your Business Representative or Account Manager.
In order to calculate the disk space and the Database server configuration, it is necessary to fill in a
questionnaire in which the company’s monthly flow volume will be informed.

For further clarifications on this document, please contact:

[Link]@[Link].
Tel: 21 3094-9304

Version: 11