Geek asks and answers

SSIS vs Pentaho

Someone used both of them to provide a good comparison. I am doing a school project, so the cost of SSIS is not a problem, since we already have a license for it.

Background information on what is happening. I will upload about 10 years of patent information in flat files. The result will be 2080 delimited files. I want to upload them to MS SQL server right away. Then I want to be able to add additional files to the database as they are released.

The speed of the software doesn't bother me, as I can just let it work all night. I'm just looking for something with some flexibility and, more importantly, easy enough to use. I have never done such a project before, and I will learn how to do it from the board.

THANK!

+5
source share
2 answers

Used as in real live projects. I prefer Pentaho (PDI) over SSIS because of its ease of use and flexibility. Read a little about this subject before you start using it. There are some great books on the teapot (PDI), or you can just read Getting Started in the PDI's Help menu. The forum is a good place if you are stuck or ## pentaho in the IRC. What also helps are samples that you can find on the welcome screen. I hope you enjoy it, I know that anyway. Used it since 2006, and I'm always angry when I need to use SSIS in some project :-)

PS: use jtds jdbc-driver to connect to db SQL server, this will save you some headaches

Hope this helps,

Bart

+5

ETL PDI SSIS , PDI . , , , .

+1

More articles:


All Articles