Opalis: Install Report

[Trung Thanh]

In this topic, I install Reports for Opalis Integration Server, this install is more easy than Operation Console

 

Opalis Report is built inLogiXML LGX Report, and can find in the directory of Opalis source, with the name Reports

 

 

 

Having two sub-directories, SQL and Oracle - database type which used for data store of Opalis, copy the folder Opalis to others folder where we want to setup a website. Example, C:\inetpub\wwwroot.

 

 

At nex, open file _Settings.lgx in Opalis | _Definitions - this file is used to define connection to database, and others files with aspx extension is used the conneciton defined to get data from database

 

 

Find tag <Connection > </Connection> and modify the content of <Connection Type="Application" ...>, see in below (modify selected the high-light only).

 

 

Notes: the content of modify is based on set up of SQL Server with

Windows Authentication

,

Data Store

is

the name of server,

Initial Catalog

is the

name of database

. ).

 

Open IIS Management, expand Default Website right-click on Opalis choose Properties

 

On Tab Directory, in Application Settings, click Create allow Opalis folder is execute as application

 

After Create, this image like this

 

click Tab Documents, click Add, add file-type Default.aspx, and Move-up to top:

 

On Tab Directory Security, click Edit in Authentication and Access Control, uncheck Enable Anonymous Access and check Integrated Windows authentication

 

Click Apply to complete, exit IIS.

 

Open Internet Explorer, type http://localhos/Opalis, type username: administrator and password in dialogure:

 

Sign-in with normal users - doraemon

 

 

Click and see a few reports

 

Notes: Un-happy, because of Opalis 5

Edit _settings.lgx

 

 

Notes: because Administrator has the db_owner role, so that he can see reports,but if we want normal users to see report, we need to add them with db_datareader on Opalis Database.

 

 

Have fun !!!