Solved

Choice of ETL tool. Datastage, Informatica or SSIS?

Posted on 2008-10-06
5
7,567 Views
1 Endorsement
Last Modified: 2016-04-18
Hello

I work in one of the largest financial institutions in Denmark, in BI/Datawarehouse development. Currently we use Datastage XE as ETL tool. The licenses are soon to expire. I participiate in an evalution process, where the options are to upgrade the Datastage to EE or change to Informatica 8.6 or Microsoft SQL Server Integration Services. Are there anyone out there that have had the oportunity to work with (or evaluated) two (or all) of these, and could give me some key points for consideration?

Our Databases:
DB2 on mainframe (Business systems and EDW/Datamarts)
Oracle (Business systems and Datamarts
Essbase

Current ETL tools:
Datastage XE (Mainframe and Server)
Informatica 7 (limited use - for Siebel only)
(SAS)

Front end
Hyperion + others

Other
- Our EDW is a 2nd generation EDW (Bill Inmon) where information from various companies (our own banks, property loans (direct loans and through partner banks), insurance, property trade, currency and stock trade etc.) is or will be stored.
- Between the EDW and the Datamarts is a legalization layer to separate information where legal requirements dictates it. Also, between the EDW and the Datamarts is a physical Distribution layer.
- We also use LAMP (Linux-Apache-My SQL-PHP) We use Oracle instead of My SQL

Key points:
- Datastage XE wiil no longer be developed/supported by IBM. Porting to Datastage EE means rewriting all ETL jobs. Therefore, we expect to have to rewrite no matter what tool we select.
- Due to our type of business, the requirements for data quality  is high. Built in Data quality handling in the ETL tool would be an advantage.
- The tool have to be able to read/write DB2, Oracle and Essbase.

I would appreciate it
- if you have worked with (or evaluated) two (or all) of these, and could give me some key points for consideration.
- have practical experience in reading/writing to DB2 and/or Oracle and/or Essbase

Thanks a lot for your time

Kind regards
Øyvind Strøm
1
Comment
Question by:OyvindS
5 Comments
 
LVL 7

Assisted Solution

by:grzessio
grzessio earned 100 total points
ID: 22648210
personally:
1) I wouldn`t even consider ssis (you have no microsoft databases).
2) maybe Oracle Data Integrator would be good choice (almost all of your systems is oracles).
0
 
LVL 37

Accepted Solution

by:
momi_sabag earned 200 total points
ID: 22648304
hi
i had work with informatica vesion 7 to load data into db2 and into oracle and i can tell you it was a very good tool.
it is very good in terms of performance.
i wouldn't use SSIS since it requires a SQL Server installation and can only run on a windows server
i believe informatica is a good choice for your need
informatica also enables you to do modular development (you can reuse process that you develop so it can shorten your development time)
0
 
LVL 1

Assisted Solution

by:asksigh
asksigh earned 200 total points
ID: 22648471
if you are a large enterprise you should conider ab-initio.  It's expensive but it is truely parallel and fast.  I worked with a client who replaced datastage with ab-initio.  Development becomes GUI based.  It was a stable and dependable service.
0
 

Expert Comment

by:JadedCee
ID: 35353385
Based upon an evaluation of DataStage, Informatica, IWay, Business Objects Data Integrator SQL Server Integration Services and Oracle Data Integrator, I would say that the easiest tool to use in the Business Objects Data Integrator.  Even the most inexperienced user can develop ETL flows that work.  Informatica works with the broadest base of data types and SSIS provides the biggest bang for the buck.  DataStage is just too slow and could not keep up with our daily workload. With IWay you have to buy too many connectors for most environments.  Oracle DI is just too limited in data targets.  Also tried Ketl and Talend which work well for conversions, but I would not trust them for large volume production.

Each product has differing sets of transforms and you need to pick between them to get the tools set that fits your technology set, data quality profile and need for debugging and automation.  Informatica ran a benchmark that they published and quickly withdrew that showed SSIS as the speed leader.
0
 

Expert Comment

by:DanielleITCentralStation
ID: 41554664
You might find real user reviews for DataStage, Informatica, SSIS and all the other major data integration tools on IT Central Station to be helpful: https://goo.gl/49rv0Q

Users interested in ETL tools also read reviews for Oracle Data Integrator. This Hyperion Applications Manager writes in her ODI review, "This is the only ETL tool I have used and never found a need to look for another. It met all our needs." You can read the rest of her review here: https://goo.gl/wVJBv7
0

Featured Post

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Viewers will learn how the fundamental information of how to create a table.

706 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now