presentation 2003 page 1 p-a angenius, wingadd_presentation_2003a.ppt content of presentation these...

Pre

sen

tati

on

200

3

P-A

Ang

eniu

s, W

inG

AD

D_P

rese

ntat

ion_

2003

a.pp

t

Content of presentation

These slides is an introduction to WinGADD applications, April 2003

IntroductionKey issues and functionality publish and export data of the report.

Target databaseGet information for the report from target database.

Technical scenariosUsing PC, Terminal Server or Web Server.

Pre

sen

tati

on

200

3

P-A

Ang

eniu

s, W

inG

AD

D_P

rese

ntat

ion_

2003

a.pp

t

Introduction

Key issues

• Focus on that it should be easy for any user to create and use a report. No education should be needed.

• Generic application that can connect to any database using ODBC or customised API.

• Has a query database that contains query information and also a user database that can be central or local.

• Main query information is; target database information and an SQL statement. Having a SQL statement is having a fully functional report. Then query formatting parameters can be defined to get a graph, sub-totals, cube etc.

• Very easy to change or add a new report.

Pre

sen

tati

on

200

3

P-A

Ang

eniu

s, W

inG

AD

D_P

rese

ntat

ion_

2003

a.pp

t

• Present the report as a graph and cube.

• Quickly preview and print the report without adjustments from the user.

• Save the report as HTML for publishing on the Intranet.

• Export the report as PDF for e.g. Acrobat Reader.

• Export the report to EXCEL for e.g. further analysing. Define post calculation in EXCEL that is unique for each report.

• Manually or automatically export to MS Access.

• Save result as ADO recordset, micro-cube and other formats to interact with web solutions.

Introduction

Functionality - Publish and Export data of the report

Pre

sen

tati

on

200

3

P-A

Ang

eniu

s, W

inG

AD

D_P

rese

ntat

ion_

2003

a.pp

t

1st TargetDatabase

Display Report

Reports can contain data from one orseveral databases (Target Databases).

The user does not need to know where(what database) the data is retrieved from.

2nd TargetDatabase

3rd TargetDatabase

4th TargetDatabase

Reports can contain data from one or several databases

Target database - Data from different databases

Pre

sen

tati

on

200

3

P-A

Ang

eniu

s, W

inG

AD

D_P

rese

ntat

ion_

2003

a.pp

t

1st TargetDatabase

Display Report

Target database can be user dependent if thereexists many installations on e.g. regional, countryor local level. The user is connected to one of thedatabases dependent on user settings.

2nd TargetDatabase

3rd TargetDatabase

1st TargetDatabase

1st TargetDatabase

User dependent target database

Target database - Different databases for different users

Pre

sen

tati

on

200

3

P-A

Ang

eniu

s, W

inG

AD

D_P

rese

ntat

ion_

2003

a.pp

t

Data is collected from several databasesand saved in a temporary storage. Thecollected data is presented in one reportcontaining all data.

The user do not need to know that thedata is collected from several databases.

TemporaryStorage

Display Report

2nd TargetDatabase

3rd TargetDatabase

Collecting data from different target databases

1st TargetDatabase

Target database - Many databases – One report

Pre

sen

tati

on

200

3

P-A

Ang

eniu

s, W

inG

AD

D_P

rese

ntat

ion_

2003

a.pp

t

WinGADD

ApplicationServer

PC/Windows

ApplicationDatabase

Datawarehouse

PC/Windows

PC/Windows

WinGADD

WinGADD

WinGADD installed on a PC/Windows. Data retrieved from applicationdatabase and data warehouse via WAN or LAN and using ODBC.

WinGADD installed on the client PC

Technical scenarios – PC

Pre

sen

tati

on

200

3

P-A

Ang

eniu

s, W

inG

AD

D_P

rese

ntat

ion_

2003

a.pp

t

Terminal Server

Thin Client

WinGADD

ApplicationServer

ApplicationDatabase

Datawarehouse

Thin Client

Thin Client

WinGADD installed on a terminal server using thin client. Data retrieved fromapplication database and data warehouse via WAN or LAN and using ODBC.

WinGADD installed on terminal server

Technical scenarios – Terminal Server

Pre

sen

tati

on

200

3

P-A

Ang

eniu

s, W

inG

AD

D_P

rese

ntat

ion_

2003

a.pp

t

Web Browsere.g. IE 5.0

AutoGADD

ApplicationServer

ApplicationDatabase

Datawarehouse



NT / Windows 2000ServerAutoGADD installed on a NT/Windows 2000.

Reports created by AutoGADD is published onthe Intranet and available via Web Browser.AutoGADD started manually of via scheduling.

AutoGADD to create and publish reports on the Intranet

Technical scenarios – AutoGADD and Web browser

Pre

sen

tati

on

200

3

P-A

Ang

eniu

s, W

inG

AD

D_P

rese

ntat

ion_

2003

a.pp

t

ApplicationDatabase

Datawarehouse

NT / Windows 2000 ServerMS Internet Information Server


WebGADD

ApplicationServer

ApplicationDatabase

Datawarehouse


WebGADD installed on a NT/Windows 2000Server that runs MS Internet InformationServer. Clients uses Internet Explorer to useWebGADD and create and analyze reports.

WebGADD consists of ActiveX objects andASP. WebGADD retrieves data using ODBCand sends it to the client using html/http.

WebGADD using Internet Explorer and Microsoft Internet Information Server

Technical scenarios – WebGADD

Pre

sen

tati

on

200

3

P-A

Ang

eniu

s, W

inG

AD

D_P

rese

ntat

ion_

2003

a.pp

t

WebGADD used to create individualreports and to retreive and displaycommon reports that areautomatically created and publishedby AutoGADD.

AutoGADD

ApplicationDatabase

Datawarehouse

NT / Windows 2000 ServerMS Internet Information Server


WebGADD

ApplicationServer

ApplicationDatabase

Datawarehouse


WebGADD and AutoGADD

Technical scenarios – WebGADD and AutoGADD

presentation 2003 page 1 p-a angenius, wingadd_presentation_2003a.ppt content of presentation these...

Documents