Jump to content


Sign in to follow this  
Trung Thanh

Opalis: Install Report

Recommended Posts

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

 

 

Opalis_Install_Report_001.png

 

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.

 

Opalis_Install_Report_002.png

 

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

 

Opalis_Install_Report_003.png

 

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

Opalis_Install_Report_004.png

 

Opalis_Install_Report_005.png

 

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
. ).

Opalis_Install_Report_006.png

 

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

Opalis_Install_Report_007.png

 

After Create, this image like this

Opalis_Install_Report_008.png

 

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

Opalis_Install_Report_009.png

 

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

Opalis_Install_Report_010.png

 

Click Apply to complete, exit IIS.

Opalis_Install_Report_011.png

 

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

Opalis_Install_Report_012.png

 

Sign-in with normal users - doraemon

Opalis_Install_Report_013.png

 

 

Click and see a few reports

Opalis_Install_Report_014.png

 

Opalis_Install_Report_015.png

Notes: Un-happy, because of Opalis 5
yy154.gifyy127.gif

Edit _settings.lgx

Opalis_Install_Report_016.png

 

 

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.

 

 
Opalis_Install_Report_017.png

Have fun !!!

Share this post


Link to post
Share on other sites


Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
Sign in to follow this  

×
×
  • Create New...