TrustRadius: an HG Insights company

IBM InfoSphere Information Server

Score8 out of 10

37 Reviews and Ratings

What is IBM InfoSphere Information Server?

IBM InfoSphere Information Server is a data integration platform used to understand, cleanse, monitor and transform data. The offerings provide massively parallel processing (MPP) capabilities.

Top Performing Features

  • Connect to traditional data sources

    Ability to connect to traditional data sources like relational databases, flat files, XML files and packaged applications

    Category average: 8.7

  • Connecto to Big Data and NoSQL

    Ability to connect to non-traditional data sources like Hadoop and other big data technologies, and NoSQL databases

    Category average: 7.7

  • Simple transformations

    Simple data transformations are calculations, data type conversions, aggregations and search and replace operations

    Category average: 8.1

Areas for Improvement

  • Integration with data quality tools

    Integration with tools for cleansing, parsing and normalizing data according to business rules

    Category average: 7.9

  • Testing and debugging

    Tool to debug and tune for optimal performance

    Category average: 6.9

  • Integration with MDM tools

    Integration with master data management tools to ensure data consistency across the organization

    Category average: 7.8

Excellent ETL Option for Corporate Data Integration

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.

Return on Investment

  • Productivity of the development of integration processes.
  • Better documentation and governance.
  • Reduce training costs of various technologies.

Alternatives Considered

Oracle Data Integrator

Other Software Used

SQL Server Integration Services

IBM InfoSphere, product family for your IT family!

Pros

  • IIS best for ETL ,not ELT , and many and diffrent source systems.
  • It also can process big data , unstuctured data
  • It is not only DWH , you can use infosphere for analys and see the bigger architecture of your OLTP systems

Cons

  • Infosphere may improve its logging system. If you dont familier logs of infosphere it's little bit hard to understand

Return on Investment

  • If you don't use all of the product family, it will be expensive. But if you want to plan use all the products and you will position it in the center of your infrastructure ROI will be effective.

Alternatives Considered

Denodo

Other Software Used

Denodo, Oracle Data Integrator

Information Server - A world class Integration Platform

Pros

  • ETL capabilities, integrating data from any source system to any destination.
  • MPP Processing Engine
  • Data Profiling & Data Cleansing capabilities with multi-country support for common data such as names and addresses
  • Metatada management capabilities not only within the platform but also with 3er party tools like BI tools

Cons

  • I would be nice to have a new web development environment for DataStage.
  • Connectivity Packs such as Pack for SAP Application are a little pricey.
  • It is confusing for new developers the possibility of developing jobs using different execution engines such as Parallel or Server.

Return on Investment

  • Information Server can positively impact the costs of companies by increasing the productivity of development and therefore reduce their time and costs. It is estimated that DataStage can increase a developer's productivity by 40% on average.
  • Better data governance
  • Improve data quality and reduce bad data impacts

Alternatives Considered

Informatica PowerCenter

Other Software Used

IBM InfoSphere Information Analyzer, IBM InfoSphere QualityStage

IBM InfoSphere DataStage Review

Pros

  • 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

Cons

  • 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

Other Software Used

IBM InfoSphere QualityStage

Great product but expensive

Pros

  • ETL
  • Parallel processing
  • Address verification using QualityStage
  • Single view of inormation

Cons

  • Parellel processing architecture
  • Big Data
  • Processing of XML

Return on Investment

  • Increased time to market
  • BI Reports available on time