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.

Pros

  • 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.

Cons

  • 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.

IBM InfoSphere Information Server Feature Ratings

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

Comments

More Reviews of IBM InfoSphere Information Server