ETL Informatica vs DataStage

[ycarmi]

I am technological manager in a large DW project to be deployed on NCR TeraData. The operational data will be extracted from IBM 390 MVS Mainframe.
Where i live(not the US) there are thiese 2 runnerups and i would like to learn about your experiance that could help me make a decision

 

[aalmeida]

What you need to know? it seems to ma as a clasic enviroment AL Almeida
NT/DB Admin
"May all those that come behind us, find us faithfull"

 

[aalmeida]

What do you need to know? it seems to me as a clasic enviroment AL Almeida
NT/DB Admin
"May all those that come behind us, find us faithfull"

 

[ycarmi]

I want to know which is the better tool for us

 

[aalmeida]

Due to the use Of Mainframe I would be tepted to say use UDB DB2 from IBM, it would give you an advantage that it is the same engine and programing language cros platform (NT, Linux, Unix, AS400 and AS390) it gives an enourmous advantage to reduce the deployment time and also the maintenance after deploymente.
For Designing tool there is CA's ERwin,

http://www.Embarcadero.com

and BMC software, the last one is the most traditional of all these tools

http://www.bmc.com

or

http://www.dbzine.com

AL Almeida
NT/DB Admin
"May all those that come behind us, find us faithfull"

 

[Guest_imported]

I can't speak for Informatica, but I can tell you that we have used DataStage with great success in the IBM 390 environment. DataStage will run on the mainframe and generates COBOL code and JCL ready to be run on the mainframe environment. With many other ETL tools, you end up downloading files to the client server where the tool can process it. With DataStage, you can create and run jobs in both environments. This allows you to apply business rules to take advantage of the mainframe horsepower and to send only the resultant set to the server without encountering network bottlenecks.

 

[aalmeida]

Where I can get some info on DatStage I've not use it AL Almeida
NT/DB Admin
"May all those that come behind us, find us faithfull"

 

[Guest_imported]

We are in the beginning stages of using datastage, and it seems to be working well for us. You can find datastage info at

http://www.ascentialsoftware.com.

Angela