IBM InfoSphere DataStage Review | TrustRadius

Use Cases and Deployment Scope

We have used DataStage for many years to be able to create the integrations for the loading of the DW or migrations in different companies of different industries

Pros and Cons

It is very strong to make transformations/data derivations
It is very easy to connect to various external data sources. It has an interface (stages) for each connection that simplifies the task
It is a stable platform. And that parallelism helps make it fast for loading, if the process is well designed

Schedule of the processes
Process versioning
Deploy of versioned processes between environments. Revision of previous versions

Return on Investment

I do not measure that kind of data, since I did not define its acquisition

Alternatives Considered

Oracle Data Integrator

DataStage is more robust and stable than ODI
The ability to perform complex transformations or implement business rules is much more developed in DS

Other Software Used

IBM InfoSphere QualityStage

Likelihood to Recommend

Well suited:

Handling large amounts of data
Complex processes that require high levels of transformation
Connections to different data sources

Less appropriate

To use it as a workflow for execution of stored procedures
For file manipulation