Great Data Integration Tool for Enterprise Data Integration Projects
December 06, 2018

Great Data Integration Tool for Enterprise Data Integration Projects

Gonzalo Angeleri | TrustRadius Reviewer
Score 9 out of 10
Vetted Review

Overall Satisfaction with IBM InfoSphere DataStage

DataStage is part of the IBM data integration and governance suite and is primarily used as an ETL tool to integrate information at the corporate level. It allows to minimize the development and maintenance times of integration processes by having a totally visual development environment and therefore the cost of these processes.
  • Proven MPP Engine. Excellent performance for integrating data.
  • 100% visual development, operational and monitoring environment.
  • Any source to any target capabilities.
  • Complex transformation capabilities without writing code.
  • Metadada and data quality capabilities.
  • Hybrid deployment (on-prem or cloud).
  • Unified processing engine.
  • Pricing.
  • Reduce development time by 65% compared with hand coding.
  • Reduces ETL process maintenance times.
  • Better data governance for technical and non-technical people.
  • Improve time to market for initiatives that require data integration.
DataStage offers better integration capabilities without the need to write code manually. It also has a native ETL engine whereas MSIS requires a SQL Server. It has better integration capabilities with data quality, data profiling and data governance tools. The main drawback of DataStage vs. MSIS is pricing.
Watson Studio (formerly IBM Data Science Experience), IBM Cognos
Good for:

  • Integration Layer for a Data Mart and Data Warehousing implementation.
  • Batch or near real-time integration processes
  • Big data implementation (integrating non-Hadoop world with Hadoop)

Not so Good:

  • Real time integration

IBM DataStage Feature Ratings

Connect to traditional data sources
10
Connecto to Big Data and NoSQL
8
Simple transformations
10
Complex transformations
9
Metadata management
7
Collaboration
7
Testing and debugging
6
Integration with data quality tools
9
Integration with MDM tools
8