Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

How to choose solution

How to choose solution

How to choose solution

I want to ask how to choose the best solution to implement a datawarehouse?
Should i choose the ETL and OLAP and datawarehouse or i can use the thechonologie that include all the compounds (etl olap...) like teradata or satatistica
Thank you.

RE: How to choose solution

The 'best' would depend on a host of factors, many of a non-technical nature. Your question is a bit vague.. Are you asking whether you should go for a one-shop solution?

Ties Blom

RE: How to choose solution

Agree with blom0344 that there is no way we can help with a recommendation without considerable detail. The most important factor is - "Why do you need to build the DW?". aka, the Requirements. Secondary considerations include the company strategy, company culture, amount of technical knowledge of the user community (what tools?).

I remember working for one company in the late 1990's that wanted me to build them a DW. I asked them why and their reply was that "The CEO heard about it on the golf course from other CEOs and decided that he wanted one". Not a solid strategic decision, but the project definitely had support from the top!

THAT SAID, #1 question is WHY DO YOU NEED A DATA WAREHOUSE? To dig a little deeper, check this old FAQ I wrote:

The reasonable man adapts himself to the world. The unreasonable one persists in trying to adapt the world to himself. Therefore all progress depends on the unreasonable man. - George Bernard Shaw

RE: How to choose solution

When budget is tight and you want to prototype from scratch I would recommend you check out Pentaho community editions of both ETL and Analytics. Currently working with PDI (Pentaho ETL solution) which is such a real pleasure to develop with. It compares favourably with - for instance - SSIS and it supports many platforms/databases.

Ties Blom

RE: How to choose solution

thanks for your reply it was interstant.
What kind of DBMS should i choose to work with Pentaho and have you a documentation to install Pentaho and deploy a datawarehouse.

RE: How to choose solution

The open source community uses mostly MySQL , the opensource version of Pentaho PDI only needs to be unzipped to a location. PDI works with 42 different databases , so you can pick your choice.

No, there is no such thing as 'a' document for deploying a datawarehouse. There are lots of books on the subject, but I do wonder if you're in the right business

Ties Blom

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close