Deployment Guide
Version 1.0
Table of Contents
1
Document Control
1.1
About this document
|
Author
|
|
|
Distribution
|
BI Hosting Team
|
|
Published
|
02/01/2017
|
|
File Location
|
|
|
Status
|
Draft
|
|
Confidentiality
|
This document is confidential and must not be distributed
outside of IMS Health.
|
|
Copyright
|
© 2014 IMS Health Incorporated or its affiliates. All
rights reserved.
|
Changes made to this document
|
Version
|
Author
|
Date
|
Summary
|
|
1.0
|
Chaitanya Boorlagadda
|
02 Feb 2017
|
Document Created
|
1.2
Purpose of this document
This document describes the deployment
steps for the ALD Web application.
1.3
Audience for this document
BI Hosting team.
2
Server Configuration Steps
There are a number of steps required to deploy the
application.
2.1
Install following drivers
·
Microsoft ReportViewer 2010 Redistributabl
·
Microsoft SQL Server 2014 Analysis Management
Objects
2.2
Server Prerequisites
Each Web Application server requires the following:
·
.Net Framework Version 4.0
·
IIS 7.0 with standard Role Features enabled plus
the Management Service
2.3
Kerberos Configuration
·
SPN registration for the ALD URL to the ALD service
account
·
Delegations as follows:
o
Decision Center Service Account to ALD SPN
o
ALD Service Account to Decision Canter SPN
o
ALD Service Account to SSRS SPN
o
ALD Service Account to OLAP server SPN
o
TMG Server Account to ALD SPN
2.4
IIS Configuration
A Web Application needs to be created as follows:
·
In IIS Manager highlight the computername and
select ISAPI and CGI Restrictions
·
Set the ASP.NET
v4 entries to Allow
·
Create a new Application Pool with the following configuration:
o
Name: ALD
o
Classic pipeline mode
o
Service account relevant for that environment (passwords
from BI Hosting Infra Team)
o
.Net Framework version 4.0
·
Create a new empty folder at:
o
C:\inetpub\ALD
·
Create a new Web Application with the following
configuration:
o
Name ALD
o Physical
path: c:\inetpub\ALD
Use the Application pool created above
·
Authentication :
o
ASP.NET Impersonation and windows Authentication
should be enabled
3
Web Application Deployment
·
Checkout the code from Harvest and download locally.
Note that the files will all be read-only. Right click the root folder and
select Properties & take the
read only flag off.
·
Copy the code within the ALD folder from harvest
and paste it in below path:
o
C:\inetpub\ALD
·
Go to IIS and right click and tap on “Add
Application”.
·
Add Alias name as Project name (ALD) and give
the virtual path of the code location (ALD) in Physical Path and provide
External URL has host name based on environment and then click on ok. After
adding the application go to bindings and add another binding as internal URL
|
Environment
|
External URL
|
|
BU Dev
|
http://budev-ald.imsbi.rxcorp.com
|
|
UAT
|
https://uat-ald.imsbi.com
|
|
Sup
|
https://support-ald.imsbi.com
|
|
PROD
|
https://ald.imsbi.com
|
·
Click on Default document and move ‘defalut.aspx’
to top.
·
Go to ALD application folder in IIS, edit
web.config and do the following changes for every specific environment’s
o
Report server path and ReportFolder
(URL’s are listed in the next step, below
is the highlighted where the URL need to be changed
|
Environment
|
ReportServerPath
|
|
BU Dev
|
http://budev-auth.imsbi.rxcorp.com/_vti_bin/reportserver
|
|
UAT
|
http://uat-auth.imsbi.rxcorp.com/_vti_bin/reportserver
|
|
Sup
|
http://support-auth.imsbi.rxcorp.com/_vti_bin/reportserver
|
|
PROD
|
http://authoring.imsbi.rxcorp.com/_vti_bin/reportserver
|
o
In the path \inetpub\ALD\edit web.config in the connection
string based on the environment:
Change the Connection string based
on the environment to allow Web Service connecting to a OLAP Cube
|
Env
|
<ConnectionStrings>
|
|
BU Dev
|
<add
name="cubeSource" connectionString="Data Source=CDTSOLAP937D;Initial
Catalog=WHSVC_UK_M_IMS_1" />
|
|
UAT
|
<add
name="cubeSource" connectionString="Data
Source=CDTSOLAP556U;Initial Catalog= WHSVC_UK_M_IMS_1" />
|
|
Support
|
<add
name="cubeSource" connectionString="Data
Source=CDTSSQL187O;Initial Catalog= WHSVC_UK_M_IMS_1" />
|
|
PROD
|
<add
name="cubeSource" connectionString="Data Source=;Initial
Catalog= WHSVC_UK_M_IMS_1" />
|
o
SQLwrapperconfigdb changes, please contact BI
Hosting infra team for generating a SQL bd account and password and this
account details will not be shared to any ALD teams,
4
SSRS Deployment
4.1
Deploy SSRS Report in SharePoint[c1]
5
Report Subscription db configuration[c2]
steps
6
Appendix A – SSRS URLs
Use the following URLs for SSRS Deployment:
6.1
BU Dev
TargetDataSetFolder:
TargetDataSourceFolder:
TargetReportFolder:
TargetReportPartFolder:
TargetServerURL:
6.2
SIT
TargetDataSetFolder:
TargetDataSourceFolder:
TargetReportFolder:
TargetReportPartFolder:
TargetServerURL:
6.3
UAT
TargetDataSetFolder:
TargetDataSourceFolder:
TargetReportFolder:
TargetReportPartFolder:
TargetServerURL:
6.4
SIT
TargetDataSetFolder:
TargetDataSourceFolder:
TargetReportFolder:
TargetReportPartFolder:
TargetServerURL:
6.5
SUPPORT
TargetDataSetFolder:
TargetDataSourceFolder:
TargetReportFolder:
TargetReportPartFolder:
TargetServerURL:
6.6
PROD
TargetDataSetFolder:
TargetDataSourceFolder:
TargetReportFolder:
TargetReportPartFolder:
TargetServerURL:
No comments:
Post a Comment