Excellent ETL Option for Corporate Data Integration
October 30, 2018

Excellent ETL Option for Corporate Data Integration

Karina Gonzalez | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User

Modules Used

  • InfoSphere DataStage

Overall Satisfaction with IBM InfoSphere Information Server

InfoSphere Information Server is used primarily as a corporate data integration platform. It allows to integrate data from several different commercial and industrial systems. It is a cross-departamental integration platform for extracting, transforming and loading data.
  • Any source to any target support.
  • ETL flexibility without coding.
  • Extreme data volume processing.
  • Native integration with other Data integration functionalities such as data profiling, data cleansing, metadata management.
  • Lack of a strong web development environment.
  • Metadata propagation in Jobs is somewhat complex.
  • The possibility to develop jobs in Parallel and/or Server Engines is confusing.
  • Productivity of the development of integration processes.
  • Better documentation and governance.
  • Reduce training costs of various technologies.
I particularly believe that Information Server, especially DataStage, is superior in many aspects to the Oracle Data Integrator tool. Several market analysts such as Gartner and / or Forrester better position DataStage on the Oracle solution.
Information Server is extremely useful to replace manual developments that require a lot of coding effort. It significantly increases the productivity of the initial development and the future maintenance of the processes since it has a visual development environment with self-documentation.

InfoSphere Feature Ratings

Connect to traditional data sources
Connecto to Big Data and NoSQL
Simple transformations
Complex transformations
Metadata management
Business rules and workflow
Testing and debugging
Integration with data quality tools
Integration with MDM tools
Not Rated