Thursday, March 22, 2012

3 tier architecture in Microsoft BI platform

hi,

i would like to check how to implement a 3 tier architecture in Microsoft BI platform.

Components needed for the BI solution:

- MSSQL2005 RDBMS

- MSSQL2005 Reporting Services

- MSSQL2005 Analysis Services

- MSSQL2005 SSIS

- PerformancePoint

- Sharepoint

Basically, i need to put the components into DB tier, App tier and Web tier.

where to i place each component?

thanks.

-

HY

Hello! This is my sugggestion:

SSIS and RDBMS(DB-Tier)

Analysis Services(App tier)

Reporting Services(Both App tier and Web tier)

Performancepoint and Sharepoint(Both App tier and Web tier)

|||

hi,

this is a dilemma i have been facing trying the architecture the solution for customers.

how to minimise licences cost in a 3 tier environment yet coming with a solution that can work and acceptable to customers.

Can this work?

- SSIS, RDBMS (DB)

- Analysis Service, Reporting Service (App)

- Performance Point, Sharepoint (Web)

Concerns:

a) Need IIS for App tier as need to install Reporting Services at App tier.

b) Will Sharepoint at the web tier be able interact with Reporting Service at the App tier?

thanks.

-

HY

|||

Hello! As an example Reporing Services runs as a windows services, store the rdl-files in SQL Server 2005 RDBMS and have a front end in the report manager.

Yes, you can have all applications installed on the same server.

In SQL Server sp2 you have the option to host Reporting Services in Sharepoint and not use the Report Manager.

HTH

Thomas Ivarsson

No comments:

Post a Comment