How many server for my BI project (DW and application)?

Question

I'm currently doing my last year internship. My project is to develop a full BI project for a company.

I'll need to take data from several places (flat files, DB, ...) put it in a DW (that I'll create) and make ad-hoc report. I'll certainly use pentaho or jasper.

I'll have a server (physical) for my DW of course. The question is, can I install the whole BI application on the same server (the ETL, reporting ...) where I put the DW?

If yes shoud I create 2 virtual server on my only physical server or it's useless?

score 1 · Accepted Answer · answered Feb 21 '13 at 06:11

1

You can install Whole BI Application on the same server. You can create several folders for each of BI Component such as BI Server, ETL, Reporting, etc. You needn't create 2 virtual server.

answered Feb 21 '13 at 06:11

bagus prasojo

595
5
18

even my DW can be on that? – joris Feb 21 '13 at 09:34
Yes, your DW can be on that – bagus prasojo Feb 21 '13 at 16:21

score 1 · Answer 2 · answered Feb 22 '13 at 09:40

1

You can also include Ctools plugin into BI Server for better GUI purpose. Saiku and CDE is great you can customize the things in CDE very well. Saiku is kind of next level of bi server so it is very well for you joris.

answered Feb 22 '13 at 09:40

Helping Hand..

2,430
4
32
52

How many server for my BI project (DW and application)?

2 Answers2